2 queries found for "Characteristic Type Language"

Retrieve Account Effective Characteristics

SELECT
C.CHAR_TYPE_CD,    
C.DESCR,
A.CHAR_VAL,
A.ADHOC_CHAR_VAL,
A.CHAR_VAL_FK1,
A.CHAR_VAL_FK2,
A.CHAR_VAL_FK3,
A.CHAR_VAL_FK4,
A.CHAR_VAL_FK5
FROM
    CI_ACCT_CHAR A, 
    CI_CHAR_TYPE B,
    CI_CHAR_TYPE_L C
WHERE
    A.ACCT_ID = 'INSERT_ACCOUNT_ID'
    -- Can include a specific type
    [ AND A.CHAR_TYPE_CD = 'INSERT_CHAR_TYPE']
    AND B.CHAR_TYPE_CD = A.CHAR_TYPE_CD
    AND B.CHAR_TYPE_CD = C.CHAR_TYPE_CD
    AND C.LANGUAGE_CD = 'INSERT_LANGUAGE_CD_MOSTLY_ENG'
    AND A.EFFDT = (SELECT MAX(D.EFFDT) 
                          FROM CI_ACCT_CHAR D
                         WHERE D.ACCT_ID = A.ACCT_ID
                         AND D.CHAR_TYPE_CD = A.CHAR_TYPE_CD
                           AND D.EFFDT <= SYSDATE)
                          

uploaded by Nuno Rodrigues

Retrieve Char Types applied on a specific FA Type

select a.*,b.descr from CI_CHTY_FATY a, ci_char_type_l b
where a.fa_type_cd='INSERT FA TYPE CODE'
and a.char_type_cd=b.char_type_cd

uploaded by Muhammad Junaid