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.

APPS.PSP_XMLGEN dependencies on FND_DOCUMENTS_VL

Line 1187: fnd_documents_vl fdl

1183: CURSOR get_file_id_cur IS
1184: SELECT fl.file_id
1185: FROM fnd_lobs fl,
1186: fnd_attached_documents fad,
1187: fnd_documents_vl fdl
1188: WHERE fad.pk1_value = TO_CHAR(p_wf_item_key)||p_wf_Role_Name
1189: --AND fad.pk3_value = p_wf_role_name
1190: AND fdl.document_id = fad.document_id
1191: AND fdl.media_id = fl.file_id

Line 1364: fnd_documents_vl fdl

1360: INTO l_document,
1361: l_pdf_file_id -- Bug 7135471
1362: FROM fnd_lobs fl,
1363: fnd_attached_documents fad,
1364: fnd_documents_vl fdl
1365: WHERE fad.pk1_value = l_item_key || l_rname
1366: AND fdl.document_id = fad.document_id
1367: AND fdl.media_id = fl.file_id
1368: AND fad.entity_name = 'ERDETAILS'

Line 1371: fnd_documents_vl fdl

1367: AND fdl.media_id = fl.file_id
1368: AND fad.entity_name = 'ERDETAILS'
1369: AND fl.file_id = (select max(file_id) FROM fnd_lobs fl, -- Bug 7135471
1370: fnd_attached_documents fad,
1371: fnd_documents_vl fdl
1372: WHERE fad.pk1_value = l_item_key || l_rname
1373: AND fdl.document_id = fad.document_id
1374: AND fdl.media_id = fl.file_id
1375: AND fad.entity_name = 'ERDETAILS');