DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on MTL_RESERVATIONS

Line 4389: mtl_reservations mr

4385:
4386: SELECT COUNT(msn.group_mark_id)
4387: INTO res_count
4388: FROM mtl_serial_numbers msn ,
4389: mtl_reservations mr
4390: WHERE mr.lpn_id =msn.lpn_id
4391: AND msn.group_mark_id=mr.reservation_id
4392: AND msn.lpn_id = p_lpn_id;
4393:

Line 4620: mtl_reservations mr

4616:
4617: SELECT COUNT(msn.group_mark_id)
4618: INTO res_count
4619: FROM mtl_serial_numbers msn ,
4620: mtl_reservations mr
4621: WHERE mr.lpn_id =msn.lpn_id
4622: AND msn.group_mark_id=mr.reservation_id
4623: AND msn.lpn_id = p_lpn_id;
4624: