DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_PVT dependencies on MTL_SERIAL_NUMBERS

Line 6799: from mtl_serial_numbers msn

6795:
6796: IF ((l_eam_wo_rec.rebuild_serial_number is not null and l_eam_wo_rec.rebuild_serial_number <> FND_API.G_MISS_CHAR )or l_eam_wo_rec.asset_number is not null ) then
6797: select msn.current_status
6798: into l_current_status
6799: from mtl_serial_numbers msn
6800: where inventory_item_id = nvl(l_eam_wo_rec.rebuild_item_id, l_eam_wo_rec.asset_group_id)
6801: and serial_number = nvl(l_eam_wo_rec.rebuild_serial_number, l_eam_wo_rec.asset_number);
6802:
6803: IF (l_current_status = 1 OR l_eam_wo_rec.maintenance_object_type = 2) THEN