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_SAFETY_ASSOCIATIONS

Line 625: EAM_SAFETY_ASSOCIATIONS ESA,

621: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP.VALID_FROM), calendar_aware => FND_DATE.calendar_aware_alt)AS permit_valid_from,
622: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP.VALID_TO), calendar_aware => FND_DATE.calendar_aware_alt) AS permit_valid_to
623: from
624: EAM_WORK_PERMITS EWP,
625: EAM_SAFETY_ASSOCIATIONS ESA,
626: EAM_PERMIT_STATUSES_VL EPSV,
627: mfg_lookups ml
628: WHERE EWP.PERMIT_ID = ESA.SOURCE_ID
629: AND ESA.TARGET_REF_ID =p_wip_id

Line 645: EAM_SAFETY_ASSOCIATIONS ESA1,

641: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP1.VALID_FROM), calendar_aware => FND_DATE.calendar_aware_alt) AS permitValidFrom,
642: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP1.VALID_TO), calendar_aware => FND_DATE.calendar_aware_alt) AS permitValidTo
643:
644: FROM EAM_WORK_PERMITS EWP1,
645: EAM_SAFETY_ASSOCIATIONS ESA1,
646: eam_safety_associations esa2,
647: EAM_PERMIT_STATUSES_VL EPSV1,
648: mfg_lookups ml1
649: WHERE EWP1.PERMIT_ID = ESA1.SOURCE_ID

Line 646: eam_safety_associations esa2,

642: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP1.VALID_TO), calendar_aware => FND_DATE.calendar_aware_alt) AS permitValidTo
643:
644: FROM EAM_WORK_PERMITS EWP1,
645: EAM_SAFETY_ASSOCIATIONS ESA1,
646: eam_safety_associations esa2,
647: EAM_PERMIT_STATUSES_VL EPSV1,
648: mfg_lookups ml1
649: WHERE EWP1.PERMIT_ID = ESA1.SOURCE_ID
650: AND ESA2.TARGET_REF_ID =p_wip_id

Line 662: eam_safety_associations esa ,

658: AND ml1.lookup_code=ewp1.permit_type
659: and ewp1.PERMIT_ID not in (
660: SELECT permit.permit_id
661: FROM eam_work_permits permit,
662: eam_safety_associations esa ,
663: wip_discrete_jobs wdj ,
664: eam_permit_statuses_vl epsv
665: WHERE esa.target_ref_id=wdj.wip_entity_id
666: AND esa.source_id =permit.permit_id

Line 704: eam_safety_associations esa ,

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 ,
708: EAM_WORK_CLEARANCE_STATUSES_VL ewsv,

Line 737: eam_safety_associations esa1 ,

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 ,
740: mfg_lookups ml4 ,
741: eam_work_clearance_statuses_vl ewsv1,

Line 738: eam_safety_associations esa2 ,

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 ,
740: mfg_lookups ml4 ,
741: eam_work_clearance_statuses_vl ewsv1,
742: eam_isolations iso1 ,

Line 760: eam_safety_associations esa ,

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
764: AND esa.association_type =4