VIEW: APPS.MTL_ITEM_CATEGORIES_VIEW

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')