View: BIL_DIMV_PRIM_INT_CODES

Product:	BIL - Sales Intelligence
Description:	Primary interest codes view
Implementation/DBA Data:	APPS.BIL_DIMV_PRIM_INT_CODES

View Text

SELECT AICB.INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID
, AICT.CODE PRIMARY_INTEREST_CODE
, TO_CHAR(AICB.INTEREST_CODE_ID) ID
, SUBSTR(NVL(AICT.DESCRIPTION
, AICT.CODE)
, 1
, 80) VALUE
FROM AS_INTEREST_CODES_B AICB
, AS_INTEREST_CODES_TL AICT
, AS_INTEREST_TYPES_B AITB
WHERE AICB.PARENT_INTEREST_CODE_ID IS NULL
AND AICT.INTEREST_CODE_ID = AICB.INTEREST_CODE_ID
AND AICT.LANGUAGE = USERENV('LANG')
AND AITB.INTEREST_TYPE_ID = AICB.INTEREST_TYPE_ID
AND AITB.EXPECTED_PURCHASE_FLAG = 'Y' UNION ALL (SELECT TO_NUMBER(FL.LOOKUP_CODE) PRIMARY_INTEREST_CODE_ID
, FL.MEANING PRIMARY_INTEREST_CODE
, SUBSTR(FL.LOOKUP_CODE
, 1
, 80) ID
, FL.MEANING VALUE
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'BIL_VALUE_TYPE'
AND FL.LOOKUP_CODE = '-999' ) WITH READ ONLY

Columns