View: AS_INV_ITEM_LOV_V

Product:	AS - Sales Foundation
Description:	This view provides Inventory Item and associated Sales category IDs.
Implementation/DBA Data:	APPS.AS_INV_ITEM_LOV_V

View Text

SELECT MIC.INVENTORY_ITEM_ID
, MIC.CATEGORY_ID
, MIC.ORGANIZATION_ID
, IT.INTEREST_TYPE_ID
, IC.INTEREST_CODE_ID
, IC2.INTEREST_CODE_ID
, ITEMS.CONCATENATED_SEGMENTS ITEM_CONCAT_SEGS
, ITEMS.DESCRIPTION ITEM_DESCRIPTION
FROM MTL_ITEM_CATEGORIES MIC
, MTL_CATEGORIES_B MC
, FND_ID_FLEX_STRUCTURES FIFS
, MTL_SYSTEM_ITEMS_VL ITEMS
, AS_INTEREST_TYPES_B IT
, AS_INTEREST_CODES_B IC
, AS_INTEREST_CODES_B IC2
WHERE FIFS.ID_FLEX_CODE = 'MCAT'
AND FIFS.APPLICATION_ID = 401
AND FIFS.ID_FLEX_STRUCTURE_CODE = 'SALES_CATEGORIES'
AND MC.STRUCTURE_ID = FIFS.ID_FLEX_NUM
AND MIC.CATEGORY_SET_ID = 5
AND MIC.CATEGORY_ID = MC.CATEGORY_ID
AND MIC.INVENTORY_ITEM_ID = ITEMS.INVENTORY_ITEM_ID
AND MIC.ORGANIZATION_ID = ITEMS.ORGANIZATION_ID
AND MC.SEGMENT1 = TO_CHAR(IT.INTEREST_TYPE_ID)
AND MC.SEGMENT2 = TO_CHAR(IC.INTEREST_CODE_ID(+))
AND MC.SEGMENT3 = TO_CHAR(IC2.INTEREST_CODE_ID(+))

Columns