DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on MTL_RESERVATIONS

Line 4169: mtl_reservations mr

4165:
4166: SELECT COUNT(msn.group_mark_id)
4167: INTO res_count
4168: FROM mtl_serial_numbers msn ,
4169: mtl_reservations mr
4170: WHERE mr.lpn_id =msn.lpn_id
4171: AND msn.group_mark_id=mr.reservation_id
4172: AND msn.lpn_id = p_lpn_id;
4173:

Line 4400: mtl_reservations mr

4396:
4397: SELECT COUNT(msn.group_mark_id)
4398: INTO res_count
4399: FROM mtl_serial_numbers msn ,
4400: mtl_reservations mr
4401: WHERE mr.lpn_id =msn.lpn_id
4402: AND msn.group_mark_id=mr.reservation_id
4403: AND msn.lpn_id = p_lpn_id;
4404: