APPS.WMS_WORKFLOW_WRAPPERS dependencies on MTL_SERIAL_NUMBERS
Line 748: FROM mtl_serial_numbers
744: AND l_serial_number IS NOT NULL) THEN
745: IF p_serial_number_status IS NULL THEN
746: SELECT status_id
747: INTO l_serial_number_status 748: FROM mtl_serial_numbers 749: WHERE serial_number = l_serial_number
750: AND inventory_item_id = l_inventory_item_id;
751: ELSE
752: l_serial_number_status := p_serial_number_status;