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_WORKORDERREP_PVT dependencies on EAM_WORK_CLEARANCES

Line 703: eam_work_clearances ewc ,

699: ||'-'
700: ||fnd_message.get_string('EAM','EAM_PENDING_TEXT'), ewsv.work_clearance_status) AS user_status,
701: ml2.meaning AS isolation_type
702: FROM
703: eam_work_clearances ewc ,
704: eam_safety_associations esa ,
705: wip_discrete_jobs wdj ,
706: mfg_lookups ml1 ,
707: mfg_lookups ml2 ,

Line 735: FROM eam_work_clearances ewc1 ,

731: DECODE(ewc1.pending_flag,'Y',ewsv1.work_clearance_status
732: ||'-'
733: ||fnd_message.get_string('EAM','EAM_PENDING_TEXT'), ewsv1.work_clearance_status) AS user_status,
734: ml4.meaning AS isolation_type
735: FROM eam_work_clearances ewc1 ,
736: eam_work_permits permit ,
737: eam_safety_associations esa1 ,
738: eam_safety_associations esa2 ,
739: mfg_lookups ml3 ,

Line 759: FROM eam_work_clearances ewc,

755: AND ewsv1.status_id =ewc1.user_defined_status_id
756: AND wdj1.wip_entity_id =p_wip_id
757: AND ewc1.work_clearance_id NOT IN
758: (SELECT ewc.WORK_CLEARANCE_ID
759: FROM eam_work_clearances ewc,
760: eam_safety_associations esa ,
761: wip_discrete_jobs wdj
762: WHERE esa.target_ref_id=wdj.wip_entity_id
763: AND esa.source_id =ewc.WORK_CLEARANCE_ID