[Home] [Help]
205: ppf.full_name requestor, hrl1.location_code deliver_to_location,
206: hrl2.location_code location, pll.note_to_receiver note_to_receiver
207: FROM rcv_transactions_interface rti, po_headers_trx_v pha,--CLM Changes,using CLM views instead of base tables
208: -- MOAC : changed po_line_locations to po_line_locations_all
209: po_lines_trx_v pol, rcv_shipment_headers rsh, po_line_locations_trx_v pll,
210: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
211: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
212: po_vendor_sites_all pvs, per_people_f ppf
213: where rti.interface_transaction_id = p_transaction_id
237: hrl1.location_code deliver_to_location, hrl2.location_code location,
238: pll.note_to_receiver note_to_receiver
239: FROM rcv_transactions_interface rti, po_headers_trx_v pha,--CLM Changes,using CLM views instead of base tables
240: -- MOAC : changed po_line_locations to po_line_locations_all
241: po_lines_trx_v pol, rcv_shipment_headers rsh, po_line_locations_trx_v pll,
242: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
243: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
244: po_vendor_sites_all pvs, per_people_f ppf
245: where rti.interface_transaction_id = p_transaction_id
423: )
424: ) all_lpn
425: , po_headers_trx_v pha--CLM Changes, using CLM views instead of base tables
426: , po_lines_trx_v pol
427: , rcv_shipment_headers rsh
428: , rcv_shipment_lines rsl
429: -- MOAC : changed po_line_locations to po_line_locations_all
430: , po_line_locations_trx_v pll
431: , po_vendors pov
646: , rsl.COUNTRY_OF_ORIGIN_CODE
647: , rsl.comments
648: , rsl.vendor_item_num
649: from wms_license_plate_numbers lpn,
650: rcv_shipment_headers rsh,
651: rcv_shipment_lines rsl
652: where lpn.source_name = rsh.shipment_num
653: AND lpn.lpn_context = 7
654: AND rsl.shipment_header_id = rsh.shipment_header_id
668: , rsl.COUNTRY_OF_ORIGIN_CODE
669: , rsl.comments
670: , rsl.vendor_item_num
671: from wms_license_plate_numbers lpn,
672: rcv_shipment_headers rsh,
673: rcv_shipment_lines rsl
674: where lpn.source_name = rsh.shipment_num
675: AND lpn.lpn_context = 7
676: AND rsl.shipment_header_id = rsh.shipment_header_id
690: , rsl.COUNTRY_OF_ORIGIN_CODE
691: , rsl.comments
692: , rsl.vendor_item_num
693: from wms_license_plate_numbers lpn,
694: rcv_shipment_headers rsh,
695: rcv_shipment_lines rsl
696: where lpn.source_name = rsh.shipment_num
697: AND lpn.lpn_context = 7
698: AND rsl.shipment_header_id = rsh.shipment_header_id
701: AND rsh.asn_type = 'ASN'
702: ) all_lpn
703: , po_headers_trx_v pha--CLM Changes, using CLM views instead of base tables
704: , po_lines_trx_v pol
705: , rcv_shipment_headers rsh
706: -- MOAC : changed po_line_locations to po_line_locations_all
707: , po_line_locations_trx_v pll
708: , po_vendors pov
709: , hr_locations_all hrl1
1744: l_rcv_isp_header.bill_of_lading, l_rcv_isp_header.waybill_airbill_num,
1745: l_rcv_isp_header.packing_slip,
1746: l_rcv_isp_header.packaging_code, l_rcv_isp_header.special_handling_code,
1747: l_rcv_isp_header.receipt_num, l_rcv_isp_header.comments
1748: FROM rcv_shipment_headers
1749: WHERE shipment_header_id = p_transaction_id
1750: -- OR shipment_header_id in --Bug 5051210. Performance fix. Removing OR and adding UNION
1751: UNION
1752: SELECT shipment_num asn_num, shipped_date shipment_date,
1755: bill_of_lading, waybill_airbill_num,
1756: packing_slip,
1757: packaging_code, special_handling_code,
1758: receipt_num, comments
1759: FROM rcv_shipment_headers
1760: WHERE shipment_header_id IN
1761: (select shipment_header_id from rcv_shipment_lines
1762: where asn_lpn_id = p_lpn_id);
1763: