DBA Data[Home] [Help]

APPS.EAM_WORKORDERREP_PVT dependencies on BOM_RESOURCES

Line 174: BOM_RESOURCES BR,

170: CA.ACTIVITY as "RESACTIVITY",
171: fnd_date.date_to_displayDT(Convert_to_client_time(WOR.START_DATE)) as "RESSTARTDATE",
172: fnd_date.date_to_displayDT(Convert_to_client_time(WOR.COMPLETION_DATE)) as "RESCOMPLETIONDATE")) Resources
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

Line 201: bom_resources br,

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
205: WHERE wor.wip_entity_id = wori.wip_entity_id and