APPS.EAM_MATERIALISSUE_PVT dependencies on MTL_SERIAL_NUMBERS
Line 227: FROM mtl_serial_numbers msn
223:
224:
225: SELECT COUNT(serial_number)
226: INTO l_num_valid_serials 227: FROM mtl_serial_numbers msn 228: WHERE msn.inventory_item_id = l_inventory_item_id
229: and msn.current_organization_id = l_organization_id
230: and msn.current_subinventory_code = l_source_subinventory
231: and (msn.group_mark_id is null or msn.group_mark_id = -1)