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 1181: fnd_documents_vl fdl

1177: CURSOR get_file_id_cur IS
1178: SELECT fl.file_id
1179: FROM fnd_lobs fl,
1180: fnd_attached_documents fad,
1181: fnd_documents_vl fdl
1182: WHERE fad.pk1_value = TO_CHAR(p_wf_item_key)||p_wf_Role_Name
1183: --AND fad.pk3_value = p_wf_role_name
1184: AND fdl.document_id = fad.document_id
1185: AND fdl.media_id = fl.file_id

Line 1356: fnd_documents_vl fdl

1352: INTO l_document,
1353: l_pdf_file_id -- Bug 7135471
1354: FROM fnd_lobs fl,
1355: fnd_attached_documents fad,
1356: fnd_documents_vl fdl
1357: WHERE fad.pk1_value = l_item_key || l_rname
1358: AND fdl.document_id = fad.document_id
1359: AND fdl.media_id = fl.file_id
1360: AND fad.entity_name = 'ERDETAILS'

Line 1363: fnd_documents_vl fdl

1359: AND fdl.media_id = fl.file_id
1360: AND fad.entity_name = 'ERDETAILS'
1361: AND fl.file_id = (select max(file_id) FROM fnd_lobs fl, -- Bug 7135471
1362: fnd_attached_documents fad,
1363: fnd_documents_vl fdl
1364: WHERE fad.pk1_value = l_item_key || l_rname
1365: AND fdl.document_id = fad.document_id
1366: AND fdl.media_id = fl.file_id
1367: AND fad.entity_name = 'ERDETAILS');