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_ATTACHED_DOCS_FORM_VL

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

538: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
539: END IF;
540:
541:
542: SELECT count(*) into l_count from fnd_lobs fl,fnd_attached_docs_form_vl fad
543: WHERE
544: fl.file_id = fad.media_id and
545: fad.pk2_value=to_char(l_document_id) and
546: fad.pk3_value=to_char(l_revision_num) and

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

559: -- Added TO_CHAR() wherever a numeric value is compared with pk1_value or pk2_value.
560:
561: -- bug4931216
562: -- Add enttiy name filtering to utilize the index
563: SELECT count(*) into l_count from fnd_lobs fl,fnd_attached_docs_form_vl fad
564: WHERE
565: fl.file_id = fad.media_id and
566: fad.pk1_value=to_char(l_document_id) and
567: fad.pk2_value=to_char(l_revision_num) and

Line 4488: fnd_attached_docs_form_vl fad,

4484: --short_text attachment for the current document only.
4485: --bug6133951 added seq_num in order_by clause.
4486: l_head_short_attachment_query := 'CURSOR( SELECT fds.short_text
4487: FROM
4488: fnd_attached_docs_form_vl fad,
4489: fnd_documents_short_text fds
4490: WHERE ((entity_name=''PO_HEADERS'' AND
4491: pk1_value=to_char(phx.po_header_id))OR
4492: (entity_name = ''PO_RELEASES'' AND

Line 4505: FROM fnd_attached_docs_form_vl fad

4501: order by entity_name, seq_num) AS header_short_text'; --bug6133951
4502: --
4503: l_head_url_attachment_query := 'CURSOR(
4504: SELECT fad.url web_page --Bug#4958642
4505: FROM fnd_attached_docs_form_vl fad
4506: WHERE ((fad.entity_name=''PO_HEADERS'' AND fad.pk1_value=to_char(phx.po_header_id)) OR
4507: (fad.entity_name=''PO_RELEASES'' AND fad.pk1_value=to_char(phx.po_release_id)) OR
4508: (fad.entity_name=''PO_VENDORS'' AND fad.pk1_value=to_char(phx.vendor_id)) OR
4509: (fad.entity_name=''PO_VENDOR_SITES'' AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354

Line 4517: FROM fnd_attached_docs_form_vl fad

4513: order by fad.entity_name,fad.seq_num) AS header_url_attachments'; --bug6133951
4514:
4515: l_head_file_attachment_query := 'CURSOR(
4516: SELECT fad.file_name
4517: FROM fnd_attached_docs_form_vl fad
4518: WHERE ((fad.entity_name=''PO_HEADERS'' AND fad.pk1_value=to_char(phx.po_header_id)) OR
4519: (fad.entity_name=''PO_RELEASES'' AND fad.pk1_value=to_char(phx.po_release_id)) OR
4520: (fad.entity_name=''PO_VENDORS'' AND fad.pk1_value=to_char(phx.vendor_id)) OR
4521: (fad.entity_name=''PO_VENDOR_SITES'' AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354

Line 4535: fnd_attached_docs_form_vl fad,

4531: --short_text attachment for the current document only.
4532: --bug6133951 added seq_num in order_by clause.
4533: l_head_short_attachment_query := 'CURSOR( SELECT fds.short_text
4534: FROM
4535: fnd_attached_docs_form_vl fad,
4536: fnd_documents_short_text fds
4537: WHERE ((entity_name = ''PO_HEADERS'' AND
4538: pk1_value = to_char(phx.po_header_id)) OR
4539: (entity_name = ''PO_VENDORS'' AND

Line 4550: FROM fnd_attached_docs_form_vl fad

4546:
4547: --
4548: l_head_url_attachment_query := 'CURSOR(
4549: SELECT fad.url web_page --Bug#4958642
4550: FROM fnd_attached_docs_form_vl fad
4551: WHERE ((fad.entity_name=''PO_HEADERS'' AND fad.pk1_value=to_char(phx.po_header_id)) OR
4552: (fad.entity_name=''PO_VENDORS'' AND fad.pk1_value=to_char(phx.vendor_id)) OR
4553: (fad.entity_name=''PO_VENDOR_SITES'' AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354
4554: )

Line 4561: FROM fnd_attached_docs_form_vl fad

4557: order by fad.entity_name,fad.seq_num) AS header_url_attachments'; --bug6133951
4558:
4559: l_head_file_attachment_query := 'CURSOR(
4560: SELECT fad.file_name
4561: FROM fnd_attached_docs_form_vl fad
4562: WHERE ((fad.entity_name=''PO_HEADERS'' AND fad.pk1_value=to_char(phx.po_header_id)) OR
4563: (fad.entity_name=''PO_VENDORS'' AND fad.pk1_value=to_char(phx.vendor_id)) OR
4564: (fad.entity_name=''PO_VENDOR_SITES'' AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354
4565: )

Line 4587: fnd_attached_docs_form_vl fad,

4583: --short_text attachment for the current document only.
4584: --Bug 4673653 - Added condition to show item level short text attachments
4585: l_line_short_attachment_query := ' CURSOR( SELECT plx.po_line_id , fds.short_text
4586: FROM
4587: fnd_attached_docs_form_vl fad,
4588: fnd_documents_short_text fds
4589: WHERE ((fad.entity_name=''PO_LINES'' AND fad.pk1_value=to_char(plx.po_line_id))
4590: OR
4591: (fad.entity_name=''MTL_SYSTEM_ITEMS'' AND

Line 4603: FROM fnd_attached_docs_form_vl fad

4599: --
4600: --Bug 4673653 - Use inventory org id instead of Org Id to get the item attachments
4601: l_line_url_attachment_query := 'CURSOR(
4602: SELECT fad.url web_page --Bug#4958642
4603: FROM fnd_attached_docs_form_vl fad
4604: WHERE ((fad.entity_name=''PO_LINES'' AND fad.pk1_value=to_char(plx.po_line_id))
4605: OR
4606: (fad.entity_name=''PO_HEADERS'' AND fad.pk1_value=to_char(plx.from_header_id)
4607: AND plx.from_header_id IS NOT NULL)

Line 4622: FROM fnd_attached_docs_form_vl fad

4618:
4619: --Bug 4673653 - Use inventory org id instead of Org Id to get the item attachments
4620: l_line_file_attachment_query := 'CURSOR(
4621: SELECT fad.file_name
4622: FROM fnd_attached_docs_form_vl fad
4623: WHERE ((fad.entity_name=''PO_LINES'' AND fad.pk1_value=to_char(plx.po_line_id))
4624: OR
4625: (fad.entity_name=''PO_HEADERS'' AND fad.pk1_value=to_char(plx.from_header_id)
4626: AND plx.from_header_id IS NOT NULL)

Line 4651: fnd_attached_docs_form_vl fad,

4647: --Appended fad.datatype_id=1 condition for retrieving the
4648: --short_text attachment for the current document only
4649: l_shipment_short_attach_query := 'CURSOR( SELECT pllx.line_location_id, fds.short_text
4650: FROM
4651: fnd_attached_docs_form_vl fad,
4652: fnd_documents_short_text fds
4653: WHERE entity_name = ''PO_SHIPMENTS'' AND
4654: pk1_value = to_char(pllx.line_location_id) AND
4655: function_name = ''PO_PRINTPO''

Line 4663: FROM fnd_attached_docs_form_vl fad

4659:
4660: --
4661: l_shipment_url_attach_query := 'CURSOR(
4662: SELECT fad.url web_page --Bug#4958642
4663: FROM fnd_attached_docs_form_vl fad
4664: WHERE fad.entity_name=''PO_SHIPMENTS''
4665: AND fad.pk1_value=to_char(pllx.line_location_id)
4666: AND fad.datatype_id=5
4667: AND fad.function_name=''PO_PRINTPO''

Line 4672: FROM fnd_attached_docs_form_vl fad

4668: order by fad.seq_num ) AS line_loc_url_attachments'; --bug6133951
4669:
4670: l_shipment_file_attach_query := 'CURSOR(
4671: SELECT fad.file_name
4672: FROM fnd_attached_docs_form_vl fad
4673: WHERE fad.entity_name=''PO_SHIPMENTS''
4674: AND fad.pk1_value=to_char(pllx.line_location_id)
4675: AND fad.datatype_id=6
4676: AND fad.function_name=''PO_PRINTPO''

Line 5302: fnd_attached_docs_form_vl fad,

5298: Replacing fdl.long_text with get_clob(fdl.rowid) */
5299:
5300: l_headerAttachmentsQuery := 'select PO_COMMUNICATION_PVT.get_clob(fdl.rowid) long_text
5301: FROM
5302: fnd_attached_docs_form_vl fad,
5303: fnd_documents_long_text fdl
5304: WHERE ( (entity_name=''PO_RELEASES'' AND
5305: pk1_value= to_char(PO_COMMUNICATION_PVT.getDocumentId()) ) OR
5306: (entity_name = ''PO_HEADERS'' AND

Line 5326: fnd_attached_docs_form_vl fad,

5322: Replacing fdl.long_text with get_clob(fdl.rowid) */
5323:
5324: l_headerAttachmentsQuery := 'select PO_COMMUNICATION_PVT.get_clob(fdl.rowid) long_text
5325: FROM
5326: fnd_attached_docs_form_vl fad,
5327: fnd_documents_long_text fdl
5328: WHERE ((entity_name = ''PO_HEADERS'' AND
5329: pk1_value = to_char(PO_COMMUNICATION_PVT.getReleaseHeaderId())) OR --Bug6139548
5330: (entity_name = ''PO_VENDORS'' AND

Line 5351: fnd_attached_docs_form_vl fad,

5347: Replacing fdl.long_text with get_clob(fds.rowid) */
5348:
5349: l_lineAttachQuery :='SELECT PO_COMMUNICATION_PVT.get_clob(fds.rowid) text, plx.po_line_id id
5350: FROM
5351: fnd_attached_docs_form_vl fad,
5352: fnd_documents_long_text fds,
5353: po_lines_all plx
5354: WHERE ((fad.entity_name=''PO_LINES'' AND fad.pk1_value=to_char(plx.po_line_id))
5355: OR

Line 5380: fnd_attached_docs_form_vl fad,

5376: /* Bug 4568471/6829381 Exclude the One Time Address attachments when printing shipment long text.
5377: as this text is already printed as shipto Location */
5378: l_shipmentAttachmentQuery:= 'SELECT PO_COMMUNICATION_PVT.get_clob(fds.rowid) long_text, pllx.LINE_LOCATION_ID
5379: FROM
5380: fnd_attached_docs_form_vl fad,
5381: fnd_documents_long_text fds,
5382: po_line_locations_all pllx
5383: WHERE entity_name = ''PO_SHIPMENTS'' AND
5384: pk1_value = to_char(pllx.LINE_LOCATION_ID) AND

Line 7257: fnd_attached_docs_form_vl fad,

7253: SELECT fds.long_text
7254: INTO
7255: l_one_time_address_details
7256: FROM
7257: fnd_attached_docs_form_vl fad,
7258: fnd_documents_long_text fds
7259: WHERE entity_name = 'PO_SHIPMENTS' AND
7260: pk1_value = To_Char(p_line_location_id) AND
7261: function_name = 'PO_PRINTPO'