DBA Data[Home] [Help]

APPS.EAM_SAFETY_REPORTS_PVT dependencies on EAM_WORK_ORDERS_V

Line 193: EAM_WORK_ORDERS_V WEDV,

189: 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,
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

Line 216: EAM_WORK_ORDERS_V WEDV

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
220: ESA1.TARGET_REF_ID=EWC.WORK_CLEARANCE_ID AND