SELECT AICB.INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID , AICT.CODE SECONDARY_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 NOT 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) SECONDARY_INTEREST_CODE_ID , FL.MEANING SECONDARY_INTEREST_CODE , 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