eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MTH_SRC_ITEM_CATEGORIES_V

Source

View Text - Preformatted


SELECT CAST(NULL AS VARCHAR2(120)) CATEGORY_PK, fnd_profile.value('MTH_EBS_GLOBAL_NAME') SYSTEM_FK, mcb.concatenated_segments CATEGORY_NAME, mct.description DESCRIPTION, mcs.category_id EBS_CATEGORY_ID, mcb.attribute1 USER_ATTR1, mcb.attribute2 USER_ATTR2, mcb.attribute3 USER_ATTR3, mcb.attribute4 USER_ATTR4, mcb.attribute5 USER_ATTR5, CAST(NULL AS NUMBER) USER_MEASURE1, CAST(NULL AS NUMBER) USER_MEASURE2, CAST(NULL AS NUMBER) USER_MEASURE3, CAST(NULL AS NUMBER) USER_MEASURE4, CAST(NULL AS NUMBER) USER_MEASURE5, mcb.segment1 SEGMENT1 , mcb.segment2 SEGMENT2 , mcb.segment3 SEGMENT3 , mcb.segment4 SEGMENT4 , mcb.segment5 SEGMENT5 , mcb.segment6 SEGMENT6 , mcb.segment7 SEGMENT7 , mcb.segment8 SEGMENT8 , mcb.segment9 SEGMENT9 , mcb.segment10 SEGMENT10, mcb.segment11 SEGMENT11, mcb.segment12 SEGMENT12, mcb.segment13 SEGMENT13, mcb.segment14 SEGMENT14, mcb.segment15 SEGMENT15, mcb.segment16 SEGMENT16, mcb.segment17 SEGMENT17, mcb.segment18 SEGMENT18, mcb.segment19 SEGMENT19, mcb.segment20 SEGMENT20, mcv.category_set_name CATEGORY_SET_NAME, Greatest(mct.last_update_date,mcs.last_update_date) LAST_UPDATE_DATE FROM mtl_categories_tl mct, mtl_categories_b_kfv mcb, mtl_category_set_valid_cats mcs, mtl_category_sets_vl mcv WHERE mcs.category_id = mcb.category_id AND mcb.category_id = mct.category_id AND mcs.category_set_id = mcv.category_set_id AND mct.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT CAST(NULL AS VARCHAR2(120)) CATEGORY_PK
, FND_PROFILE.VALUE('MTH_EBS_GLOBAL_NAME') SYSTEM_FK
, MCB.CONCATENATED_SEGMENTS CATEGORY_NAME
, MCT.DESCRIPTION DESCRIPTION
, MCS.CATEGORY_ID EBS_CATEGORY_ID
, MCB.ATTRIBUTE1 USER_ATTR1
, MCB.ATTRIBUTE2 USER_ATTR2
, MCB.ATTRIBUTE3 USER_ATTR3
, MCB.ATTRIBUTE4 USER_ATTR4
, MCB.ATTRIBUTE5 USER_ATTR5
, CAST(NULL AS NUMBER) USER_MEASURE1
, CAST(NULL AS NUMBER) USER_MEASURE2
, CAST(NULL AS NUMBER) USER_MEASURE3
, CAST(NULL AS NUMBER) USER_MEASURE4
, CAST(NULL AS NUMBER) USER_MEASURE5
, MCB.SEGMENT1 SEGMENT1
, MCB.SEGMENT2 SEGMENT2
, MCB.SEGMENT3 SEGMENT3
, MCB.SEGMENT4 SEGMENT4
, MCB.SEGMENT5 SEGMENT5
, MCB.SEGMENT6 SEGMENT6
, MCB.SEGMENT7 SEGMENT7
, MCB.SEGMENT8 SEGMENT8
, MCB.SEGMENT9 SEGMENT9
, MCB.SEGMENT10 SEGMENT10
, MCB.SEGMENT11 SEGMENT11
, MCB.SEGMENT12 SEGMENT12
, MCB.SEGMENT13 SEGMENT13
, MCB.SEGMENT14 SEGMENT14
, MCB.SEGMENT15 SEGMENT15
, MCB.SEGMENT16 SEGMENT16
, MCB.SEGMENT17 SEGMENT17
, MCB.SEGMENT18 SEGMENT18
, MCB.SEGMENT19 SEGMENT19
, MCB.SEGMENT20 SEGMENT20
, MCV.CATEGORY_SET_NAME CATEGORY_SET_NAME
, GREATEST(MCT.LAST_UPDATE_DATE
, MCS.LAST_UPDATE_DATE) LAST_UPDATE_DATE
FROM MTL_CATEGORIES_TL MCT
, MTL_CATEGORIES_B_KFV MCB
, MTL_CATEGORY_SET_VALID_CATS MCS
, MTL_CATEGORY_SETS_VL MCV
WHERE MCS.CATEGORY_ID = MCB.CATEGORY_ID
AND MCB.CATEGORY_ID = MCT.CATEGORY_ID
AND MCS.CATEGORY_SET_ID = MCV.CATEGORY_SET_ID
AND MCT.LANGUAGE = USERENV('LANG')