[Home] [Help]
427: , lpn.subinventory_code, lpn.locator_id
428: , rsh.shipment_header_id
429: , rsl.po_line_location_id
430: from wms_license_plate_numbers lpn,
431: rcv_shipment_headers rsh,
432: rcv_shipment_lines rsl
433: where lpn.source_name = rsh.shipment_num
434: AND lpn.lpn_context = 7
435: AND rsl.shipment_header_id = rsh.shipment_header_id
442: , lpn.subinventory_code, lpn.locator_id
443: , rsh.shipment_header_id
444: , rsl.po_line_location_id
445: from wms_license_plate_numbers lpn,
446: rcv_shipment_headers rsh,
447: rcv_shipment_lines rsl
448: where lpn.source_name = rsh.shipment_num
449: AND lpn.lpn_context = 7
450: AND rsl.shipment_header_id = rsh.shipment_header_id
457: , lpn.subinventory_code, lpn.locator_id
458: , rsh.shipment_header_id
459: , rsl.po_line_location_id
460: from wms_license_plate_numbers lpn,
461: rcv_shipment_headers rsh,
462: rcv_shipment_lines rsl
463: where lpn.source_name = rsh.shipment_num
464: AND lpn.lpn_context = 7
465: AND rsl.shipment_header_id = rsh.shipment_header_id
468: AND rsh.asn_type = 'ASN'
469: ) all_lpn
470: , po_headers_trx_v pha--CLM Changes, using CLM views instead of base tables
471: , po_lines_trx_v pol
472: , rcv_shipment_headers rsh
473: , po_line_locations_trx_v pll
474: WHERE pha.po_header_id(+) = all_lpn.po_header_id
475: AND rsh.shipment_header_id(+) = all_lpn.shipment_header_id
476: AND pol.po_line_id (+) = all_lpn.po_line_id
715: l_rcv_isp_header.bill_of_lading, l_rcv_isp_header.waybill_airbill_num,
716: l_rcv_isp_header.packing_slip,
717: l_rcv_isp_header.packaging_code, l_rcv_isp_header.special_handling_code,
718: l_rcv_isp_header.receipt_num, l_rcv_isp_header.comments
719: FROM rcv_shipment_headers
720: WHERE shipment_header_id = p_transaction_id;
721:
722: FOR v_asn_lpn IN c_asn_lpn LOOP
723: l_rcv_lpn_table(i).lpn_id := v_asn_lpn.lpn_id;