DBA Data[Home] [Help]

APPS.EAM_SAFETY_REPORTS_PVT dependencies on EAM_WORK_CLEARANCES

Line 117: EAM_WORK_CLEARANCES EWC,

113: ML.MEANING AS ISOLATION_TYPE,
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

Line 142: EAM_WORK_CLEARANCES EWC,

138: ML.MEANING AS ISOLATION_TYPE,
139: 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,
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,

Line 215: EAM_WORK_CLEARANCES EWC,

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:
218: WHERE
219: ESA1.SOURCE_ID=PERMIT.PERMIT_ID AND