VIEW: APPS.AMS_CONTACT_PRODUCTS_V

Source

View Text - Preformatted

SELECT /*+ first_rows use_nl(bi ti bp tp) */ bi.interest_type_id id, to_char(bi.interest_type_id) interest_type_id ,-1 interest_code_id ,ti.interest_type,'','as_interest_types_b' from as_interest_types_b bi, as_interest_types_tl ti where bi.enabled_flag = 'Y' and bi.expected_purchase_flag = 'Y' and ti.interest_type_id = bi.interest_type_id and ti.language=userenv('lang') union select /*+ first_rows use_nl(bi ti bp tp) */ bp.interest_code_id id, to_char(bi.interest_type_id), bp.interest_code_id, ti.interest_type, tp.code, 'as_interest_codes_b' from as_interest_types_b bi, as_interest_types_tl ti, as_interest_codes_b bp, as_interest_codes_tl tp where bi.interest_type_id = bp.interest_type_id and bp.parent_interest_code_id is null and bi.enabled_flag = 'Y' and bi.expected_purchase_flag = 'Y' and bp.enabled_flag = 'Y' and ti.interest_type_id = bi.interest_type_id and tp.interest_code_id = bp.interest_code_id and tp.language=userenv('lang') and ti.language=userenv('lang')

View Text - HTML Formatted

SELECT /*+ FIRST_ROWS USE_NL(BI TI BP TP) */ BI.INTEREST_TYPE_ID ID
, TO_CHAR(BI.INTEREST_TYPE_ID) INTEREST_TYPE_ID
, -1 INTEREST_CODE_ID
, TI.INTEREST_TYPE
, ''
, 'AS_INTEREST_TYPES_B'
FROM AS_INTEREST_TYPES_B BI
, AS_INTEREST_TYPES_TL TI
WHERE BI.ENABLED_FLAG = 'Y'
AND BI.EXPECTED_PURCHASE_FLAG = 'Y'
AND TI.INTEREST_TYPE_ID = BI.INTEREST_TYPE_ID
AND TI.LANGUAGE=USERENV('LANG') UNION SELECT /*+ FIRST_ROWS USE_NL(BI TI BP TP) */ BP.INTEREST_CODE_ID ID
, TO_CHAR(BI.INTEREST_TYPE_ID)
, BP.INTEREST_CODE_ID
, TI.INTEREST_TYPE
, TP.CODE
, 'AS_INTEREST_CODES_B'
FROM AS_INTEREST_TYPES_B BI
, AS_INTEREST_TYPES_TL TI
, AS_INTEREST_CODES_B BP
, AS_INTEREST_CODES_TL TP
WHERE BI.INTEREST_TYPE_ID = BP.INTEREST_TYPE_ID
AND BP.PARENT_INTEREST_CODE_ID IS NULL
AND BI.ENABLED_FLAG = 'Y'
AND BI.EXPECTED_PURCHASE_FLAG = 'Y'
AND BP.ENABLED_FLAG = 'Y'
AND TI.INTEREST_TYPE_ID = BI.INTEREST_TYPE_ID
AND TP.INTEREST_CODE_ID = BP.INTEREST_CODE_ID
AND TP.LANGUAGE=USERENV('LANG')
AND TI.LANGUAGE=USERENV('LANG')