APPS.WIP_WS_UTIL dependencies on WIP_OPERATION_RESOURCES

Line 859: from wip_operations wo, wip_operation_resources wor

855: l_completion_date := null;
856: else
857: select nvl(wor.department_id, wo.department_id)
858: into l_department_id
859: from wip_operations wo, wip_operation_resources wor
860: where wo.wip_entity_id = p_wip_entity_id
861: and wo.organization_id = p_organization_id
862: and wo.operation_seq_num = p_op_seq_num
863: and wor.wip_entity_id = wo.wip_entity_id

Line 880: from wip_operation_resources wor,

876: wip_constants.yes, nvl(bdr.utilization, 1), 1),
877: decode(wp.include_resource_efficiency,
878: wip_constants.yes, nvl(bdr.efficiency, 1), 1)
879: into l_units, l_utilization, l_efficiency
880: from wip_operation_resources wor,
881: bom_department_resources bdr,
882: wip_parameters wp
883: where wor.organization_id = p_organization_id
884: and wor.wip_entity_id = p_wip_entity_id

Line 1008: from wip_operation_resources wor

1004: l_completion_date := null;
1005:
1006: select count(wor.resource_seq_num)
1007: into l_not_projected_count
1008: from wip_operation_resources wor
1009: where wor.wip_entity_id = p_wip_entity_id
1010: and wor.operation_seq_num = p_op_seq_num
1011: and wor.organization_id = p_organization_id
1012: and wor.projected_completion_date is null

Line 1019: from wip_operation_resources wor

1015: if( l_not_projected_count = 0 ) then
1016:
1017: select max(wor.projected_completion_date)
1018: into l_completion_date
1019: from wip_operation_resources wor
1020: where wor.wip_entity_id = p_wip_entity_id
1021: and wor.operation_seq_num = p_op_seq_num
1022: and wor.organization_id = p_organization_id
1023: and wor.projected_completion_date is not null