[Home] [Help]
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
835: , ( SELECT psg.index_num1 line_location_id
1341: FROM po_headers_archive_all poha
1342: , po_lines_archive_all pola
1343: , po_line_locations_archive_all plla
1344: , financials_system_params_all fsp
1345: , mtl_system_items msi
1346: WHERE poha.po_header_id = p_doc_id
1347: AND poha.revision_num = p_doc_revision
1348: AND pola.po_header_id = poha.po_header_id
1349: AND pola.revision_num =
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
1591: , ( SELECT psg.index_num1 line_location_id
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
2114: WHERE pora.po_release_id = p_doc_id
2115: AND pora.revision_num = p_doc_revision
2116: AND poha.po_header_id = pora.po_header_id
2751: NVL(PLL.cancel_flag, 'N'),
2752: NVL(PLL.closed_code, 'OPEN')
2753: FROM po_lines_all POL,
2754: po_line_locations_all PLL,
2755: mtl_system_items MSI
2756: WHERE POL.po_header_id = p_doc_id
2757: AND PLL.po_line_id = POL.po_line_id
2758: AND POL.order_type_lookup_code = 'QUANTITY'
2759: AND MSI.inventory_item_id(+) = POL.item_id
2907: NVL(PLL.closed_code, 'OPEN')
2908: FROM po_releases_all POR,
2909: po_lines_all POL,
2910: po_line_locations_all PLL,
2911: mtl_system_items MSI
2912: WHERE POR.po_release_id = p_doc_id
2913: AND POL.po_header_id = POR.po_header_id
2914: AND PLL.po_release_id = POR.po_release_id
2915: AND PLL.po_line_id = POL.po_line_id