APPS.INV_LABEL_PVT2 dependencies on WSH_DELIVERY_DETAILS

Line 362: FROM wsh_delivery_details wdd1, wsh_delivery_assignments_v wda, wsh_delivery_details wdd2

358: , wdd1.revision revision
359: , wdd1.serial_number serial_number
360: , wdd1.subinventory
361: , wdd1.requested_quantity_uom
362: FROM wsh_delivery_details wdd1, wsh_delivery_assignments_v wda, wsh_delivery_details wdd2
363: WHERE wdd1.delivery_detail_id(+) = wda.delivery_detail_id
364: AND wda.parent_delivery_detail_id(+) = wdd2.delivery_detail_id
365: AND wdd2.delivery_detail_id = p_transaction_id; --168158
366:

Line 382: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda,

378: , msnt.fm_serial_number fm_serial_number --Added to fix Bug# 4290536
379: , NVL(msnt.to_serial_number, msnt.fm_serial_number) to_serial_number --Added to fix Bug# 4290536
380: , wdd.subinventory
381: , wdd.requested_quantity_uom
382: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda,
383: wsh_new_deliveries wnd, mtl_serial_numbers_temp msnt
384: WHERE wda.delivery_id = wnd.delivery_id
385: AND NVL(wdd.transaction_temp_id, -1) = msnt.transaction_temp_id(+)
386: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 1462: -- to be derived for the delivery ID. There will be one record per serial number in the wsh_delivery_details.

1458:
1459: ELSIF p_label_type_info.business_flow_code IN(21) THEN
1460: -- Ship Confirm
1461: -- The delivery_id has being passed. Delivery ID passed means that all the delivery details ID have
1462: -- to be derived for the delivery ID. There will be one record per serial number in the wsh_delivery_details.
1463: -- The cost group will be derived from the table wms_license_plate_numbers for the LPN stamped on the Delivery_detail_id.
1464: IF (l_debug = 1) THEN
1465: TRACE(' Ship Confirm Flow with Delivery ID: ' || p_transaction_id);
1466: END IF;