APPS.WMS_WORKFLOW_WRAPPERS dependencies on MTL_SERIAL_NUMBERS

Line 746: FROM mtl_serial_numbers

742: AND l_serial_number IS NOT NULL) THEN
743: IF p_serial_number_status IS NULL THEN
744: SELECT status_id
745: INTO l_serial_number_status
746: FROM mtl_serial_numbers
747: WHERE serial_number = l_serial_number
748: AND inventory_item_id = l_inventory_item_id;
749: ELSE
750: l_serial_number_status := p_serial_number_status;