View: BIL_DIMV_INTEREST_TYPES

Product:	BIL - Sales Intelligence
Description:	Interest types view
Implementation/DBA Data:	APPS.BIL_DIMV_INTEREST_TYPES

View Text

SELECT AITB.INTEREST_TYPE_ID
, AITT.INTEREST_TYPE
, AITT.DESCRIPTION
, AITB.ENABLED_FLAG
, TO_CHAR(AITB.INTEREST_TYPE_ID) ID
, SUBSTR(NVL(AITT.DESCRIPTION
, AITT.INTEREST_TYPE)
, 1
, 80) VALUE
FROM AS_INTEREST_TYPES_B AITB
, AS_INTEREST_TYPES_TL AITT
WHERE AITT.INTEREST_TYPE_ID = AITB.INTEREST_TYPE_ID
AND AITT.LANGUAGE = USERENV('LANG')
AND AITB.EXPECTED_PURCHASE_FLAG = 'Y' UNION ALL (SELECT TO_NUMBER(FL.LOOKUP_CODE) INTEREST_TYPE_PK
, FL.MEANING INTEREST_TYPE
, 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