Product: | INV - Inventory |
---|---|
Description: | 10SC ONLY |
Implementation/DBA Data: | APPS.MTL_ITEM_CATEGORIES_VIEW |
SELECT MIC.ROWID ROW_ID
, MIC.INVENTORY_ITEM_ID
, MIC.ORGANIZATION_ID
, MIC.CATEGORY_SET_ID
, MIC.CATEGORY_ID
, MIC.LAST_UPDATE_DATE
, MIC.LAST_UPDATED_BY
, MIC.CREATION_DATE
, MIC.CREATED_BY
, MIC.LAST_UPDATE_LOGIN
, MIC.REQUEST_ID
, MIC.PROGRAM_APPLICATION_ID
, MIC.PROGRAM_ID
, MIC.PROGRAM_UPDATE_DATE
, MSIK.PADDED_CONCATENATED_SEGMENTS INV_ITEM_PADDED_CONCAT_SEGS
, MSIK.CONCATENATED_SEGMENTS INV_ITEM_CONCAT_SEGS
, MSIT.DESCRIPTION INV_ITEM_DESCRIPTION
, MCB.SUMMARY_FLAG
, MCB.ENABLED_FLAG
FROM MTL_ITEM_CATEGORIES MIC
, MTL_CATEGORIES_B MCB
, MTL_SYSTEM_ITEMS_TL MSIT
, MTL_SYSTEM_ITEMS_B_KFV MSIK
WHERE MIC.CATEGORY_ID = MCB.CATEGORY_ID
AND MIC.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
AND MIC.ORGANIZATION_ID = MSIK.ORGANIZATION_ID
AND MIC.INVENTORY_ITEM_ID = MSIT.INVENTORY_ITEM_ID
AND MIC.ORGANIZATION_ID = MSIT.ORGANIZATION_ID
AND MSIT.LANGUAGE = USERENV('LANG')