View: MTL_CATEGORIES_V

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

View Text

SELECT MC.ROW_ID ROW_ID
, MC.CATEGORY_ID
, MC.STRUCTURE_ID
, MC.DISABLE_DATE
, MC.WEB_STATUS
, MC.SUPPLIER_ENABLED_FLAG
, 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
, MC.START_DATE_ACTIVE
, MC.END_DATE_ACTIVE
, MC.ATTRIBUTE_CATEGORY
, MC.ATTRIBUTE1
, MC.ATTRIBUTE2
, MC.ATTRIBUTE3
, MC.ATTRIBUTE4
, MC.ATTRIBUTE5
, MC.ATTRIBUTE6
, MC.ATTRIBUTE7
, MC.ATTRIBUTE8
, MC.ATTRIBUTE9
, MC.ATTRIBUTE10
, MC.ATTRIBUTE11
, MC.ATTRIBUTE12
, MC.ATTRIBUTE13
, MC.ATTRIBUTE14
, MC.ATTRIBUTE15
, MC.LAST_UPDATE_DATE
, MC.LAST_UPDATED_BY
, MC.CREATION_DATE
, MC.CREATED_BY
, MC.LAST_UPDATE_LOGIN
, MC.REQUEST_ID
, MC.PROGRAM_APPLICATION_ID
, MC.PROGRAM_ID
, MC.PROGRAM_UPDATE_DATE
, MCT.DESCRIPTION
, MC.CONCATENATED_SEGMENTS CATEGORY_CONCAT_SEGS
, FIFS.ID_FLEX_STRUCTURE_NAME STRUCTURE_NAME
FROM MTL_CATEGORIES_TL MCT
, MTL_CATEGORIES_B_KFV MC
, FND_ID_FLEX_STRUCTURES_VL FIFS
WHERE MC.CATEGORY_ID = MCT.CATEGORY_ID
AND MCT.LANGUAGE = USERENV('LANG')
AND MC.STRUCTURE_ID = FIFS.ID_FLEX_NUM
AND FIFS.APPLICATION_ID = 401
AND FIFS.ID_FLEX_CODE = 'MCAT'

Columns