[Home] [Help]
128: pov.vendor_name supplier_name, pvs.vendor_site_id vendor_site_id,
129: pvs.vendor_site_code supplier_site, ppf.full_name requestor,
130: hrl1.location_code deliver_to_location,
131: hrl2.location_code location, pll.note_to_receiver note_to_receiver
132: FROM rcv_transactions_interface rti, po_headers_all pha,
133: -- MOAC : po_line_locations changed to po_line_locations_all
134: po_lines_all pol, rcv_shipment_headers rsh, po_line_locations_all pll,
135: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
136: -- MOAC : po_vendor_sites changed to po_vendor_sites_all
160: pov.vendor_name supplier_name, pvs.vendor_site_id vendor_site_id,
161: pvs.vendor_site_code supplier_site, ppf.full_name requestor,
162: hrl1.location_code deliver_to_location,
163: hrl2.location_code location, pll.note_to_receiver note_to_receiver
164: FROM rcv_transactions_interface rti, po_headers_all pha,
165: -- MOAC : po_line_locations changed to po_line_locations_all
166: po_lines_all pol, rcv_shipment_headers rsh, po_line_locations_all pll,
167: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
168: -- MOAC : po_vendor_sites changed to po_vendor_sites_all
353: AND p_label_type_info.business_flow_code = 1
354: )
355: )
356: ) all_lpn
357: , po_headers_all pha
358: , po_lines_all pol
359: , rcv_shipment_headers rsh
360: , rcv_shipment_lines rsl
361: -- MOAC : po_line_locations changed to po_line_locations_all
986: and rsh.shipment_header_id = p_transaction_id
987: and rsl.asn_lpn_id = lpn.lpn_id
988: AND rsh.asn_type = 'ASN'
989: ) all_lpn
990: , po_headers_all pha
991: , po_lines_all pol
992: , rcv_shipment_headers rsh
993: -- MOAC : po_line_locations changed to po_line_locations_all
994: , po_line_locations_all pll
1137:
1138: l_content_lpn_id NUMBER;
1139: l_transfer_lpn_id NUMBER;
1140: l_from_lpn_id NUMBER;
1141: l_purchase_order PO_HEADERS_ALL.SEGMENT1%TYPE;
1142:
1143: l_content_item_data LONG;
1144: --l_child_lpn_summary LONG;
1145: l_child_lpn_summary INV_LABEL.label_tbl_type;