View: BIM_DIMV_INTEREST_CODES

Product:	BIM - Marketing Intelligence
Description:	not used.
Implementation/DBA Data:	APPS.BIM_DIMV_INTEREST_CODES

View Text

SELECT B.INTEREST_CODE_ID INTEREST_CODE_ID
, T.CODE INTEREST_CODE
, T.DESCRIPTION DESCRIPTION
, MOC.ENABLED_FLAG ENABLED_FLAG
, MOC.ORG_ID ORG_ID
, B.INTEREST_TYPE_ID INTEREST_TYPE_ID
, B.PARENT_INTEREST_CODE_ID PARENT_INTEREST_CODE_ID
FROM AS_INTEREST_CODES_B B
, AS_INTEREST_CODES_TL T
, AS_INTEREST_CODES_ALL MOC
, AS_INTEREST_TYPES_ALL MOT
WHERE B.INTEREST_CODE_ID = T.INTEREST_CODE_ID
AND B.INTEREST_CODE_ID = MOC.INTEREST_CODE_ID
AND B.INTEREST_TYPE_ID = MOT.INTEREST_TYPE_ID
AND MOC.ORG_ID = MOT.ORG_ID
AND T.LANGUAGE = USERENV( 'LANG')
AND NLS_UPPER(MOT.EXPECTED_PURCHASE_FLAG) = 'Y' WITH READ ONLY

Columns