APPS.INV_RESERVATION_PVT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 17896: wms_license_plate_numbers wlpn

17892: AND delivery_detail_id IN
17893: (SELECT wda.delivery_detail_id
17894: FROM wsh_delivery_assignments wda,
17895: wsh_delivery_details wdd2,
17896: wms_license_plate_numbers wlpn
17897: WHERE wda.parent_delivery_detail_id = wdd2.delivery_detail_id
17898: AND wdd2.lpn_id = wlpn.lpn_id
17899: AND wlpn.outermost_lpn_id = p_lpn_id
17900: AND wdd2.released_status = 'X'); -- For LPN reuse ER : 6845650

Line 17930: FROM wms_license_plate_numbers

17926: -- lpn_id for the LPN and it's child lpns will be stored in this global
17927: -- temp table under the line_id
17928: INSERT INTO WMS_TXN_CONTEXT_TEMP ( line_id, txn_source_name )
17929: SELECT distinct lpn_id, 'XFER_LPN_RES'
17930: FROM wms_license_plate_numbers
17931: START WITH lpn_id = p_lpn_id
17932: CONNECT BY parent_lpn_id = PRIOR lpn_id;
17933:
17934: FOR lpn_del_rec IN lpn_deliveries LOOP

Line 18528: FROM wms_license_plate_numbers

18524: AND mr.inventory_item_id = p_inventory_item_id
18525: AND mr.reservation_id = msn.reservation_id
18526: AND mr.lpn_id = null
18527: AND msn.lpn_id IN (SELECT lpn_id
18528: FROM wms_license_plate_numbers
18529: WHERE outermost_lpn_id = p_outermost_lpn_id)
18530: GROUP BY msn.reservation_id, msn.serial_number, msn.inventory_item_id;
18531:
18532: -- cursor of getting reservations with serial_number reserved in the lpn which

Line 18545: FROM wms_license_plate_numbers

18541: WHERE mr.organization_id = p_organization_id
18542: AND mr.reservation_id = msn.reservation_id
18543: AND mr.lpn_id = null
18544: AND msn.lpn_id IN (SELECT lpn_id
18545: FROM wms_license_plate_numbers
18546: WHERE outermost_lpn_id = p_outermost_lpn_id)
18547: GROUP BY msn.reservation_id, msn.serial_number, msn.inventory_item_id;
18548:
18549: -- cursor of getting reservations with serial_number reserved in the lpn