View: BIL_DIMV_SLSPROD_HIER

Product:	BIL - Sales Intelligence
Description:	Product hiearchy view
Implementation/DBA Data:	APPS.BIL_DIMV_SLSPROD_HIER

View Text

SELECT AITL.INVENTORY_ITEM_ID
, AITL.INTEREST_TYPE_ID
, AITL.PRIMARY_INTEREST_CODE_ID
, AITL.SECONDARY_INTEREST_CODE_ID
, AITT.INTEREST_TYPE
, AICT1.CODE
, AICT2.CODE
FROM AS_INV_ITEM_LOV_V AITL
, AS_INTEREST_TYPES_TL AITT
, AS_INTEREST_CODES_TL AICT1
, AS_INTEREST_CODES_TL AICT2
WHERE AITL.INTEREST_TYPE_ID = AITT.INTEREST_TYPE_ID(+)
AND AITT.LANGUAGE(+) = USERENV('LANG')
AND AITL.PRIMARY_INTEREST_CODE_ID = AICT1.INTEREST_CODE_ID(+)
AND AICT1.LANGUAGE(+) = USERENV('LANG')
AND AITL.SECONDARY_INTEREST_CODE_ID = AICT2.INTEREST_CODE_ID(+)
AND AICT2.LANGUAGE(+) = USERENV('LANG')
AND AITL.ORGANIZATION_ID=OE_PROFILE.VALUE('OE_ORGANIZATION_ID'
, FND_PROFILE.VALUE('ORG_ID')) UNION ALL (SELECT TO_NUMBER(FL.LOOKUP_CODE) INVENTORY_INTEREST_ID
, TO_NUMBER(FL.LOOKUP_CODE) INTEREST_TYPE_ID
, TO_NUMBER(FL.LOOKUP_CODE) PRIMARY_INTEREST_CODE_ID
, TO_NUMBER(FL.LOOKUP_CODE) SECONDARY_INTEREST_CODE_ID
, FL.MEANING INTEREST_TYPE
, FL.MEANING PRIMARY_INTEREST_CODE
, FL.MEANING SECONDARY_INTEREST_CODE
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'BIL_VALUE_TYPE'
AND FL.LOOKUP_CODE = '-999' ) WITH READ ONLY

Columns