eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MTL_ITEM_ORG_CATEG_V

Source

View Text - Preformatted


SELECT MIC.ROWID ROW_ID , MIC.INVENTORY_ITEM_ID , MIC.ORGANIZATION_ID , MP.ORGANIZATION_CODE , MP.MASTER_ORGANIZATION_ID , DECODE(MIC.ORGANIZATION_ID, MP.MASTER_ORGANIZATION_ID, 0, 1) , MFG.MEANING CONTROL_LEVEL , MIC.CATEGORY_SET_ID , MCST.CATEGORY_SET_NAME CATEGORY_SET , MCS.STRUCTURE_ID , MIC.CATEGORY_ID FROM MTL_ITEM_CATEGORIES MIC , MTL_CATEGORY_SETS_TL MCST , MTL_CATEGORY_SETS_B MCS , MTL_PARAMETERS MP , MFG_LOOKUPS MFG WHERE MIC.CATEGORY_SET_ID = MCS.CATEGORY_SET_ID AND MCS.CATEGORY_SET_ID = MCST.CATEGORY_SET_ID AND MCST.LANGUAGE = userenv('LANG') AND MP.ORGANIZATION_ID = MIC.ORGANIZATION_ID AND MFG.LOOKUP_TYPE(+) = 'ITEM_CONTROL_LEVEL_GUI' AND MFG.LOOKUP_CODE(+) = MCS.CONTROL_LEVEL

View Text - HTML Formatted

SELECT MIC.ROWID ROW_ID
, MIC.INVENTORY_ITEM_ID
, MIC.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, MP.MASTER_ORGANIZATION_ID
, DECODE(MIC.ORGANIZATION_ID
, MP.MASTER_ORGANIZATION_ID
, 0
, 1)
, MFG.MEANING CONTROL_LEVEL
, MIC.CATEGORY_SET_ID
, MCST.CATEGORY_SET_NAME CATEGORY_SET
, MCS.STRUCTURE_ID
, MIC.CATEGORY_ID
FROM MTL_ITEM_CATEGORIES MIC
, MTL_CATEGORY_SETS_TL MCST
, MTL_CATEGORY_SETS_B MCS
, MTL_PARAMETERS MP
, MFG_LOOKUPS MFG
WHERE MIC.CATEGORY_SET_ID = MCS.CATEGORY_SET_ID
AND MCS.CATEGORY_SET_ID = MCST.CATEGORY_SET_ID
AND MCST.LANGUAGE = USERENV('LANG')
AND MP.ORGANIZATION_ID = MIC.ORGANIZATION_ID
AND MFG.LOOKUP_TYPE(+) = 'ITEM_CONTROL_LEVEL_GUI'
AND MFG.LOOKUP_CODE(+) = MCS.CONTROL_LEVEL