DBA Data[Home] [Help]

APPS.EAM_WORKORDERREP_PVT dependencies on WIP_OPERATION_RESOURCES

Line 186: WIP_OPERATION_RESOURCES WOR

182: FROM
183: BOM_RESOURCES BR,
184: CST_ACTIVITIES CA,
185: MFG_LOOKUPS LU,
186: WIP_OPERATION_RESOURCES WOR
187: WHERE BR.ORGANIZATION_ID = WOR.ORGANIZATION_ID
188: AND WOR.WIP_ENTITY_ID = p_wip_id
189: AND BR.RESOURCE_ID = WOR.RESOURCE_ID
190: AND CA.ACTIVITY_ID(+) = WOR.ACTIVITY_ID

Line 209: wip_operation_resources wor,

205: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wori.start_date), calendar_aware => FND_DATE.calendar_aware_alt) as "EMPSTARTDATE",
206: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wori.completion_date), calendar_aware => FND_DATE.calendar_aware_alt) as "EMPENDDATE",
207: bd.department_code as "EMPDEPTCODE")) Employees
208: FROM wip_op_resource_instances wori,
209: wip_operation_resources wor,
210: bom_resources br,
211: bom_resource_employees bre,
212: per_people_f ppf,
213: bom_departments bd