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 1152: where po_header_id=l_po_header_id)) and ad.entity_name='PO_VENDORS')

1148: fnd_lobs fl
1149: where ((ad.pk1_value=to_char(l_po_header_id) and ad.entity_name='PO_HEADERS')
1150: OR
1151: (ad.pk1_value=to_char((select vendor_id from po_headers_all
1152: where po_header_id=l_po_header_id)) and ad.entity_name='PO_VENDORS')
1153: OR
1154: (ad.pk1_value in (select po_line_id from po_lines_all
1155: where po_header_id=l_po_header_id
1156: ) and ad.entity_name='PO_LINES')

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

1204: (ad.pk1_value=to_char((select pha.vendor_id
1205: from po_headers_all pha,po_releases_all pra
1206: where pra.po_release_id=l_po_release_id
1207: and pha.po_header_id=pra.po_header_id
1208: )) and ad.entity_name='PO_VENDORS')
1209: OR
1210: (ad.pk1_value in (select po_line_id from po_line_locations_all
1211: where po_release_id=l_po_release_id
1212: and shipment_type='BLANKET'

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

1392: (ad.pk1_value=(select pha.vendor_id
1393: from po_headers_all pha,po_releases_all pra
1394: where pra.po_release_id=l_document_id
1395: and pha.po_header_id=pra.po_header_id
1396: ) and ad.entity_name='PO_VENDORS')
1397: OR
1398: (ad.pk1_value in (select po_line_id from po_line_locations_all
1399: where po_release_id=l_document_id
1400: and shipment_type='BLANKET'

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

1448: fnd_lobs fl
1449: where ((ad.pk1_value=to_char(l_document_id) and ad.entity_name='PO_HEADERS')
1450: OR
1451: (ad.pk1_value=to_char((select vendor_id from po_headers_all
1452: where po_header_id=l_document_id)) and ad.entity_name='PO_VENDORS')
1453: OR
1454: (ad.pk1_value in (select po_line_id from po_lines_all
1455: where po_header_id=l_document_id
1456: ) and ad.entity_name='PO_LINES')

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

3985: (ad.pk1_value=to_char((select pha.vendor_id
3986: from po_headers_all pha,po_releases_all pra
3987: where pra.po_release_id=p_document_id
3988: and pha.po_header_id=pra.po_header_id
3989: )) and ad.entity_name='PO_VENDORS')
3990: OR
3991: (ad.pk1_value in (select po_line_id from po_line_locations_all
3992: where po_release_id=p_document_id
3993: and shipment_type='BLANKET'

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

4031: fnd_lobs fl
4032: where ((ad.pk1_value=to_char(p_document_id) and ad.entity_name='PO_HEADERS')
4033: OR
4034: (ad.pk1_value=to_char((select vendor_id from po_headers_all
4035: where po_header_id=p_document_id)) and ad.entity_name='PO_VENDORS')
4036: OR
4037: (ad.pk1_value in (select po_line_id from po_lines_all
4038: where po_header_id=p_document_id
4039: ) and ad.entity_name='PO_LINES')

Line 4118: l_supp_org PO_VENDORS.VENDOR_NAME%type;

4114: l_disAttachments clob;
4115: l_time varchar2(50);
4116: l_vendor_id PO_HEADERS_ALL.vendor_id%type;
4117: l_release_header_id PO_HEADERS_ALL.po_header_id%type;
4118: l_supp_org PO_VENDORS.VENDOR_NAME%type;
4119: l_po_number PO_HEADERS.SEGMENT1%type;
4120: l_message varchar2(2001);
4121: l_ammendment_message varchar2(2001);
4122: l_change_summary PO_HEADERS.CHANGE_SUMMARY%type;

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

4222:
4223: /*Bug5983107 Commenting out the below sql and writing the new sql below without reference to hr_all_organization_units*/
4224: /* SELECT hle.name, vn.vendor_name, ph.segment1, ph.change_summary, ph.vendor_id, ph.currency_code
4225: INTO po_communication_pvt.g_buyer_org, l_supp_org, l_po_number, l_change_summary, l_vendor_id, g_current_currency_code
4226: FROM hr_all_organization_units hle, po_vendors vn, po_headers_all ph
4227: WHERE to_char(hle.organization_id) = (select org_information2 from hr_organization_information where
4228: org_information_context = 'Operating Unit Information' and organization_id = ph.org_id) AND vn.vendor_id = ph.vendor_id
4229: AND ph.po_header_id = p_document_id AND ph.revision_num = p_revision_num; */
4230:

Line 4233: FROM po_vendors vn, po_headers_all ph

4229: AND ph.po_header_id = p_document_id AND ph.revision_num = p_revision_num; */
4230:
4231: SELECT vn.vendor_name, ph.segment1, ph.change_summary, ph.vendor_id, ph.currency_code
4232: INTO l_supp_org, l_po_number, l_change_summary, l_vendor_id, g_current_currency_code
4233: FROM po_vendors vn, po_headers_all ph
4234: WHERE vn.vendor_id = ph.vendor_id
4235: AND ph.po_header_id = p_document_id AND ph.revision_num = p_revision_num;
4236:
4237:

Line 4250: FROM po_vendors vn, po_headers_archive_all ph

4246: /*Bug5983107 Modifying the below sql by removing reference to hr_all_organization_units*/
4247:
4248: SELECT vn.vendor_name, ph.segment1, ph.change_summary, ph.vendor_id, ph.currency_code
4249: INTO l_supp_org, l_po_number, l_change_summary, l_vendor_id, g_current_currency_code
4250: FROM po_vendors vn, po_headers_archive_all ph
4251: WHERE vn.vendor_id = ph.vendor_id
4252: AND ph.po_header_id = p_document_id AND ph.revision_num = p_revision_num;
4253:
4254: SELECT count(distinct(plla.SHIP_TO_LOCATION_ID)) INTO PO_COMMUNICATION_PVT.g_dist_shipto_count

Line 4298: FROM po_vendors vn, po_headers_all ph

4294: -- select the header id into g_release_header_id global variable for a given release id.
4295: SELECT po_header_id INTO PO_COMMUNICATION_PVT.g_release_header_id FROM po_releases_all WHERE po_release_id = p_document_id;
4296:
4297: SELECT ph.vendor_id, ph.currency_code INTO l_vendor_id, g_current_currency_code
4298: FROM po_vendors vn, po_headers_all ph
4299: WHERE vn.vendor_id = ph.vendor_id
4300: AND ph.po_header_id = PO_COMMUNICATION_PVT.g_release_header_id ;
4301:
4302: IF p_which_tables = 'MAIN' THEN

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

4473: --bug#3768142 added the condtion if p_document_type='RELEASE'
4474: --so that the attachments for Releases are also displayed
4475: --correctly. An order by is used so that first the
4476: --PO_HEADERS(BPA) attachments are printed followed by PO_RELEASES
4477: --attachments and then finally PO_VENDORS. This is necessary
4478: --only for the Releases because you can display the BPA header
4479: --attachments also with a release.
4480:
4481: if(p_document_type='RELEASE')then

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

4490: WHERE ((entity_name=''PO_HEADERS'' AND
4491: pk1_value=to_char(phx.po_header_id))OR
4492: (entity_name = ''PO_RELEASES'' AND
4493: pk1_value = to_char(phx.po_release_id)) OR
4494: (entity_name = ''PO_VENDORS'' AND
4495: pk1_value = to_char(phx.vendor_id)) OR
4496: (entity_name = ''PO_VENDOR_SITES'' AND
4497: pk1_value = to_char(phx.vendor_site_id))) AND -- bug6154354
4498: function_name = ''PO_PRINTPO''

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

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
4510: )
4511: AND fad.datatype_id=5
4512: AND fad.function_name=''PO_PRINTPO''

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

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
4522: )
4523: AND fad.datatype_id=6
4524: AND fad.function_name=''PO_PRINTPO''

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

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
4540: pk1_value = to_char(phx.vendor_id)) OR
4541: (entity_name = ''PO_VENDOR_SITES'' AND
4542: pk1_value = to_char(phx.vendor_site_id))) AND -- bug6154354
4543: function_name = ''PO_PRINTPO''

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

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: )
4555: AND fad.datatype_id=5
4556: AND fad.function_name=''PO_PRINTPO''

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

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: )
4566: AND fad.datatype_id=6
4567: AND fad.function_name=''PO_PRINTPO''

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

5283: --bug#3768142 also added the condition to check if the document
5284: --type is a release so that even the release header documents
5285: --are retrieved. An order by is used so that first the
5286: --PO_HEADERS(BPA) attachments are printed followed by PO_RELEASES
5287: --attachments and then finally PO_VENDORS. This is necessary
5288: --only for the Releases because you can display the BPA header
5289: --attachments also with a release.
5290: --bug#3823799: Replaced the hard coded p_document id with PO_COMMUNICATION_PVT.getDocumentId() function
5291: if(p_document_type='RELEASE')then

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

5304: WHERE ( (entity_name=''PO_RELEASES'' AND
5305: pk1_value= to_char(PO_COMMUNICATION_PVT.getDocumentId()) ) OR
5306: (entity_name = ''PO_HEADERS'' AND
5307: pk1_value = to_char(PO_COMMUNICATION_PVT.getReleaseHeaderId())) OR --Bug6139548
5308: (entity_name = ''PO_VENDORS'' AND
5309: pk1_value = to_char(PO_COMMUNICATION_PVT.getVendorId()))) AND
5310: function_name = ''PO_PRINTPO''
5311: and fad.media_id = fdl.media_id
5312: and fad.datatype_id=2

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

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
5331: pk1_value = to_char(PO_COMMUNICATION_PVT.getVendorId()))) AND
5332: function_name = ''PO_PRINTPO''
5333: and fad.media_id = fdl.media_id
5334: AND fad.datatype_id=2