Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AST_PARTY_CLASSIFICATION_V |
SELECT COD.CODE_ASSIGNMENT_ID
, COD.OWNER_TABLE_NAME
, COD.OWNER_TABLE_ID
, COD.CLASS_CATEGORY
, TYPE.DESCRIPTION
, COD.CLASS_CODE
, LKUP.MEANING
, COD.PRIMARY_FLAG
, COD.IMPORTANCE_RANKING
, COD.START_DATE_ACTIVE
, COD.END_DATE_ACTIVE
, COD.STATUS
, COD.CREATED_BY
, COD.CREATION_DATE
, COD.LAST_UPDATE_LOGIN
, COD.LAST_UPDATE_DATE
, COD.LAST_UPDATED_BY
, COD.OBJECT_VERSION_NUMBER
, COD.CREATED_BY_MODULE
, COD.APPLICATION_ID
, COD.RANK
FROM HZ_CODE_ASSIGNMENTS COD
, HZ_CLASS_CATEGORIES CAT
, AR_LOOKUP_TYPES TYPE
, AR_LOOKUPS LKUP
WHERE COD.CLASS_CATEGORY = CAT.CLASS_CATEGORY
AND COD.OWNER_TABLE_NAME = 'HZ_PARTIES' AND COD.CLASS_CODE = LKUP.LOOKUP_CODE
AND COD.CLASS_CATEGORY = LKUP.LOOKUP_TYPE
AND COD.CLASS_CATEGORY = TYPE.LOOKUP_TYPE (+)