[Home] [Help]
View: MTL_ITEM_ORG_CATEG_V
View Text
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
Columns
Name |
ROW_ID |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
ORG_CODE |
MASTER_ORGANIZATION_ID |
CHILD_ORG_FLAG |
CONTROL_LEVEL |
CATEGORY_SET_ID |
CATEGORY_SET |
STRUCTURE_ID |
CATEGORY_ID |