APPS.PO_OTM_INTEGRATION_PVT dependencies on PO_RELEASES_ARCHIVE_ALL

Line 385: , po_releases_archive_all pora

381: , l_release_number
382: , l_doc_revision
383: , l_org_name
384: FROM po_headers_archive_all poha
385: , po_releases_archive_all pora
386: , hr_all_organization_units hou
387: WHERE pora.po_release_id = p_doc_id
388: AND pora.latest_external_flag = 'Y'
389: AND poha.po_header_id = pora.po_header_id

Line 1510: , po_releases_archive_all pora

1506: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_phone
1507: , HR_GENERAL.get_phone_number(
1508: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_fax
1509: FROM po_headers_archive_all poha
1510: , po_releases_archive_all pora
1511: , po_lines_archive_all pola
1512: , po_line_locations_archive_all plla
1513: , hr_all_organization_units hou
1514: , hr_locations_all hrl

Line 1652: , po_releases_archive_all pora

1648: , x_otm_doc.bill_to_location_id
1649: , x_otm_doc.bill_to_location_code
1650: , x_otm_doc.terms
1651: FROM po_headers_archive_all poha
1652: , po_releases_archive_all pora
1653: , po_vendors pov
1654: , po_vendor_sites_all povs
1655: , fnd_territories fter
1656: , po_vendor_contacts povc

Line 2037: , po_releases_archive_all pora

2033: , plla.line_location_id
2034: , pola.line_num
2035: , plla.shipment_num
2036: FROM po_headers_archive_all poha
2037: , po_releases_archive_all pora
2038: , po_lines_archive_all pola
2039: , po_line_locations_archive_all plla
2040: , mtl_system_items msi
2041: , financials_system_params_all fsp

Line 2100: , po_releases_archive_all pora

2096: , x_otm_doc.po_number
2097: , x_otm_doc.release_number
2098: , x_otm_doc.org_name
2099: FROM po_headers_archive_all poha
2100: , po_releases_archive_all pora
2101: , hr_all_organization_units hou
2102: WHERE pora.po_release_id = p_doc_id
2103: AND pora.revision_num = p_doc_revision
2104: AND poha.po_header_id = pora.po_header_id