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 PO_VENDORS

Line 1372: where po_header_id = l_po_header_id)) and ad.entity_name = 'PO_VENDORS')

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')
1373: OR
1374: (ad.pk1_value in (select to_char(po_line_id) from po_lines_all
1375: where po_header_id = l_po_header_id
1376: ) and ad.entity_name = 'PO_LINES')

Line 1428: )) and ad.entity_name = 'PO_VENDORS')

1424: (ad.pk1_value = to_char((select pha.vendor_id
1425: from po_headers_all pha, po_releases_all pra
1426: where pra.po_release_id = l_po_release_id
1427: and pha.po_header_id = pra.po_header_id
1428: )) and ad.entity_name = 'PO_VENDORS')
1429: OR
1430: (ad.pk1_value in (select to_char(po_line_id) from po_line_locations_all
1431: where po_release_id = l_po_release_id
1432: and shipment_type = 'BLANKET'

Line 1642: ) and ad.entity_name = 'PO_VENDORS')

1638: (ad.pk1_value = (select pha.vendor_id
1639: from po_headers_all pha, po_releases_all pra
1640: where pra.po_release_id = l_document_id
1641: and pha.po_header_id = pra.po_header_id
1642: ) and ad.entity_name = 'PO_VENDORS')
1643: OR
1644: (ad.pk1_value in (select to_char(po_line_id) from po_line_locations_all
1645: where po_release_id = l_document_id
1646: and shipment_type = 'BLANKET'

Line 1698: where po_header_id = l_document_id)) and ad.entity_name = 'PO_VENDORS')

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')
1699: OR
1700: (ad.pk1_value in (select to_char(po_line_id) from po_lines_all
1701: where po_header_id = l_document_id
1702: ) and ad.entity_name = 'PO_LINES')

Line 4577: )) and ad.entity_name='PO_VENDORS'))

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
4576: and pha.po_header_id=pra.po_header_id
4577: )) and ad.entity_name='PO_VENDORS'))
4578: and d.document_id = ad.document_id
4579: and dcu.category_id = d.category_id
4580: and dcu.attachment_function_id = af.attachment_function_id
4581: and d.datatype_id=6

Line 4687: where po_header_id=p_document_id)) and ad.entity_name='PO_VENDORS'))

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:
4689: and d.document_id = ad.document_id
4690: and dcu.category_id = d.category_id
4691: and dcu.attachment_function_id = af.attachment_function_id

Line 4862: l_supp_org PO_VENDORS.VENDOR_NAME%type;

4858: l_disAttachments clob;
4859: l_time varchar2(50);
4860: l_vendor_id PO_HEADERS_ALL.vendor_id%type;
4861: l_release_header_id PO_HEADERS_ALL.po_header_id%type;
4862: l_supp_org PO_VENDORS.VENDOR_NAME%type;
4863: l_po_number PO_HEADERS.SEGMENT1%type;
4864: l_message varchar2(2001);
4865: l_ammendment_message varchar2(2001);
4866: l_change_summary PO_HEADERS.CHANGE_SUMMARY%type;

Line 4984: FROM hr_all_organization_units hle, po_vendors vn, po_headers_all ph

4980:
4981: /*Bug5983107 Commenting out the below sql and writing the new sql below without reference to hr_all_organization_units*/
4982: /* SELECT hle.name, vn.vendor_name, ph.segment1, ph.change_summary, ph.vendor_id, ph.currency_code
4983: INTO po_communication_pvt.g_buyer_org, l_supp_org, l_po_number, l_change_summary, l_vendor_id, g_current_currency_code
4984: FROM hr_all_organization_units hle, po_vendors vn, po_headers_all ph
4985: WHERE to_char(hle.organization_id) = (select org_information2 from hr_organization_information where
4986: org_information_context = 'Operating Unit Information' and organization_id = ph.org_id) AND vn.vendor_id = ph.vendor_id
4987: AND ph.po_header_id = p_document_id AND ph.revision_num = p_revision_num; */
4988:

Line 4991: FROM po_vendors vn, po_headers_all ph

4987: AND ph.po_header_id = p_document_id AND ph.revision_num = p_revision_num; */
4988:
4989: SELECT vn.vendor_name, ph.segment1, ph.change_summary, ph.vendor_id, ph.currency_code
4990: INTO l_supp_org, l_po_number, l_change_summary, l_vendor_id, g_current_currency_code
4991: FROM po_vendors vn, po_headers_all ph
4992: WHERE vn.vendor_id = ph.vendor_id
4993: AND ph.po_header_id = p_document_id AND ph.revision_num = p_revision_num;
4994:
4995:

Line 5008: FROM po_vendors vn, po_headers_archive_all ph

5004: /*Bug5983107 Modifying the below sql by removing reference to hr_all_organization_units*/
5005:
5006: SELECT vn.vendor_name, ph.segment1, ph.change_summary, ph.vendor_id, ph.currency_code
5007: INTO l_supp_org, l_po_number, l_change_summary, l_vendor_id, g_current_currency_code
5008: FROM po_vendors vn, po_headers_archive_all ph
5009: WHERE vn.vendor_id = ph.vendor_id
5010: AND ph.po_header_id = p_document_id AND ph.revision_num = p_revision_num;
5011:
5012: SELECT count(distinct(plla.SHIP_TO_LOCATION_ID)) INTO PO_COMMUNICATION_PVT.g_dist_shipto_count

Line 5056: FROM po_vendors vn, po_headers_all ph

5052: -- select the header id into g_release_header_id global variable for a given release id.
5053: SELECT po_header_id INTO PO_COMMUNICATION_PVT.g_release_header_id FROM po_releases_all WHERE po_release_id = p_document_id;
5054:
5055: SELECT ph.vendor_id, ph.currency_code INTO l_vendor_id, g_current_currency_code
5056: FROM po_vendors vn, po_headers_all ph
5057: WHERE vn.vendor_id = ph.vendor_id
5058: AND ph.po_header_id = PO_COMMUNICATION_PVT.g_release_header_id ;
5059:
5060: IF p_which_tables = 'MAIN' THEN

Line 5235: --attachments and then finally PO_VENDORS. This is necessary

5231: --bug#3768142 added the condtion if p_document_type='RELEASE'
5232: --so that the attachments for Releases are also displayed
5233: --correctly. An order by is used so that first the
5234: --PO_HEADERS(BPA) attachments are printed followed by PO_RELEASES
5235: --attachments and then finally PO_VENDORS. This is necessary
5236: --only for the Releases because you can display the BPA header
5237: --attachments also with a release.
5238:
5239: if(p_document_type = 'RELEASE')then

