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_LOBS

Line 476: DELETE fnd_lobs fl

472:
473: delete psp_report_errors
474: where request_id = l_request_id;
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

Line 484: DELETE fnd_lobs fl

480: WHERE fad.pk1_value = itemkey
481: AND fdl.document_id = fad.document_id
482: AND fad.entity_name = 'ERDETAILS');
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

Line 2178: delete from fnd_lobs

2174: IF l_approval_type = 'PRE' THEN
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: