View: BIL_DIMV_PROD_LOV

Product:	BIL - Sales Intelligence
Description:	List of values view of product hierarcy
Implementation/DBA Data:	APPS.BIL_DIMV_PROD_LOV

View Text

SELECT AITT.INTEREST_TYPE
, BSCH.PRIMARY_INTEREST_CODE_ID
, AICT1.CODE
, BSCH.SECONDARY_INTEREST_CODE_ID
, AICT2.CODE
, BSCH.INTEREST_TYPE_ID
FROM BIM_SALES_CATEGORY_HIER BSCH
, AS_INTEREST_TYPES_TL AITT
, AS_INTEREST_CODES_TL AICT1
, AS_INTEREST_CODES_TL AICT2
WHERE BSCH.INTEREST_TYPE_ID = AITT.INTEREST_TYPE_ID
AND AITT.LANGUAGE = USERENV('LANG')
AND BSCH.PRIMARY_INTEREST_CODE_ID = AICT1.INTEREST_CODE_ID (+)
AND AICT1.LANGUAGE (+) = USERENV('LANG')
AND BSCH.SECONDARY_INTEREST_CODE_ID = AICT2.INTEREST_CODE_ID (+)
AND AICT2.LANGUAGE (+) = USERENV( 'LANG' ) UNION ALL (SELECT FL.MEANING INTEREST_TYPE
, TO_NUMBER(FL.LOOKUP_CODE) PRIMARY_INTEREST_CODE_ID
, FL.MEANING PRIMARY_INTEREST_CODE
, TO_NUMBER(FL.LOOKUP_CODE) SECONDARY_INTEREST_CODE_ID
, FL.MEANING SECONDARY_INTEREST_CODE
, TO_NUMBER(FL.LOOKUP_CODE) INTEREST_TYPE_ID
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'BIL_VALUE_TYPE'
AND FL.LOOKUP_CODE = '-999' ) WITH READ ONLY

Columns