DBA Data[Home] [Help]

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;