[Home] [Help]
188: , rt.oe_order_line_id --Bug 4582954
189: FROM rcv_transactions rt, rcv_serials_supply rss, po_lines_all pol
190: -- , po_distributions_all pod --Commented as part of Bug# 3586116
191: , po_headers_all pha, rcv_shipment_lines rsl
192: , wms_license_plate_numbers wlpn -- Bug 3836623
193: WHERE rss.transaction_id = rt.transaction_id
194: AND pol.po_line_id(+) = rt.po_line_id
195: AND pha.po_header_id(+) = rt.po_header_id
196: -- AND pod.po_distribution_id(+) = rt.po_distribution_id --Commented as part of Bug# 3586116
239: -- , po_distributions_all pod --Commented as part of Bug# 3586116
240: , po_lines_all pol
241: , po_headers_all pha
242: , rcv_shipment_lines rsl
243: , wms_license_plate_numbers wlpn -- Bug 3836623
244: -- Bug 4179732, can not print serial number from putaway
245: -- Changed to link to MUT through MMT
246: , mtl_material_transactions mmt
247: WHERE mmt.rcv_transaction_id = rt.transaction_id
1343: -- Cross Dock(6).
1344: -- Here in this case the delivery_detail_id is being passed.
1345: -- Delivery detail ID passed means that we just have to print serial label for the one delivery detail id and
1346: -- not all the delivery detail id's in the delivery.
1347: -- The cost group will be derived from the table wms_license_plate_numbers for the LPN stamped on the Delivery_detail_id.
1348: OPEN wdd_serial_cur;
1349:
1350: FETCH wdd_serial_cur
1351: INTO l_inventory_item_id
1452: ELSIF p_label_type_info.business_flow_code IN(21) THEN
1453: -- Ship Confirm
1454: -- The delivery_id has being passed. Delivery ID passed means that all the delivery details ID have
1455: -- to be derived for the delivery ID. There will be one record per serial number in the wsh_delivery_details.
1456: -- The cost group will be derived from the table wms_license_plate_numbers for the LPN stamped on the Delivery_detail_id.
1457: IF (l_debug = 1) THEN
1458: TRACE(' Ship Confirm Flow with Delivery ID: ' || p_transaction_id);
1459: END IF;
1460: OPEN wda_serial_cur;