VIEW: APPS.BIL_DIMV_INTEREST_CODES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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