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_SAFETY_REPORTS_PVT dependencies on EAM_SAFETY_ASSOCIATIONS

Line 118: EAM_SAFETY_ASSOCIATIONS ESA,

114: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWC.SCHEDULED_ESTAB_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS SCHEDULED_ESTAB_START_DATE,
115: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWC.SCHEDULED_REESTAB_END_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS SCHEDULED_REESTAB_END_DATE
116: FROM
117: EAM_WORK_CLEARANCES EWC,
118: EAM_SAFETY_ASSOCIATIONS ESA,
119: EAM_WORK_CLEARANCE_STATUSES_VL EWCSV,
120: EAM_ISOLATIONS ISO,
121: MFG_LOOKUPS ml
122: WHERE

Line 144: EAM_SAFETY_ASSOCIATIONS ESA1,

140: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWC.SCHEDULED_REESTAB_END_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS SCHEDULED_REESTAB_END_DATE
141: FROM
142: EAM_WORK_CLEARANCES EWC,
143: EAM_WORK_PERMITS PERMIT,
144: EAM_SAFETY_ASSOCIATIONS ESA1,
145: EAM_SAFETY_ASSOCIATIONS ESA2,
146: MFG_LOOKUPS ML,
147: EAM_ISOLATIONS ISO,
148: WIP_DISCRETE_JOBS WDJ,

Line 145: EAM_SAFETY_ASSOCIATIONS ESA2,

141: FROM
142: EAM_WORK_CLEARANCES EWC,
143: EAM_WORK_PERMITS PERMIT,
144: EAM_SAFETY_ASSOCIATIONS ESA1,
145: EAM_SAFETY_ASSOCIATIONS ESA2,
146: MFG_LOOKUPS ML,
147: EAM_ISOLATIONS ISO,
148: WIP_DISCRETE_JOBS WDJ,
149: EAM_WORK_CLEARANCE_STATUSES_VL EWCSV

Line 164: FROM EAM_SAFETY_ASSOCIATIONS

160: ML.LOOKUP_TYPE (+) = 'EAM_ISOLATION_TYPE' AND
161: PERMIT.PERMIT_ID=P_PERMIT_ID AND
162: PERMIT.ORGANIZATION_ID = P_ORGANIZATION_ID
163: AND EWC.WORK_CLEARANCE_ID NOT IN(SELECT TARGET_REF_ID
164: FROM EAM_SAFETY_ASSOCIATIONS
165: WHERE SOURCE_ID = P_PERMIT_ID
166: AND ASSOCIATION_TYPE=2
167: AND ORGANIZATION_ID=P_ORGANIZATION_ID)
168: AND EWC.USER_DEFINED_STATUS_ID = EWCSV.STATUS_ID

Line 194: EAM_SAFETY_ASSOCIATIONS ESA

190: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WEDV.SCHEDULED_COMPLETION_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS WO_SCHEDULED_COMPL_DATE
191:
192: FROM
193: EAM_WORK_ORDERS_V WEDV,
194: EAM_SAFETY_ASSOCIATIONS ESA
195: WHERE
196: ESA.ASSOCIATION_TYPE= 3
197: AND ESA.SOURCE_ID =P_PERMIT_ID
198: AND ESA.ORGANIZATION_ID =P_ORGANIZATION_ID

Line 212: EAM_SAFETY_ASSOCIATIONS ESA1,

208: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WEDV.SCHEDULED_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS WO_SCHEDULED_START_DATE,
209: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WEDV.SCHEDULED_COMPLETION_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS WO_SCHEDULED_COMPL_DATE
210:
211: FROM
212: EAM_SAFETY_ASSOCIATIONS ESA1,
213: EAM_SAFETY_ASSOCIATIONS ESA2,
214: EAM_WORK_PERMITS PERMIT,
215: EAM_WORK_CLEARANCES EWC,
216: EAM_WORK_ORDERS_V WEDV

Line 213: EAM_SAFETY_ASSOCIATIONS ESA2,

209: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WEDV.SCHEDULED_COMPLETION_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS WO_SCHEDULED_COMPL_DATE
210:
211: FROM
212: EAM_SAFETY_ASSOCIATIONS ESA1,
213: EAM_SAFETY_ASSOCIATIONS ESA2,
214: EAM_WORK_PERMITS PERMIT,
215: EAM_WORK_CLEARANCES EWC,
216: EAM_WORK_ORDERS_V WEDV
217: