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:
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: