APPS.WIP_PROD_INDICATORS dependencies on WIP_OPERATION_RESOURCES

Line 1993: wip_operation_resources wor,

1989: from wip_indicators_temp wit,
1990: bom_resources br,
1991: bom_departments bd,
1992: bom_department_resources bdr,
1993: wip_operation_resources wor,
1994: mtl_units_of_measure muom
1995: where
1996: wor.wip_entity_id = wit.wip_entity_id
1997: and wor.operation_seq_num = wit.operation_seq_num

Line 2696: wip_operation_resources wor

2692: wit.created_by,
2693: wit.program_application_id
2694: from wip_indicators_temp wit,
2695: bom_resources br,
2696: wip_operation_resources wor
2697: where wor.wip_entity_id = wit.wip_entity_id
2698: and wor.operation_seq_num = wit.operation_seq_num
2699: and wit.indicator_type = WIP_YIELD
2700: and wit.process_phase = WIP_DEPT_YIELD

Line 4689: from wip_operation_resources

4685: begin
4686:
4687: select trunc(min(start_date)), trunc(max(completion_date))
4688: into x_sim_date_from, x_sim_date_to
4689: from wip_operation_resources
4690: where trunc(start_date) between trunc(x_date_from)
4691: and trunc(x_date_to)
4692: or trunc(completion_date) between trunc(x_date_from)
4693: and trunc(x_date_to) ;

Line 4807: wip_operation_resources_v wor,

4803: mrp_net_resource_avail mnra,
4804: bom_departments bd,
4805: bom_department_resources bdr,
4806: wip_operations_v wo,
4807: wip_operation_resources_v wor,
4808: wip_discrete_jobs wdj
4809: where
4810: wdj.wip_entity_id = wor.wip_entity_id
4811: and wdj.organization_id = wor.organization_id