View: PA_LEAD_CLASSIFICATIONS_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_LEAD_CLASSIFICATIONS_V

View Text

SELECT TO_CHAR(INTEREST_TYPE_ID)
, INTEREST_TYPE
, DESCRIPTION
FROM AS_INTEREST_TYPES_V
WHERE MASTER_ENABLED_FLAG = 'Y'
AND LEAD_CLASSIFICATION_FLAG = 'Y' UNION SELECT TO_CHAR(I.INTEREST_TYPE_ID)||'/'||P.INTEREST_CODE_ID
, I.INTEREST_TYPE||'/'||P.CODE
, P.DESCRIPTION
FROM AS_INTEREST_TYPES_V I
, AS_INTEREST_CODES_V P
WHERE I.INTEREST_TYPE_ID*1 = P.INTEREST_TYPE_ID
AND P.PARENT_INTEREST_CODE_ID IS NULL
AND I.MASTER_ENABLED_FLAG = 'Y'
AND I.LEAD_CLASSIFICATION_FLAG = 'Y'
AND P.MASTER_ENABLED_FLAG = 'Y' UNION SELECT TO_CHAR(I.INTEREST_TYPE_ID)||'/'||P.INTEREST_CODE_ID||'/'||S.INTEREST_CODE_ID
, I.INTEREST_TYPE||'/'||P.CODE||'/'||S.CODE
, S.DESCRIPTION
FROM AS_INTEREST_TYPES_V I
, AS_INTEREST_CODES_V P
, AS_INTEREST_CODES_V S
WHERE I.INTEREST_TYPE_ID = P.INTEREST_TYPE_ID
AND P.INTEREST_TYPE_ID = S.INTEREST_TYPE_ID*1
AND S.PARENT_INTEREST_CODE_ID = P.INTEREST_CODE_ID
AND I.LEAD_CLASSIFICATION_FLAG = 'Y'
AND I.MASTER_ENABLED_FLAG = 'Y'
AND P.MASTER_ENABLED_FLAG = 'Y'
AND S.MASTER_ENABLED_FLAG = 'Y' ORDER BY 2

Columns