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_ER_WORKFLOW dependencies on FND_DOCUMENTS_VL

Line 479: fnd_documents_vl fdl

475:
476: DELETE fnd_lobs fl
477: WHERE fl.file_id IN (SELECT fdl.media_id
478: FROM fnd_attached_documents fad,
479: fnd_documents_vl fdl
480: WHERE fad.pk1_value = itemkey
481: AND fdl.document_id = fad.document_id
482: AND fad.entity_name = 'ERDETAILS');
483:

Line 487: fnd_documents_vl fdl

483:
484: DELETE fnd_lobs fl
485: WHERE fl.file_id IN (SELECT fdl.media_id
486: FROM fnd_attached_documents fad,
487: fnd_documents_vl fdl
488: WHERE fad.pk1_value IN (SELECT wf_item_key
489: FROM psp_eff_report_approvals pera
490: WHERE pera.effort_report_detail_id IN (SELECT perd.effort_report_detail_id
491: FROM psp_eff_report_details perd

Line 2179: where file_id in(select media_id from fnd_documents_vl

2175:
2176: --this code is to delete the pdf that has already been created with the DRAFT watermark
2177: --for PRE APPROVED report types
2178: delete from fnd_lobs
2179: where file_id in(select media_id from fnd_documents_vl
2180: where document_id in(select document_id from fnd_attached_documents
2181: where pk1_value = itemkey));
2182:
2183: