View: BIL_DIMV_INTEREST_CODES

Product:	BIL - Sales Intelligence
Description:	Interest codes view
Implementation/DBA Data:	APPS.BIL_DIMV_INTEREST_CODES

View Text

SELECT AICB.INTEREST_CODE_ID
, AICB.INTEREST_TYPE_ID
, AICB.PARENT_INTEREST_CODE_ID
, AICT.CODE
, AICT.DESCRIPTION
, AICB.ENABLED_FLAG
, 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 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) INTEREST_CODE_PK
, TO_NUMBER(FL.LOOKUP_CODE) INTEREST_TYPE_FK
, TO_NUMBER(FL.LOOKUP_CODE) PARENT_INTEREST_CODE_FK
, SUBSTR(FL.MEANING
, 1
, 60) INTEREST_CODE
, FL.DESCRIPTION DESCRIPTION
, FL.ENABLED_FLAG ENABLED_FLAG
, FL.LOOKUP_CODE ID
, FL.MEANING VALUE
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'BIL_VALUE_TYPE'
AND FL.LOOKUP_CODE = '-999' ) WITH READ ONLY

Columns