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.PO_COMMUNICATION_PVT dependencies on FND_DOCUMENTS_VL

Line 2376: --Bug #4865352 - Replaced fnd_documents_tl with fnd_documents_vl

2372: --
2373: -- Brought the call out of the select
2374: l_pdf_file_name := po_communication_pvt.getPDFFileName(l_doctype,'_TERMS_',l_org_id,p_document_id,
2375: l_revision_num,l_buyer_language_code);
2376: --Bug #4865352 - Replaced fnd_documents_tl with fnd_documents_vl
2377: select count(1) into l_pdf_tc_buyer_exists from fnd_lobs fl,fnd_attached_documents fad, fnd_documents_vl fdl
2378: where
2379: fad.pk2_value = TO_CHAR(p_document_id) and
2380: fad.pk3_value = TO_CHAR(l_revision_num) and

Line 2377: select count(1) into l_pdf_tc_buyer_exists from fnd_lobs fl,fnd_attached_documents fad, fnd_documents_vl fdl

2373: -- Brought the call out of the select
2374: l_pdf_file_name := po_communication_pvt.getPDFFileName(l_doctype,'_TERMS_',l_org_id,p_document_id,
2375: l_revision_num,l_buyer_language_code);
2376: --Bug #4865352 - Replaced fnd_documents_tl with fnd_documents_vl
2377: select count(1) into l_pdf_tc_buyer_exists from fnd_lobs fl,fnd_attached_documents fad, fnd_documents_vl fdl
2378: where
2379: fad.pk2_value = TO_CHAR(p_document_id) and
2380: fad.pk3_value = TO_CHAR(l_revision_num) and
2381: fad.entity_name = 'OKC_CONTRACT_DOCS' and

Line 2437: select count(1) into l_pdf_nt_buyer_exists from fnd_lobs fl,fnd_attached_documents fad, fnd_documents_vl fdl

2433: -- Brought the call out of the select
2434: l_pdf_file_name := po_communication_pvt.getPDFFileName(l_doctype,'_TERMS_',l_org_id,p_document_id,
2435: l_revision_num,l_buyer_language_code);
2436: --Bug #4865352
2437: select count(1) into l_pdf_nt_buyer_exists from fnd_lobs fl,fnd_attached_documents fad, fnd_documents_vl fdl
2438: where
2439: fad.pk1_value = TO_CHAR(p_document_id) and
2440: fad.pk2_value = TO_CHAR(l_revision_num) and
2441: fad.entity_name = l_entity_name and

Line 2907: --Bug #4865352 - Replaced fnd_documents_tl with fnd_documents_vl

2903: -- For PDF preventing duplicate records is taken care of by explicitly deleting
2904: -- them before generating it everytime. For ZIP, it will be done by returning
2905: -- the same file id as the existing one so that an explicit delete would not be
2906: -- necessary
2907: --Bug #4865352 - Replaced fnd_documents_tl with fnd_documents_vl
2908: IF p_blob_type = 'ZIP' THEN
2909: Begin
2910: SELECT fdl.media_id
2911: INTO x_media_id

Line 2913: fnd_documents_vl fdl

2909: Begin
2910: SELECT fdl.media_id
2911: INTO x_media_id
2912: FROM fnd_attached_documents fad,
2913: fnd_documents_vl fdl
2914: WHERE fad.pk1_value=to_char(p_document_id)
2915: and fad.pk2_value=to_char(p_revision_number)
2916: and fad.entity_name = l_entity_name
2917: and fdl.document_id = fad.document_id;

Line 3418: --Bug #4865352 - Replaced fnd_documents_tl with fnd_documents_vl

3414:
3415: IF l_document_type in ('PO','PA') THEN
3416:
3417: IF l_withTerms='Y' THEN
3418: --Bug #4865352 - Replaced fnd_documents_tl with fnd_documents_vl
3419: -- Bug 4047688
3420: -- Appended join condition on file name of document to prevent return of multiple rows
3421: SELECT file_data into l_document
3422: FROM fnd_lobs fl,

Line 3424: fnd_documents_vl fdl

3420: -- Appended join condition on file name of document to prevent return of multiple rows
3421: SELECT file_data into l_document
3422: FROM fnd_lobs fl,
3423: fnd_attached_documents fad,
3424: fnd_documents_vl fdl
3425: WHERE fad.pk2_value=to_char(l_document_id) and fad.pk3_value=to_char(l_revision_number)
3426: and fdl.document_id = fad.document_id and fdl.media_id = fl.file_id and fad.entity_name = 'OKC_CONTRACT_DOCS'
3427: and fl.file_name = l_filename; --Bug 4047688
3428: