3 queries found for "Account Characteristics"

Get all from Account Characteristics

select * 
from CI_ACCT_CHAR

uploaded by Nuno Rodrigues

Get specific Account Characteristics

select * 
from CI_ACCT_CHAR
where 
ACCT_ID = 'XXXX' and CHAR_TYPE_CD  = 'XXXX'

uploaded by Nuno Rodrigues

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