DBA Data[Home] [Help]

VIEW: APPS.MTL_ITEM_CATEGORIES_V

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