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_LOBS

Line 573: l_filename fnd_lobs.file_name%type;

569: l_terms_flag po_headers_all.CONTERMS_EXIST_FLAG%type;
570: l_document_subtype po_headers_all.type_lookup_code%TYPE;
571: l_document_type po_headers_all.type_lookup_code%TYPE;
572: l_count number;
573: l_filename fnd_lobs.file_name%type;
574: l_orgid number;
575: x_progress varchar2(100);
576: l_with_terms PO_HEADERS_ALL.CONTERMS_EXIST_FLAG%TYPE;
577: l_terms varchar2(10);

Line 644: SELECT count(*) into l_count from fnd_lobs fl, fnd_attached_docs_form_vl fad

640: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
641: END IF;
642:
643:
644: SELECT count(*) into l_count from fnd_lobs fl, fnd_attached_docs_form_vl fad
645: WHERE
646: fl.file_id = fad.media_id and
647: fad.pk2_value = to_char(l_document_id) and
648: fad.pk3_value = to_char(l_revision_num) and

Line 665: SELECT count(*) into l_count from fnd_lobs fl, fnd_attached_docs_form_vl fad

661: -- Added TO_CHAR() wherever a numeric value is compared with pk1_value or pk2_value.
662:
663: -- bug4931216
664: -- Add enttiy name filtering to utilize the index
665: SELECT count(*) into l_count from fnd_lobs fl, fnd_attached_docs_form_vl fad
666: WHERE
667: fl.file_id = fad.media_id and
668: fad.pk1_value = to_char(l_document_id) and
669: fad.pk2_value = to_char(l_revision_num) and

Line 743: l_filename fnd_lobs.file_name%type;

739: l_okc_doc_type varchar2(50);
740:
741: -- bug 16475213 start
742: l_zip_exists NUMBER;
743: l_filename fnd_lobs.file_name%type;
744: l_entity_name varchar2(30);
745: -- bug 16475213 end
746:
747: BEGIN

Line 1019: FROM fnd_lobs fl,

1015:
1016: Begin
1017: SELECT count(*)
1018: INTO l_zip_exists
1019: FROM fnd_lobs fl,
1020: fnd_attached_documents fad,
1021: fnd_documents fd,
1022: fnd_documents_tl fdl
1023: WHERE fad.pk1_value = to_char(p_document_id)

Line 1346: l_filename fnd_lobs.file_name%type;

1342: -- file attachments with same filename
1343: l_error_flag number; -- determines if the error condition (same file name
1344: -- but different file lengths has been met or not)
1345: l_max_attachment_size po_system_parameters_all.max_attachment_size%type;
1346: l_filename fnd_lobs.file_name%type;
1347: l_filename_new fnd_lobs.file_name%type;
1348: l_length number;
1349: l_length_new number;
1350: l_set_lang boolean; /*Bug 8135201*/

Line 1347: l_filename_new fnd_lobs.file_name%type;

1343: l_error_flag number; -- determines if the error condition (same file name
1344: -- but different file lengths has been met or not)
1345: l_max_attachment_size po_system_parameters_all.max_attachment_size%type;
1346: l_filename fnd_lobs.file_name%type;
1347: l_filename_new fnd_lobs.file_name%type;
1348: l_length number;
1349: l_length_new number;
1350: l_set_lang boolean; /*Bug 8135201*/
1351: l_draft_id number; -- CLM

Line 1368: fnd_lobs fl

