VIEW: APPS.MTL_CATEGORIES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'