APPS.INV_LOT_SERIAL_UPGRADE dependencies on MTL_SERIAL_NUMBERS

Line 153: FROM mtl_serial_numbers

149: , p_organization_id IN NUMBER DEFAULT NULL
150: ) IS
151: CURSOR c_serial(p_org_id NUMBER) IS
152: SELECT current_organization_id, inventory_item_id, serial_number
153: FROM mtl_serial_numbers
154: WHERE current_organization_id = nvl(p_org_id, current_organization_id)
155: AND serial_attribute_category IS NULL
156: AND current_status in (3,4,5)
157: ORDER BY current_organization_id, inventory_item_id;