Line 5252: (entity_name = ''PO_VENDORS'' AND

5248: WHERE ((entity_name=''PO_HEADERS'' AND
5249: pk1_value=to_char(phx.po_header_id))OR
5250: (entity_name = ''PO_RELEASES'' AND
5251: pk1_value = to_char(phx.po_release_id)) OR
5252: (entity_name = ''PO_VENDORS'' AND
5253: pk1_value = to_char(phx.vendor_id)) OR
5254: (entity_name = ''PO_VENDOR_SITES'' AND
5255: pk1_value = to_char(phx.vendor_site_id))) AND -- bug6154354
5256: function_name = ''PO_PRINTPO''

Line 5266: (fad.entity_name=''PO_VENDORS'' AND fad.pk1_value=to_char(phx.vendor_id)) OR

5262: SELECT fad.url web_page --Bug#4958642
5263: FROM fnd_attached_docs_form_vl fad
5264: WHERE ((fad.entity_name=''PO_HEADERS'' AND fad.pk1_value=to_char(phx.po_header_id)) OR
5265: (fad.entity_name=''PO_RELEASES'' AND fad.pk1_value=to_char(phx.po_release_id)) OR
5266: (fad.entity_name=''PO_VENDORS'' AND fad.pk1_value=to_char(phx.vendor_id)) OR
5267: (fad.entity_name=''PO_VENDOR_SITES'' AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354
5268: )
5269: AND fad.datatype_id=5
5270: AND fad.function_name=''PO_PRINTPO''

Line 5278: (fad.entity_name=''PO_VENDORS'' AND fad.pk1_value=to_char(phx.vendor_id)) OR

5274: SELECT fad.file_name
5275: FROM fnd_attached_docs_form_vl fad
5276: WHERE ((fad.entity_name=''PO_HEADERS'' AND fad.pk1_value=to_char(phx.po_header_id)) OR
5277: (fad.entity_name=''PO_RELEASES'' AND fad.pk1_value=to_char(phx.po_release_id)) OR
5278: (fad.entity_name=''PO_VENDORS'' AND fad.pk1_value=to_char(phx.vendor_id)) OR
5279: (fad.entity_name=''PO_VENDOR_SITES'' AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354
5280: )
5281: AND fad.datatype_id=6
5282: AND fad.function_name=''PO_PRINTPO''

Line 5297: (entity_name = ''PO_VENDORS'' AND

5293: fnd_attached_docs_form_vl fad,
5294: fnd_documents_short_text fds
5295: WHERE ((entity_name = ''PO_HEADERS'' AND
5296: pk1_value = to_char(phx.po_header_id)) OR
5297: (entity_name = ''PO_VENDORS'' AND
5298: pk1_value = to_char(phx.vendor_id)) OR
5299: (entity_name = ''PO_VENDOR_SITES'' AND
5300: pk1_value = to_char(phx.vendor_site_id))) AND -- bug6154354
5301: function_name = ''PO_PRINTPO''

Line 5310: (fad.entity_name=''PO_VENDORS'' AND fad.pk1_value=to_char(phx.vendor_id)) OR

5306: l_head_url_attachment_query := 'CURSOR(
5307: SELECT fad.url web_page --Bug#4958642
5308: FROM fnd_attached_docs_form_vl fad
5309: WHERE ((fad.entity_name=''PO_HEADERS'' AND fad.pk1_value=to_char(phx.po_header_id)) OR
5310: (fad.entity_name=''PO_VENDORS'' AND fad.pk1_value=to_char(phx.vendor_id)) OR
5311: (fad.entity_name=''PO_VENDOR_SITES'' AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354
5312: )
5313: AND fad.datatype_id=5
5314: AND fad.function_name=''PO_PRINTPO''

Line 5321: (fad.entity_name=''PO_VENDORS'' AND fad.pk1_value=to_char(phx.vendor_id)) OR

5317: l_head_file_attachment_query := 'CURSOR(
5318: SELECT fad.file_name
5319: FROM fnd_attached_docs_form_vl fad
5320: WHERE ((fad.entity_name=''PO_HEADERS'' AND fad.pk1_value=to_char(phx.po_header_id)) OR
5321: (fad.entity_name=''PO_VENDORS'' AND fad.pk1_value=to_char(phx.vendor_id)) OR
5322: (fad.entity_name=''PO_VENDOR_SITES'' AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354
5323: )
5324: AND fad.datatype_id=6
5325: AND fad.function_name=''PO_PRINTPO''

Line 6172: --attachments and then finally PO_VENDORS. This is necessary

6168: --bug#3768142 also added the condition to check if the document
6169: --type is a release so that even the release header documents
6170: --are retrieved. An order by is used so that first the
6171: --PO_HEADERS(BPA) attachments are printed followed by PO_RELEASES
6172: --attachments and then finally PO_VENDORS. This is necessary
6173: --only for the Releases because you can display the BPA header
6174: --attachments also with a release.
6175: --bug#3823799: Replaced the hard coded p_document id with PO_COMMUNICATION_PVT.getDocumentId() function
6176: if(p_document_type = 'RELEASE')then

Line 6193: (entity_name = ''PO_VENDORS'' AND

6189: WHERE ( (entity_name=''PO_RELEASES'' AND
6190: pk1_value= to_char(PO_COMMUNICATION_PVT.getDocumentId()) ) OR
6191: (entity_name = ''PO_HEADERS'' AND
6192: pk1_value = to_char(PO_COMMUNICATION_PVT.getReleaseHeaderId())) OR --Bug6139548
6193: (entity_name = ''PO_VENDORS'' AND
6194: pk1_value = to_char(PO_COMMUNICATION_PVT.getVendorId()))) AND
6195: function_name = ''PO_PRINTPO''
6196: and fad.media_id = fdl.media_id
6197: and fad.datatype_id=2

Line 6215: (entity_name = ''PO_VENDORS'' AND

6211: fnd_attached_docs_form_vl fad,
6212: fnd_documents_long_text fdl
6213: WHERE ((entity_name = ''PO_HEADERS'' AND
6214: pk1_value = to_char(PO_COMMUNICATION_PVT.getReleaseHeaderId())) OR --Bug6139548
6215: (entity_name = ''PO_VENDORS'' AND
6216: pk1_value = to_char(PO_COMMUNICATION_PVT.getVendorId()))) AND
6217: function_name = ''PO_PRINTPO''
6218: and fad.media_id = fdl.media_id
6219: AND fad.datatype_id=2