View: BIM_DIMV_PROD_HIER

Product:	BIM - Marketing Intelligence(Obsolete)
Description:	Shows the relationship between inventory items, interest types, primary interest codes and secondary interest codes.
Implementation/DBA Data:	APPS.BIM_DIMV_PROD_HIER

View Text

SELECT MIC.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MIC.ORGANIZATION_ID ORGANIZATION_ID
, TO_NUMBER( MC.SEGMENT1) INTEREST_TYPE_ID
, TO_NUMBER( MC.SEGMENT2) PRIMARY_INTEREST_CODE_ID
, TO_NUMBER( MC.SEGMENT3) SECONDARY_INTEREST_CODE_ID
FROM MTL_ITEM_CATEGORIES MIC
, MTL_CATEGORIES MC
WHERE MIC.CATEGORY_ID = MC.CATEGORY_ID
AND MIC.CATEGORY_SET_ID =5 WITH READ ONLY

Columns