DBA Data[Home] [Help]

APPS.EAM_SAFETY_REPORTS_PVT dependencies on MFG_LOOKUPS

Line 67: mfg_lookups ml,

63: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP.VALID_TO), calendar_aware => FND_DATE.calendar_aware_alt) AS PERMIT_VALID_TO
64: ))"PERMIT_HEADER"
65: FROM EAM_WORK_PERMITS EWP,
66: EAM_PERMIT_STATUSES_VL EPSV,
67: mfg_lookups ml,
68: fnd_user fu,
69: per_people_f ppf
70: WHERE EWP.PERMIT_ID =P_PERMIT_ID
71: AND EWP.ORGANIZATION_ID =P_ORGANIZATION_ID

Line 121: MFG_LOOKUPS ml

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
124: AND ESA.SOURCE_ID =P_PERMIT_ID
125: AND ESA.ORGANIZATION_ID =P_ORGANIZATION_ID

Line 146: MFG_LOOKUPS ML,

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
150: