VIEW: APPS.PA_LEAD_CLASSIFICATIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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