[Home] [Help]
826: FROM po_headers_archive_all poha
827: , po_lines_archive_all pola
828: , po_line_locations_archive_all plla
829: , hr_all_organization_units hou
830: , hr_locations_all hrl
831: , mtl_system_items_kfv msik
832: , mtl_units_of_measure muom
833: , financials_system_params_all fsp
834: , per_all_people_f ppf
961: , po_vendor_sites_all povs
962: , fnd_territories fter
963: , po_vendor_contacts povc
964: , hr_all_organization_units hou
965: , hr_locations_all hrl
966: , per_all_people_f ppf
967: , hr_locations_all hrl2
968: , ap_terms apt
969: WHERE poha.po_header_id = p_doc_id
963: , po_vendor_contacts povc
964: , hr_all_organization_units hou
965: , hr_locations_all hrl
966: , per_all_people_f ppf
967: , hr_locations_all hrl2
968: , ap_terms apt
969: WHERE poha.po_header_id = p_doc_id
970: AND poha.revision_num = p_doc_revision
971: AND poha.vendor_id = pov.vendor_id
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
1587: , mtl_system_items_kfv msik
1588: , mtl_units_of_measure muom
1589: , financials_system_params_all fsp
1590: , per_all_people_f ppf
1726: , po_vendor_sites_all povs
1727: , fnd_territories fter
1728: , po_vendor_contacts povc
1729: , hr_all_organization_units hou
1730: , hr_locations_all hrl
1731: , per_all_people_f ppf
1732: , hr_locations_all hrl2
1733: , ap_terms apt
1734: WHERE pora.po_release_id = p_doc_id
1728: , po_vendor_contacts povc
1729: , hr_all_organization_units hou
1730: , hr_locations_all hrl
1731: , per_all_people_f ppf
1732: , hr_locations_all hrl2
1733: , ap_terms apt
1734: WHERE pora.po_release_id = p_doc_id
1735: AND pora.revision_num = p_doc_revision
1736: AND poha.po_header_id = pora.po_header_id