PO Receiving Transaction Upload

select
null action_,
null status_,
null message_,
null modified_columns_,
to_number(null) request_id_,
to_char(null) row_id,
mp.organization_code,
aps.vendor_name supplier,
assa.vendor_site_code supplier_site,
pha.segment1 po_number,
pla.line_num,
plla.shipment_num,
msibk.concatenated_segments item,
pla.item_revision,
pla.item_description,
plla.quantity quantity_ordered,
nvl(plla.quantity_received,0) quantity_received,
plla.quantity-nvl(plla.quantity_received,0) quantity_remaining,
pla.unit_meas_lookup_code unit_of_measure,
to_number(null) quantity,
to_date(null) transaction_date,
(select xxen_util.meaning(pda.destination_type_code,'DESTINATION TYPE',201) from po_distributions_all pda where pda.line_location_id=plla.line_location_id and rownum=1) destination_type,
(select pda.destination_subinventory from po_distributions_all pda where pda.line_location_id=plla.line_location_id and rownum=1) subinventory,
to_char(null) locator,
(select hla.location_code from hr_locations_all hla where hla.location_id=(select pda.deliver_to_location_id from po_distributions_all pda where pda.line_location_id=plla.line_location_id and rownum=1)) deliver_to_location,
(select ft.territory_short_name from fnd_territories_vl ft where ft.territory_code=plla.country_of_origin_code) country_of_origin,
to_char(null) vendor_lot_num,
to_char(null) comments
from
po_headers_all pha,
ap_suppliers aps,
ap_supplier_sites_all assa,
po_lines_all pla,
po_line_locations_all plla,
mtl_parameters mp,
mtl_system_items_b_kfv msibk
where
pha.vendor_id=aps.vendor_id and
pha.vendor_site_id=assa.vendor_site_id(+) and
pha.po_header_id=pla.po_header_id and
pla.po_line_id=plla.po_line_id and
plla.ship_to_organization_id=mp.organization_id and
pla.item_id=msibk.inventory_item_id(+) and
plla.ship_to_organization_id=msibk.organization_id(+) and
plla.shipment_type in ('STANDARD','BLANKET','SCHEDULED') and
nvl(plla.approved_flag,'N')='Y' and
nvl(plla.cancel_flag,'N')='N' and
nvl(plla.closed_code,'OPEN') not in ('FINALLY CLOSED','CLOSED','CLOSED FOR RECEIVING') and
plla.quantity-nvl(plla.quantity_received,0)>0 and
1=1

select null action_, null status_, null message_, null modified_columns_, to_number(null) request_id_, to_char(null) row_id, mp.organization_code, aps.vendor_name supplier, assa.vendor_site_code supplier_site, pha.segment1 po_number, pla.line_num, plla.shipment_num, msibk.concatenated_segments item, pla.item_revision, pla.item_description, plla.quantity quantity_ordered, nvl(plla.quantity_received,0) quantity_received, plla.quantity-nvl(plla.quantity_received,0) quantity_remaining, pla.unit_meas_lookup_code unit_of_measure, to_number(null) quantity, to_date(null) transaction_date, (select xxen_util.meaning(pda.destination_type_code,'DESTINATION TYPE',201) from po_distributions_all pda where pda.line_location_id=plla.line_location_id and rownum=1) destination_type, (select pda.destination_subinventory from po_distributions_all pda where pda.line_location_id=plla.line_location_id and rownum=1) subinventory, to_char(null) locator, (select hla.location_code from hr_locations_all hla where hla.location_id=(select pda.deliver_to_location_id from po_distributions_all pda where pda.line_location_id=plla.line_location_id and rownum=1)) deliver_to_location, (select ft.territory_short_name from fnd_territories_vl ft where ft.territory_code=plla.country_of_origin_code) country_of_origin, to_char(null) vendor_lot_num, to_char(null) comments from po_headers_all pha, ap_suppliers aps, ap_supplier_sites_all assa, po_lines_all pla, po_line_locations_all plla, mtl_parameters mp, mtl_system_items_b_kfv msibk where pha.vendor_id=aps.vendor_id and pha.vendor_site_id=assa.vendor_site_id(+) and pha.po_header_id=pla.po_header_id and pla.po_line_id=plla.po_line_id and plla.ship_to_organization_id=mp.organization_id and pla.item_id=msibk.inventory_item_id(+) and plla.ship_to_organization_id=msibk.organization_id(+) and plla.shipment_type in ('STANDARD','BLANKET','SCHEDULED') and nvl(plla.approved_flag,'N')='Y' and nvl(plla.cancel_flag,'N')='N' and nvl(plla.closed_code,'OPEN') not in ('FINALLY CLOSED','CLOSED','CLOSED FOR RECEIVING') and plla.quantity-nvl(plla.quantity_received,0)>0 and 1=1