756: FROM po_headers_archive_all poha
757: , po_lines_archive_all pola
758: , po_line_locations_archive_all plla
759: , hr_all_organization_units hou
760: , hr_locations_all hrl
761: , mtl_system_items_kfv msik
762: , mtl_units_of_measure muom
763: , financials_system_params_all fsp
764: , per_all_people_f ppf
891: , po_vendor_sites_all povs
892: , fnd_territories fter
893: , po_vendor_contacts povc
894: , hr_all_organization_units hou
895: , hr_locations_all hrl
896: , per_all_people_f ppf
897: , hr_locations_all hrl2
898: , ap_terms apt
899: WHERE poha.po_header_id = p_doc_id
893: , po_vendor_contacts povc
894: , hr_all_organization_units hou
895: , hr_locations_all hrl
896: , per_all_people_f ppf
897: , hr_locations_all hrl2
898: , ap_terms apt
899: WHERE poha.po_header_id = p_doc_id
900: AND poha.revision_num = p_doc_revision
901: AND poha.vendor_id = pov.vendor_id
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
1515: , mtl_system_items_kfv msik
1516: , mtl_units_of_measure muom
1517: , financials_system_params_all fsp
1518: , per_all_people_f ppf
1654: , po_vendor_sites_all povs
1655: , fnd_territories fter
1656: , po_vendor_contacts povc
1657: , hr_all_organization_units hou
1658: , hr_locations_all hrl
1659: , per_all_people_f ppf
1660: , hr_locations_all hrl2
1661: , ap_terms apt
1662: WHERE pora.po_release_id = p_doc_id
1656: , po_vendor_contacts povc
1657: , hr_all_organization_units hou
1658: , hr_locations_all hrl
1659: , per_all_people_f ppf
1660: , hr_locations_all hrl2
1661: , ap_terms apt
1662: WHERE pora.po_release_id = p_doc_id
1663: AND pora.revision_num = p_doc_revision
1664: AND poha.po_header_id = pora.po_header_id