1364: from fnd_documents d,
1365: fnd_attached_documents ad,
1366: fnd_doc_category_usages dcu,
1367: fnd_attachment_functions af,
1368: fnd_lobs fl
1369: where ((ad.pk1_value = to_char(l_po_header_id) and ad.entity_name = 'PO_HEADERS')
1370: OR
1371: (ad.pk1_value = to_char((select vendor_id from po_headers_all
1372: where po_header_id = l_po_header_id)) and ad.entity_name = 'PO_VENDORS')

Line 1417: fnd_lobs fl

1413: from fnd_documents d,
1414: fnd_attached_documents ad,
1415: fnd_doc_category_usages dcu,
1416: fnd_attachment_functions af,
1417: fnd_lobs fl
1418: where ((ad.pk1_value = to_char((select po_header_id from po_releases_all
1419: where po_release_id = l_po_release_id
1420: )) and ad.entity_name = 'PO_HEADERS')
1421: OR

Line 1631: fnd_lobs fl

1627: from fnd_documents d,
1628: fnd_attached_documents ad,
1629: fnd_doc_category_usages dcu,
1630: fnd_attachment_functions af,
1631: fnd_lobs fl
1632: where ((ad.pk1_value = to_char((select po_header_id from po_releases_all
1633: where po_release_id = l_document_id
1634: )) and ad.entity_name = 'PO_HEADERS')
1635: OR

Line 1694: fnd_lobs fl

1690: from fnd_documents d,
1691: fnd_attached_documents ad,
1692: fnd_doc_category_usages dcu,
1693: fnd_attachment_functions af,
1694: fnd_lobs fl
1695: where ((ad.pk1_value = to_char(l_document_id) and ad.entity_name = 'PO_HEADERS')
1696: OR
1697: (ad.pk1_value = to_char((select vendor_id from po_headers_all
1698: where po_header_id = l_document_id)) and ad.entity_name = 'PO_VENDORS')

Line 2665: l_pdf_file_name fnd_lobs.file_name%type; --

2661:
2662: l_progress VARCHAR2(3);
2663: l_entity_name fnd_attached_documents.entity_name%type;
2664: l_buyer_language_code fnd_documents_tl.language%type;
2665: l_pdf_file_name fnd_lobs.file_name%type; --
2666:
2667: BEGIN
2668: l_progress := '000';
2669: IF g_debug_stmt THEN

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

2761: -- Brought the call out of the select
2762: l_pdf_file_name := po_communication_pvt.getPDFFileName(l_doctype, '_TERMS_', l_org_id, p_document_id,
2763: l_revision_num, l_buyer_language_code);
2764: --Bug #4865352 - Replaced fnd_documents_tl with fnd_documents_vl
2765: select count(1) into l_pdf_tc_buyer_exists from fnd_lobs fl, fnd_attached_documents fad, fnd_documents_vl fdl
2766: where
2767: fad.pk2_value = TO_CHAR(p_document_id) and
2768: fad.pk3_value = TO_CHAR(l_revision_num) and
2769: fad.entity_name = 'OKC_CONTRACT_DOCS' and

Line 2792: select count(1) into l_pdf_tc_sup_exists from fnd_lobs fl, fnd_attached_documents fad, fnd_documents fd, fnd_documents_tl fdl

2788:
2789: l_pdf_file_name := po_communication_pvt.getPDFFileName(l_doctype, '_TERMS_', l_org_id, p_document_id,
2790: l_revision_num, l_buyer_language_code); --bug#3463617
2791: --Bug #4865352 - Added a join with fnd_documents
2792: select count(1) into l_pdf_tc_sup_exists from fnd_lobs fl, fnd_attached_documents fad, fnd_documents fd, fnd_documents_tl fdl
2793: where
2794: fad.pk1_value = TO_CHAR(p_document_id) and
2795: fad.pk2_value = TO_CHAR(l_revision_num) and
2796: fad.entity_name = l_entity_name and

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

2821: -- Brought the call out of the select
2822: l_pdf_file_name := po_communication_pvt.getPDFFileName(l_doctype, '_TERMS_', l_org_id, p_document_id,
2823: l_revision_num, l_buyer_language_code);
2824: --Bug #4865352
2825: select count(1) into l_pdf_nt_buyer_exists from fnd_lobs fl, fnd_attached_documents fad, fnd_documents_vl fdl
2826: where
2827: fad.pk1_value = TO_CHAR(p_document_id) and
2828: fad.pk2_value = TO_CHAR(l_revision_num) and
2829: fad.entity_name = l_entity_name and

Line 2852: select count(1) into l_pdf_nt_sup_exists from fnd_lobs fl, fnd_attached_documents fad, fnd_documents fd, fnd_documents_tl fdl

2848: -- Brought the call out of the select
2849: l_pdf_file_name := po_communication_pvt.getPDFFileName(l_doctype, '_TERMS_', l_org_id, p_document_id,
2850: l_revision_num, l_language_code);
2851: --Bug #4865352 - Added a join with fnd_documents
2852: select count(1) into l_pdf_nt_sup_exists from fnd_lobs fl, fnd_attached_documents fad, fnd_documents fd, fnd_documents_tl fdl
2853: where
2854: fad.pk1_value = TO_CHAR(p_document_id) and
2855: fad.pk2_value = TO_CHAR(l_revision_num) and
2856: fad.entity_name = l_entity_name and

Line 3265: l_file_name fnd_lobs.file_name%type;

3261: l_count number;
3262: l_draft_id varchar2(30) := null; --CLM Project
3263:
3264: --
3265: l_file_name fnd_lobs.file_name%type;
3266: l_file_content_type fnd_lobs.file_content_type%type;
3267: l_org_id po_headers_all.org_id%type;
3268: l_api_name CONSTANT VARCHAR2(25) := 'Store_Blob';
3269: l_progress VARCHAR2(3);

Line 3266: l_file_content_type fnd_lobs.file_content_type%type;

3262: l_draft_id varchar2(30) := null; --CLM Project
3263:
3264: --
3265: l_file_name fnd_lobs.file_name%type;
3266: l_file_content_type fnd_lobs.file_content_type%type;
3267: l_org_id po_headers_all.org_id%type;
3268: l_api_name CONSTANT VARCHAR2(25) := 'Store_Blob';
3269: l_progress VARCHAR2(3);
3270:

Line 3345: -- locator will be inserted into fnd_lobs. If too_many_rows (though should

3341: and fdl.document_id = fad.document_id;
3342:
3343: Exception when others Then
3344: -- do nothing. If no_data_found then x_media_id will be null and a new lob
3345: -- locator will be inserted into fnd_lobs. If too_many_rows (though should
3346: -- not occur because the locator gets overwritten everytime) then the first blob found will be overwritten
3347: null;
3348: End;
3349: END IF;

Line 3394: INSERT INTO fnd_lobs (

3390: x_media_id);
3391:
3392: l_progress := '060';
3393:
3394: INSERT INTO fnd_lobs (
3395: file_id,
3396: File_name,
3397: file_content_type,
3398: upload_date,

Line 3515: l_filename fnd_lobs.file_name%type;

3511: procedure pdf_attach_app (document_id in varchar2,
3512: content_type in varchar2,
3513: document in out NOCOPY blob,
3514: document_type in out NOCOPY varchar2) IS
3515: l_filename fnd_lobs.file_name%type;
3516: l_document_id number;
3517: l_document_type po_headers.type_lookup_code%TYPE;
3518: l_org_id number;
3519: l_revision_number number;

Line 3601: FROM fnd_lobs fl,

3597:
3598: --Bug #4865352 - Added join with fnd_documents and selected media_id from it
3599: --Bug #5232999 - Added file name as criterion so that we get only the PDF
3600: /* SELECT file_data into l_document
3601: FROM fnd_lobs fl,
3602: fnd_attached_documents fad,
3603: fnd_documents fd,
3604: fnd_documents_tl fdl
3605: WHERE fad.pk1_value = to_char(l_document_id) and fad.pk2_value = to_char(l_revision_number)

Line 3614: FROM fnd_lobs fl,

3610: /* FP Bug 13870183 : Logic while fetching pdf is now changed to, fetch pdf from PO_HEAD/PO_REL,
3611: If document does not exists on PO_HEAD and PO_REL, fetch it from OKC_CONTRACT_DOCS*/
3612: BEGIN
3613: SELECT file_data into l_document
3614: FROM fnd_lobs fl,
3615: fnd_attached_documents fad,
3616: fnd_documents fd,
3617: fnd_documents_tl fdl
3618: WHERE fad.pk1_value = to_char(l_document_id)

Line 3638: FROM fnd_lobs fl,

3634: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey, 'Fetching from OKC_CONTRACT_DOC entity.....');
3635: END IF;
3636:
3637: SELECT file_data into l_document
3638: FROM fnd_lobs fl,
3639: fnd_attached_documents fad,
3640: fnd_documents fd,
3641: fnd_documents_tl fdl
3642: WHERE fad.pk2_value = to_char(l_document_id)

Line 3684: l_filename fnd_lobs.file_name%type;

3680: PROCEDURE pdf_attach_supp(document_id in varchar2,
3681: content_type in varchar2,
3682: document in out nocopy blob,
3683: document_type in out nocopy varchar2) IS
3684: l_filename fnd_lobs.file_name%type;
3685: l_document_id number;
3686: l_document_type po_headers.type_lookup_code%TYPE;
3687: l_org_id number;
3688: l_revision_number number;

Line 3744: FROM fnd_lobs fl,

3740: -- Bug 4047688
3741: -- Added join condition on file name of PDF
3742: IF l_withTerms = 'Y' AND l_document_type in ('PO', 'PA') THEN
3743: SELECT file_data into l_document
3744: FROM fnd_lobs fl,
3745: fnd_attached_documents fad,
3746: fnd_documents fd,
3747: fnd_documents_tl fdl
3748: WHERE fad.pk2_value = to_char(l_document_id) and fad.pk3_value = to_char(l_revision_number)

Line 3763: FROM fnd_lobs fl,

3759: END IF;
3760: --Bug #4865352 - Added a join with fnd_documents
3761: IF l_document_type in ('PO', 'PA', 'RELEASE') AND l_withTerms = 'N' THEN
3762: SELECT file_data into l_document
3763: FROM fnd_lobs fl,
3764: fnd_attached_documents fad,
3765: fnd_documents fd,
3766: fnd_documents_tl fdl
3767: WHERE fad.pk1_value = to_char(l_document_id) and fad.pk2_value = to_char(l_revision_number)

Line 3799: l_filename fnd_lobs.file_name%type;

3795: procedure pdf_attach(document_id in varchar2,
3796: content_type in varchar2,
3797: document in out nocopy blob,
3798: document_type in out nocopy varchar2) IS
3799: l_filename fnd_lobs.file_name%type;
3800: l_document_id number;
3801: l_document_type po_headers.type_lookup_code%TYPE;
3802: l_org_id number;
3803: l_revision_number number;

Line 3915: FROM fnd_lobs fl,

3911: --Bug #4865352 - Replaced fnd_documents_tl with fnd_documents_vl
3912: -- Bug 4047688
3913: -- Appended join condition on file name of document to prevent return of multiple rows
3914: SELECT file_data into l_document
3915: FROM fnd_lobs fl,
3916: fnd_attached_documents fad,
3917: fnd_documents_vl fdl
3918: --Begin Edit Akyanama Bug # 13242469
3919: --Changed the below line

Line 3936: FROM fnd_lobs fl,

3932:
3933: if l_document_type in ('PO', 'PA', 'RELEASE') and l_withTerms = 'N' then
3934: --Bug #4865352 - Added a join with fnd_documents
3935: SELECT file_data into l_document
3936: FROM fnd_lobs fl,
3937: fnd_attached_documents fad,
3938: fnd_documents fd,
3939: fnd_documents_tl fdl
3940: WHERE fad.pk1_value = to_char(l_document_id) and fad.pk2_value = to_char(l_revision_number)

Line 3950: FROM fnd_lobs fl,

3946: IF l_document_type in ('PO', 'PA', 'RELEASE') THEN
3947:
3948: BEGIN
3949: SELECT file_data into l_document
3950: FROM fnd_lobs fl,
3951: fnd_attached_documents fad,
3952: fnd_documents fd,
3953: fnd_documents_tl fdl
3954: WHERE fad.pk1_value = to_char(l_document_id)

Line 3974: FROM fnd_lobs fl,

3970: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey, 'Fetching from OKC_CONTRACT_DOC entity.....');
3971: END IF;
3972:
3973: SELECT file_data into l_document
3974: FROM fnd_lobs fl,
3975: fnd_attached_documents fad,
3976: fnd_documents fd,
3977: fnd_documents_tl fdl
3978: WHERE fad.pk2_value = to_char(l_document_id)

Line 4042: l_okc_file_id fnd_lobs.file_id%TYPE;

4038: document in out nocopy blob,
4039: document_type in out nocopy varchar2)
4040: IS
4041:
4042: l_okc_file_id fnd_lobs.file_id%TYPE;
4043: l_okc_file_name fnd_lobs.file_name%TYPE;
4044: l_okc_file_data fnd_lobs.file_data%TYPE;
4045: l_okc_file_content_type fnd_lobs.file_content_type%TYPE;
4046:

Line 4043: l_okc_file_name fnd_lobs.file_name%TYPE;

4039: document_type in out nocopy varchar2)
4040: IS
4041:
4042: l_okc_file_id fnd_lobs.file_id%TYPE;
4043: l_okc_file_name fnd_lobs.file_name%TYPE;
4044: l_okc_file_data fnd_lobs.file_data%TYPE;
4045: l_okc_file_content_type fnd_lobs.file_content_type%TYPE;
4046:
4047: l_po_document_id number;

Line 4044: l_okc_file_data fnd_lobs.file_data%TYPE;

4040: IS
4041:
4042: l_okc_file_id fnd_lobs.file_id%TYPE;
4043: l_okc_file_name fnd_lobs.file_name%TYPE;
4044: l_okc_file_data fnd_lobs.file_data%TYPE;
4045: l_okc_file_content_type fnd_lobs.file_content_type%TYPE;
4046:
4047: l_po_document_id number;
4048: l_po_document_type po_headers.type_lookup_code%TYPE;

Line 4045: l_okc_file_content_type fnd_lobs.file_content_type%TYPE;

4041:
4042: l_okc_file_id fnd_lobs.file_id%TYPE;
4043: l_okc_file_name fnd_lobs.file_name%TYPE;
4044: l_okc_file_data fnd_lobs.file_data%TYPE;
4045: l_okc_file_content_type fnd_lobs.file_content_type%TYPE;
4046:
4047: l_po_document_id number;
4048: l_po_document_type po_headers.type_lookup_code%TYPE;
4049: l_po_document_subtype po_headers.type_lookup_code%TYPE;

Line 4154: -- Bug 4173198: Select file_data from fnd_lobs into local variable

4150:
4151: IF (l_okc_file_id > 0)
4152: THEN
4153:
4154: -- Bug 4173198: Select file_data from fnd_lobs into local variable
4155: -- l_okc_file_data first and then use dbms_lob.copy
4156:
4157: SELECT fl.file_name, fl.file_content_type, fl.file_data
4158: INTO l_okc_file_name, l_okc_file_content_type, l_okc_file_data

Line 4159: FROM fnd_lobs fl

4155: -- l_okc_file_data first and then use dbms_lob.copy
4156:
4157: SELECT fl.file_name, fl.file_content_type, fl.file_data
4158: INTO l_okc_file_name, l_okc_file_content_type, l_okc_file_data
4159: FROM fnd_lobs fl
4160: WHERE fl.file_id = l_okc_file_id;
4161:
4162: document_type := l_okc_file_content_type || '; name=' || l_okc_file_name;
4163:

Line 4234: l_filename fnd_lobs.file_name%type;

4230: PROCEDURE zip_attach(document_id in varchar2,
4231: content_type in varchar2,
4232: document in out nocopy blob,
4233: document_type in out nocopy varchar2) IS
4234: l_filename fnd_lobs.file_name%type;
4235: l_document_id po_headers_all.po_header_id%type;
4236: l_document_number po_headers_all.segment1%type;
4237: l_document_type po_headers_all.type_lookup_code%TYPE;
4238: l_org_id po_headers_all.org_id%type;

Line 4244: l_document fnd_lobs.file_data%type;

4240: l_language fnd_languages.language_code%type;
4241: l_entity_name fnd_attached_documents.entity_name%type;
4242: l_itemtype wf_items.item_type%type;
4243: l_itemkey wf_items.item_key%type;
4244: l_document fnd_lobs.file_data%type;
4245: l_document_length number;
4246: l_progress varchar2(300);
4247: l_filecontent_type fnd_lobs.file_content_type%type;
4248: l_message FND_NEW_MESSAGES.message_text%TYPE;

Line 4247: l_filecontent_type fnd_lobs.file_content_type%type;

4243: l_itemkey wf_items.item_key%type;
4244: l_document fnd_lobs.file_data%type;
4245: l_document_length number;
4246: l_progress varchar2(300);
4247: l_filecontent_type fnd_lobs.file_content_type%type;
4248: l_message FND_NEW_MESSAGES.message_text%TYPE;
4249:
4250:
4251: BEGIN

Line 4303: FROM fnd_lobs fl,

4299: --Bug #4865352 - Added a join with fnd_documents and selected media_id from it
4300: Begin
4301: SELECT fl.file_data, fl.file_content_type
4302: INTO l_document, l_filecontent_type
4303: FROM fnd_lobs fl,
4304: fnd_attached_documents fad,
4305: fnd_documents fd,
4306: fnd_documents_tl fdl
4307: WHERE fad.pk1_value = to_char(l_document_id)

Line 4533: fnd_lobs fl

4529: from fnd_documents d,
4530: fnd_attached_documents ad,
4531: fnd_doc_category_usages dcu,
4532: fnd_attachment_functions af,
4533: fnd_lobs fl
4534: where (ad.pk1_value=to_char((select po_header_id from po_releases_all
4535: where po_release_id=p_document_id
4536: ))and ad.entity_name='PO_HEADERS')
4537:

Line 4553: fnd_lobs fl

4549: from fnd_documents d,
4550: fnd_attached_documents ad,
4551: fnd_doc_category_usages dcu,
4552: fnd_attachment_functions af,
4553: fnd_lobs fl
4554: where (
4555: (ad.pk1_value=to_char(p_document_id) and ad.entity_name='PO_RELEASES'))
4556: and d.document_id = ad.document_id
4557: and dcu.category_id = d.category_id

Line 4571: fnd_lobs fl

4567: from fnd_documents d,
4568: fnd_attached_documents ad,
4569: fnd_doc_category_usages dcu,
4570: fnd_attachment_functions af,
4571: fnd_lobs fl
4572: where (
4573: (ad.pk1_value=to_char((select pha.vendor_id
4574: from po_headers_all pha,po_releases_all pra
4575: where pra.po_release_id=p_document_id

Line 4593: fnd_lobs fl

4589: from fnd_documents d,
4590: fnd_attached_documents ad,
4591: fnd_doc_category_usages dcu,
4592: fnd_attachment_functions af,
4593: fnd_lobs fl
4594: where (
4595: (ad.pk1_value in (select po_line_id from po_line_locations_all
4596: where po_release_id=p_document_id
4597: and shipment_type='BLANKET'

Line 4614: fnd_lobs fl

4610: from fnd_documents d,
4611: fnd_attached_documents ad,
4612: fnd_doc_category_usages dcu,
4613: fnd_attachment_functions af,
4614: fnd_lobs fl
4615: where (
4616: (ad.pk1_value in (select line_location_id from po_line_locations_all
4617: where po_release_id=p_document_id
4618: and shipment_type='BLANKET'

Line 4635: fnd_lobs fl

4631: from fnd_documents d,
4632: fnd_attached_documents ad,
4633: fnd_doc_category_usages dcu,
4634: fnd_attachment_functions af,
4635: fnd_lobs fl
4636: where ( /*bug 13528070*/
4637: (ad.pk2_value in (select /*+ push_subq no_unnest */ pl.item_id
4638: from po_lines_all pl, po_line_locations_all pll
4639: where pll.po_release_id=p_document_id

Line 4667: fnd_lobs fl

4663: from fnd_documents d,
4664: fnd_attached_documents ad,
4665: fnd_doc_category_usages dcu,
4666: fnd_attachment_functions af,
4667: fnd_lobs fl
4668: where (ad.pk1_value=to_char(p_document_id) and ad.entity_name='PO_HEADERS')
4669: and d.document_id = ad.document_id
4670: and dcu.category_id = d.category_id
4671: and dcu.attachment_function_id = af.attachment_function_id

Line 4684: fnd_lobs fl

4680: from fnd_documents d,
4681: fnd_attached_documents ad,
4682: fnd_doc_category_usages dcu,
4683: fnd_attachment_functions af,
4684: fnd_lobs fl
4685: where (
4686: (ad.pk1_value=to_char((select vendor_id from po_headers_all
4687: where po_header_id=p_document_id)) and ad.entity_name='PO_VENDORS'))
4688:

Line 4704: fnd_lobs fl

4700: from fnd_documents d,
4701: fnd_attached_documents ad,
4702: fnd_doc_category_usages dcu,
4703: fnd_attachment_functions af,
4704: fnd_lobs fl
4705: where ( /*bug 13528070 Changing to to_char*/
4706: (ad.pk1_value in (select to_char(po_line_id) from po_lines_all
4707: where po_header_id=p_document_id
4708: ) and ad.entity_name='PO_LINES'))

Line 4725: fnd_lobs fl

4721: from fnd_documents d,
4722: fnd_attached_documents ad,
4723: fnd_doc_category_usages dcu,
4724: fnd_attachment_functions af,
4725: fnd_lobs fl
4726: where (
4727: (ad.pk1_value in (select from_header_id from po_lines_all
4728: where po_header_id=p_document_id
4729: and from_header_id is not null

Line 4747: fnd_lobs fl

4743: from fnd_documents d,
4744: fnd_attached_documents ad,
4745: fnd_doc_category_usages dcu,
4746: fnd_attachment_functions af,
4747: fnd_lobs fl
4748: where (
4749: (ad.pk1_value in (select from_line_id from po_lines_all
4750: where po_header_id=p_document_id
4751: and from_line_id is not null

Line 4769: fnd_lobs fl

4765: from fnd_documents d,
4766: fnd_attached_documents ad,
4767: fnd_doc_category_usages dcu,
4768: fnd_attachment_functions af,
4769: fnd_lobs fl
4770: where (
4771: (ad.pk1_value in (select line_location_id from po_line_locations_all
4772: where po_header_id=p_document_id
4773: and shipment_type in ('PRICE BREAK','STANDARD','PREPAYMENT') --

Line 4791: fnd_lobs fl

4787: from fnd_documents d,
4788: fnd_attached_documents ad,
4789: fnd_doc_category_usages dcu,
4790: fnd_attachment_functions af,
4791: fnd_lobs fl
4792: where ( /*bug 13528070*/
4793: (ad.pk2_value in (select /*+ push_subq no_unnest */ item_id from po_lines_all
4794: where po_header_id=p_document_id
4795: and item_id is not null

Line 7541: l_file_name fnd_lobs.file_name%type;

7537:
7538: l_po_number po_drafts.modification_number%type;
7539: l_language_code fnd_languages.language_code%type;
7540: l_api_name CONSTANT VARCHAR2(25) := 'PDFFileName';
7541: l_file_name fnd_lobs.file_name%type;
7542: l_revision_num po_drafts.revision_num%type;
7543: l_progress VARCHAR2(3);
7544: /* Begin Add By Akyanama Bug # 13342437*/
7545: l_release_num po_releases_all.release_num%type;