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.EDW_ITEM_VBH_CAT_LCV

Source

View Text - Preformatted


SELECT mtc.category_id , null , 'ALL', substrb(mtc.segment1,1,240) , substrb(mtc.segment1,1,320) , substrb(mtl.description,1,240) , mts.category_set_name , mts.category_set_id, mtc.category_id , mtc.creation_date , greatest(mtc.last_update_date, mtb.last_update_date), null, null, null, null, null, null from mtl_categories_b mtc, mtl_categories_tl mtl, mtl_category_sets_tl mts, mtl_category_sets_b mtb where mtc.structure_id = mtb.structure_id and mtb.category_set_id = mts.category_set_id and mts.language = userenv('LANG') and mtc.category_id = mtl.category_id and mtl.language = userenv('LANG') and mtb.control_level = 1 and mtb.category_set_id = 1000000006 WITH READ ONLY

View Text - HTML Formatted

SELECT MTC.CATEGORY_ID
, NULL
, 'ALL'
, SUBSTRB(MTC.SEGMENT1
, 1
, 240)
, SUBSTRB(MTC.SEGMENT1
, 1
, 320)
, SUBSTRB(MTL.DESCRIPTION
, 1
, 240)
, MTS.CATEGORY_SET_NAME
, MTS.CATEGORY_SET_ID
, MTC.CATEGORY_ID
, MTC.CREATION_DATE
, GREATEST(MTC.LAST_UPDATE_DATE
, MTB.LAST_UPDATE_DATE)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM MTL_CATEGORIES_B MTC
, MTL_CATEGORIES_TL MTL
, MTL_CATEGORY_SETS_TL MTS
, MTL_CATEGORY_SETS_B MTB
WHERE MTC.STRUCTURE_ID = MTB.STRUCTURE_ID
AND MTB.CATEGORY_SET_ID = MTS.CATEGORY_SET_ID
AND MTS.LANGUAGE = USERENV('LANG')
AND MTC.CATEGORY_ID = MTL.CATEGORY_ID
AND MTL.LANGUAGE = USERENV('LANG')
AND MTB.CONTROL_LEVEL = 1
AND MTB.CATEGORY_SET_ID = 1000000006 WITH READ ONLY