View: BIM_DIMV_PROD_LOV

Product:	BIM - Marketing Intelligence
Description:	Shows the relationship between interest types, primary interest codes and secondary interest codes.
Implementation/DBA Data:	APPS.BIM_DIMV_PROD_LOV

View Text

SELECT HIER.INTEREST_TYPE_ID
, INTYP.INTEREST_TYPE
, HIER.PRIMARY_INTEREST_CODE_ID
, PCODE.CODE
, HIER.SECONDARY_INTEREST_CODE_ID
, SCODE.CODE
FROM BIM_SALES_CATEGORY_HIER HIER
, AS_INTEREST_TYPES_TL INTYP
, AS_INTEREST_CODES_TL PCODE
, AS_INTEREST_CODES_TL SCODE
WHERE HIER.INTEREST_TYPE_ID = INTYP.INTEREST_TYPE_ID
AND INTYP.LANGUAGE = USERENV('LANG')
AND HIER.PRIMARY_INTEREST_CODE_ID = PCODE.INTEREST_CODE_ID (+)
AND PCODE.LANGUAGE (+) = USERENV('LANG')
AND HIER.SECONDARY_INTEREST_CODE_ID = SCODE.INTEREST_CODE_ID (+)
AND SCODE.LANGUAGE (+) = USERENV( 'LANG' ) UNION ALL SELECT -999
, MEANING
, -999
, MEANING
, -999
, MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BIM_VALUE_TYPE'
AND LOOKUP_CODE = '-999' WITH READ ONLY

Columns