APPS.PO_OTM_INTEGRATION_PVT dependencies on PO_RELEASES_ARCHIVE_ALL

Line 411: , po_releases_archive_all pora

407: , l_release_number
408: , l_doc_revision
409: , l_org_name
410: FROM po_headers_archive_all poha
411: , po_releases_archive_all pora
412: , hr_all_organization_units hou
413: WHERE pora.po_release_id = p_doc_id
414: AND pora.latest_external_flag = 'Y'
415: AND poha.po_header_id = pora.po_header_id

Line 1582: , po_releases_archive_all pora

1578: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_phone
1579: , HR_GENERAL.get_phone_number(
1580: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_fax
1581: FROM po_headers_archive_all poha
1582: , po_releases_archive_all pora
1583: , po_lines_archive_all pola
1584: , po_line_locations_archive_all plla
1585: , hr_all_organization_units hou
1586: , hr_locations_all hrl

Line 1724: , po_releases_archive_all pora

1720: , x_otm_doc.bill_to_location_id
1721: , x_otm_doc.bill_to_location_code
1722: , x_otm_doc.terms
1723: FROM po_headers_archive_all poha
1724: , po_releases_archive_all pora
1725: , po_vendors pov
1726: , po_vendor_sites_all povs
1727: , fnd_territories fter
1728: , po_vendor_contacts povc

Line 2109: , po_releases_archive_all pora

2105: , plla.line_location_id
2106: , pola.line_num
2107: , plla.shipment_num
2108: FROM po_headers_archive_all poha
2109: , po_releases_archive_all pora
2110: , po_lines_archive_all pola
2111: , po_line_locations_archive_all plla
2112: , mtl_system_items msi
2113: , financials_system_params_all fsp

Line 2172: , po_releases_archive_all pora

2168: , x_otm_doc.po_number
2169: , x_otm_doc.release_number
2170: , x_otm_doc.org_name
2171: FROM po_headers_archive_all poha
2172: , po_releases_archive_all pora
2173: , hr_all_organization_units hou
2174: WHERE pora.po_release_id = p_doc_id
2175: AND pora.revision_num = p_doc_revision
2176: AND poha.po_header_id = pora.po_header_id