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_ATTACHMENTS_V

Source

View Text - Preformatted


SELECT v1.file_name , v2.description , a.language_code , v2.item_id ,v2.access_name , a.msite_id , a.default_site, a.default_language ,v1.file_id FROM jtf_amv_attachments v1, jtf_amv_items_vl v2, jtf_dsp_lgl_phys_map a WHERE a.attachment_id = v1.attachment_id and a.item_id = v2.item_id and v1.application_id = 671 and v2.application_id = 671

View Text - HTML Formatted

SELECT V1.FILE_NAME
, V2.DESCRIPTION
, A.LANGUAGE_CODE
, V2.ITEM_ID
, V2.ACCESS_NAME
, A.MSITE_ID
, A.DEFAULT_SITE
, A.DEFAULT_LANGUAGE
, V1.FILE_ID
FROM JTF_AMV_ATTACHMENTS V1
, JTF_AMV_ITEMS_VL V2
, JTF_DSP_LGL_PHYS_MAP A
WHERE A.ATTACHMENT_ID = V1.ATTACHMENT_ID
AND A.ITEM_ID = V2.ITEM_ID
AND V1.APPLICATION_ID = 671
AND V2.APPLICATION_ID = 671