View: BIM_DIMV_INTEREST_TYPES

Product:	BIM - Marketing Intelligence(Obsolete)
Description:	not used.
Implementation/DBA Data:	APPS.BIM_DIMV_INTEREST_TYPES

View Text

SELECT B.INTEREST_TYPE_ID INTEREST_TYPE_ID
, T.INTEREST_TYPE INTEREST_TYPE
, T.DESCRIPTION DESCRIPTION
, MOT.ENABLED_FLAG ENABLED_FLAG
, MOT.ORG_ID ORG_ID
FROM AS_INTEREST_TYPES_B B
, AS_INTEREST_TYPES_TL T
, AS_INTEREST_TYPES_ALL MOT
WHERE B.INTEREST_TYPE_ID = T.INTEREST_TYPE_ID
AND B.INTEREST_TYPE_ID = MOT.INTEREST_TYPE_ID
AND T.LANGUAGE = USERENV('LANG')
AND NLS_UPPER(MOT.EXPECTED_PURCHASE_FLAG) = 'Y' WITH READ ONLY

Columns