VIEW: APPS.AS_INV_ITEM_LOV_V

Source

View Text - Preformatted

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(+))

View Text - HTML Formatted

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(+))