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

Source

View Text - Preformatted


SELECT jdtc.tpl_ctg_id , jdtc.item_id , jaiv.item_name , jaiv.description item_description , jaiv.file_name , msiv.inventory_item_id , msiv.description inv_item_description FROM jtf_dsp_tpl_ctg jdtc ,jtf_dsp_amv_items_v jaiv ,mtl_categories_vl mcv ,mtl_system_items_vl msiv , mtl_item_categories mic WHERE mcv.category_id = jdtc.category_id AND mic.category_id = mcv.category_id AND msiv.inventory_item_id = mic.inventory_item_id AND jaiv.item_id = jdtc.item_id WITH READ ONLY

View Text - HTML Formatted

SELECT JDTC.TPL_CTG_ID
, JDTC.ITEM_ID
, JAIV.ITEM_NAME
, JAIV.DESCRIPTION ITEM_DESCRIPTION
, JAIV.FILE_NAME
, MSIV.INVENTORY_ITEM_ID
, MSIV.DESCRIPTION INV_ITEM_DESCRIPTION
FROM JTF_DSP_TPL_CTG JDTC
, JTF_DSP_AMV_ITEMS_V JAIV
, MTL_CATEGORIES_VL MCV
, MTL_SYSTEM_ITEMS_VL MSIV
, MTL_ITEM_CATEGORIES MIC
WHERE MCV.CATEGORY_ID = JDTC.CATEGORY_ID
AND MIC.CATEGORY_ID = MCV.CATEGORY_ID
AND MSIV.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID
AND JAIV.ITEM_ID = JDTC.ITEM_ID WITH READ ONLY