DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_PVT dependencies on MTL_SERIAL_NUMBERS

Line 7165: from mtl_serial_numbers msn

7161:
7162: 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
7163: select msn.current_status
7164: into l_current_status
7165: from mtl_serial_numbers msn
7166: where inventory_item_id = nvl(l_eam_wo_rec.rebuild_item_id, l_eam_wo_rec.asset_group_id)
7167: and serial_number = nvl(l_eam_wo_rec.rebuild_serial_number, l_eam_wo_rec.asset_number);
7168:
7169: IF (l_current_status = 1 OR l_eam_wo_rec.maintenance_object_type = 2) THEN