eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_WO_VALIDATE_PVT dependencies on MTL_SERIAL_NUMBERS

Line 1207: FROM mtl_object_genealogy mog, mtl_serial_numbers msn, wip_discrete_jobs wdj,

1203: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating parent_wip_entity_id . rebuild status=' || l_rebuild_status); END IF;
1204:
1205: SELECT 1
1206: INTO g_dummy
1207: FROM mtl_object_genealogy mog, mtl_serial_numbers msn, wip_discrete_jobs wdj,
1208: mtl_serial_numbers msn1, csi_item_instances cii, mtl_parameters mp, csi_item_instances cii1
1209: WHERE p_eam_wo_rec.rebuild_item_id is not null
1210: and cii.instance_id = p_eam_wo_rec.maintenance_object_id
1211: and cii.last_vld_organization_id = mp.organization_id

Line 1208: mtl_serial_numbers msn1, csi_item_instances cii, mtl_parameters mp, csi_item_instances cii1

1204:
1205: SELECT 1
1206: INTO g_dummy
1207: FROM mtl_object_genealogy mog, mtl_serial_numbers msn, wip_discrete_jobs wdj,
1208: mtl_serial_numbers msn1, csi_item_instances cii, mtl_parameters mp, csi_item_instances cii1
1209: WHERE p_eam_wo_rec.rebuild_item_id is not null
1210: and cii.instance_id = p_eam_wo_rec.maintenance_object_id
1211: and cii.last_vld_organization_id = mp.organization_id
1212: and mp.maint_organization_id = p_eam_wo_rec.organization_id