DBA Data[Home] [Help]

APPS.EAM_WORKORDERREP_PVT dependencies on WIP_OPERATION_RESOURCES

Line 177: WIP_OPERATION_RESOURCES WOR

173: FROM
174: BOM_RESOURCES BR,
175: CST_ACTIVITIES CA,
176: MFG_LOOKUPS LU,
177: WIP_OPERATION_RESOURCES WOR
178: WHERE BR.ORGANIZATION_ID = WOR.ORGANIZATION_ID
179: AND WOR.WIP_ENTITY_ID = p_wip_id
180: AND BR.RESOURCE_ID = WOR.RESOURCE_ID
181: AND CA.ACTIVITY_ID(+) = WOR.ACTIVITY_ID

Line 200: wip_operation_resources wor,

196: fnd_date.date_to_displayDT(Convert_to_client_time(bre.effective_start_date)) as "EMPSTARTDATE",
197: fnd_date.date_to_displayDT(Convert_to_client_time(bre.effective_end_date)) as "EMPENDDATE",
198: bd.department_code as "EMPDEPTCODE")) Employees
199: FROM wip_op_resource_instances wori,
200: wip_operation_resources wor,
201: bom_resources br,
202: bom_resource_employees bre,
203: per_people_f ppf,
204: bom_departments bd