APPS.INV_RESERVATION_PVT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 16729: wms_license_plate_numbers wlpn

16725: AND delivery_detail_id IN
16726: (SELECT wda.delivery_detail_id
16727: FROM wsh_delivery_assignments wda,
16728: wsh_delivery_details wdd2,
16729: wms_license_plate_numbers wlpn
16730: WHERE wda.parent_delivery_detail_id = wdd2.delivery_detail_id
16731: AND wdd2.lpn_id = wlpn.lpn_id
16732: AND wlpn.outermost_lpn_id = p_lpn_id
16733: AND wdd2.released_status = 'X'); -- For LPN reuse ER : 6845650

Line 16763: FROM wms_license_plate_numbers

16759: -- lpn_id for the LPN and it's child lpns will be stored in this global
16760: -- temp table under the line_id
16761: INSERT INTO WMS_TXN_CONTEXT_TEMP ( line_id, txn_source_name )
16762: SELECT distinct lpn_id, 'XFER_LPN_RES'
16763: FROM wms_license_plate_numbers
16764: START WITH lpn_id = p_lpn_id
16765: CONNECT BY parent_lpn_id = PRIOR lpn_id;
16766:
16767: FOR lpn_del_rec IN lpn_deliveries LOOP

Line 17360: FROM wms_license_plate_numbers

17356: AND mr.inventory_item_id = p_inventory_item_id
17357: AND mr.reservation_id = msn.reservation_id
17358: AND mr.lpn_id = null
17359: AND msn.lpn_id IN (SELECT lpn_id
17360: FROM wms_license_plate_numbers
17361: WHERE outermost_lpn_id = p_outermost_lpn_id)
17362: GROUP BY msn.reservation_id, msn.serial_number, msn.inventory_item_id;
17363:
17364: -- cursor of getting reservations with serial_number reserved in the lpn which

Line 17377: FROM wms_license_plate_numbers

17373: WHERE mr.organization_id = p_organization_id
17374: AND mr.reservation_id = msn.reservation_id
17375: AND mr.lpn_id = null
17376: AND msn.lpn_id IN (SELECT lpn_id
17377: FROM wms_license_plate_numbers
17378: WHERE outermost_lpn_id = p_outermost_lpn_id)
17379: GROUP BY msn.reservation_id, msn.serial_number, msn.inventory_item_id;
17380:
17381: -- cursor of getting reservations with serial_number reserved in the lpn