DBA Data[Home] [Help]

APPS.EAM_SAFETY_REPORTS_PVT dependencies on EAM_WORK_CLEARANCE_STATUSES_VL

Line 119: EAM_WORK_CLEARANCE_STATUSES_VL EWCSV,

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
123: ESA.ASSOCIATION_TYPE= 2

Line 149: EAM_WORK_CLEARANCE_STATUSES_VL EWCSV

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
150:
151: WHERE
152: ESA1.SOURCE_ID=PERMIT.PERMIT_ID AND
153: ESA1.TARGET_REF_ID=WDJ.WIP_ENTITY_ID AND