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.WIP_EAMMTLPROC_PRIV dependencies on WIP_DISCRETE_JOBS

Line 342: from wip_discrete_jobs wdj, mtl_object_genealogy mog,

338: and mti.rebuild_serial_number = msn.serial_number
339: and ( msn.current_status = 1 --defined not used
340: or ( msn.current_status in (3,4) --issued out or in stores
341: and exists(select 1
342: from wip_discrete_jobs wdj, mtl_object_genealogy mog,
343: csi_item_instances cii, mtl_serial_numbers msn_parent
344: where wdj.maintenance_object_id = cii.instance_id
345: and wdj.maintenance_object_type = 3
346: and wdj.wip_entity_id = mti.transaction_source_id

Line 461: from wip_discrete_jobs wdj, csi_item_instances cii, mtl_serial_numbers msn

457:
458: select wdj.maintenance_object_id, wdj.maintenance_object_type,
459: wdj.maintenance_object_source, msn.gen_object_id
460: into l_maintObjID, l_maintObjType, l_maintObjSrc, l_maintGenObjID
461: from wip_discrete_jobs wdj, csi_item_instances cii, mtl_serial_numbers msn
462: where wdj.wip_entity_id = p_compRec.wipEntityID
463: and wdj.maintenance_object_type = 3
464: and wdj.maintenance_object_id = cii.instance_id
465: and msn.serial_number (+) = cii.serial_number --Modified outer join for bug 6892336