View: MTL_ITEM_CATEGORIES_V

Product:	INV - Inventory
Description:	10SC ONLY
Implementation/DBA Data:	APPS.MTL_ITEM_CATEGORIES_V

View Text

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
, MCST.CATEGORY_SET_NAME
, MCS.STRUCTURE_ID
, MCS.VALIDATE_FLAG
, MCS.CONTROL_LEVEL
, ML.MEANING CONTROL_LEVEL_DISP
, MC.CONCATENATED_SEGMENTS CATEGORY_CONCAT_SEGS
, MCS.MULT_ITEM_CAT_ASSIGN_FLAG
, MC.STRUCTURE_ID CATEGORY_STRUCTURE_ID
, MC.DISABLE_DATE CATEGORY_DISABLE_DATE
, MC.SEGMENT1
, MC.SEGMENT2
, MC.SEGMENT3
, MC.SEGMENT4
, MC.SEGMENT5
, MC.SEGMENT6
, MC.SEGMENT7
, MC.SEGMENT8
, MC.SEGMENT9
, MC.SEGMENT10
, MC.SEGMENT11
, MC.SEGMENT12
, MC.SEGMENT13
, MC.SEGMENT14
, MC.SEGMENT15
, MC.SEGMENT16
, MC.SEGMENT17
, MC.SEGMENT18
, MC.SEGMENT19
, MC.SEGMENT20
, MC.SUMMARY_FLAG
, MC.ENABLED_FLAG
, MCS.HIERARCHY_ENABLED
FROM MTL_ITEM_CATEGORIES MIC
, MTL_CATEGORY_SETS_TL MCST
, MTL_CATEGORY_SETS_B MCS
, MFG_LOOKUPS ML
, MTL_CATEGORIES_B_KFV MC
WHERE MIC.CATEGORY_SET_ID = MCS.CATEGORY_SET_ID
AND MCS.CATEGORY_SET_ID = MCST.CATEGORY_SET_ID
AND MCST.LANGUAGE = USERENV('LANG')
AND MIC.CATEGORY_ID = MC.CATEGORY_ID
AND MCS.CONTROL_LEVEL = ML.LOOKUP_CODE
AND ML.LOOKUP_TYPE = 'ITEM_CONTROL_LEVEL_GUI'

Columns