2655: -- UPDATE lpn context
2656:
2657: l_progress := '100';
2658:
2659: UPDATE wms_license_plate_numbers
2660: SET lpn_context = 3
2661: WHERE lpn_id = p_lpn_id;
2662:
2663: l_progress := '110';
2796: wlpnc.uom_code,
2797: wlpnc.lot_number,
2798: wlpnc.source_line_id
2799: FROM wms_lpn_contents wlpnc
2800: , wms_license_plate_numbers wlpn
2801: , mtl_system_items msi
2802: , rcv_shipment_headers rsh
2803: WHERE rsh.shipment_header_id = p_shipment_header_id
2804: AND (wlpn.source_header_id = rsh.shipment_header_id
3098: l_progress := '70';
3099:
3100: -- UPDATE lpn context
3101:
3102: UPDATE wms_license_plate_numbers
3103: SET lpn_context = 3
3104: WHERE source_header_id = p_shipment_header_id
3105: AND lpn_id = Nvl(p_lpn_id, lpn_id);
3106:
3115: set source_name = 'ASNEXP',
3116: source_header_id = INV_rcv_common_apis.g_rcv_global_var.interface_group_id
3117: where lpn_context = 7
3118: and parent_lpn_id in (select lpn_id
3119: from wms_license_plate_numbers
3120: WHERE source_header_id = p_shipment_header_id
3121: AND lpn_id = Nvl(p_lpn_id, lpn_id)
3122: );
3123: