APPS.WIP_WS_UTIL dependencies on WIP_OPERATION_RESOURCES

Line 900: from wip_operations wo, wip_operation_resources wor

896: l_completion_date := null;
897: else
898: select nvl(wor.department_id, wo.department_id)
899: into l_department_id
900: from wip_operations wo, wip_operation_resources wor
901: where wo.wip_entity_id = p_wip_entity_id
902: and wo.organization_id = p_organization_id
903: and wo.operation_seq_num = p_op_seq_num
904: and wor.wip_entity_id = wo.wip_entity_id

Line 921: from wip_operation_resources wor,

917: wip_constants.yes, nvl(bdr.utilization, 1), 1),
918: decode(wp.include_resource_efficiency,
919: wip_constants.yes, nvl(bdr.efficiency, 1), 1)
920: into l_units, l_utilization, l_efficiency
921: from wip_operation_resources wor,
922: bom_department_resources bdr,
923: wip_parameters wp
924: where wor.organization_id = p_organization_id
925: and wor.wip_entity_id = p_wip_entity_id

Line 1049: from wip_operation_resources wor

1045: l_completion_date := null;
1046:
1047: select count(wor.resource_seq_num)
1048: into l_not_projected_count
1049: from wip_operation_resources wor
1050: where wor.wip_entity_id = p_wip_entity_id
1051: and wor.operation_seq_num = p_op_seq_num
1052: and wor.organization_id = p_organization_id
1053: and wor.projected_completion_date is null

Line 1060: from wip_operation_resources wor

1056: if( l_not_projected_count = 0 ) then
1057:
1058: select max(wor.projected_completion_date)
1059: into l_completion_date
1060: from wip_operation_resources wor
1061: where wor.wip_entity_id = p_wip_entity_id
1062: and wor.operation_seq_num = p_op_seq_num
1063: and wor.organization_id = p_organization_id
1064: and wor.projected_completion_date is not null