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 341: from wip_discrete_jobs wdj, mtl_object_genealogy mog,

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

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

435:
436: select wdj.maintenance_object_id, wdj.maintenance_object_type,
437: wdj.maintenance_object_source, msn.gen_object_id
438: into l_maintObjID, l_maintObjType, l_maintObjSrc, l_maintGenObjID
439: from wip_discrete_jobs wdj, csi_item_instances cii, mtl_serial_numbers msn
440: where wdj.wip_entity_id = p_compRec.wipEntityID
441: and wdj.maintenance_object_type = 3
442: and wdj.maintenance_object_id = cii.instance_id
443: and msn.serial_number (+) = cii.serial_number --Modified outer join for bug 6892336