APPS.WIP_RES_INST_VALIDATIONS dependencies on WIP_OPERATION_RESOURCES

Line 62: from wip_operation_resources wor

58: (wip_job_details.wip_add, wip_job_details.wip_change)
59: and (wjdi.start_date > wjdi.completion_date
60: or exists
61: (select 1
62: from wip_operation_resources wor
63: where wor.wip_entity_id = p_wip_entity_id
64: and wor.organization_id = p_organization_id
65: and wor.operation_seq_num = p_operation_seq_num
66: and wor.resource_seq_num = p_resource_seq_num

Line 112: from wip_operation_resources wor

108: (wip_job_details.wip_add, wip_job_details.wip_change)
109: and (wjdi.start_date > wjdi.completion_date
110: or exists
111: (select 1
112: from wip_operation_resources wor
113: where wor.wip_entity_id = p_wip_entity_id
114: and wor.organization_id = p_organization_id
115: and wor.operation_seq_num = p_operation_seq_num
116: and wor.resource_seq_num = p_resource_seq_num

Line 239: from wip_operations wo, wip_operation_resources wor

235: begin
236:
237: select wo.department_id, wor.resource_id
238: into l_dept_id, l_resource_id
239: from wip_operations wo, wip_operation_resources wor
240: where wo.wip_entity_id = p_wip_entity_id
241: and wo.operation_seq_num = p_operation_seq_num
242: and wo.organization_id = p_organization_id
243: and wo.repetitive_schedule_id is null

Line 342: from wip_operations wo, wip_operation_resources wor

338: l_resource_id number;
339: begin
340: select wo.department_id, wor.resource_id
341: into l_dept_id, l_resource_id
342: from wip_operations wo, wip_operation_resources wor
343: where wo.wip_entity_id = p_wip_entity_id
344: and wo.operation_seq_num = p_operation_seq_num
345: and wo.organization_id = p_organization_id
346: and wo.repetitive_schedule_id is null

Line 448: from wip_operation_resources

444: l_count := 0;
445:
446: begin
447: select assigned_units into l_assigned_units
448: from wip_operation_resources
449: where wip_entity_id = p_wip_entity_id
450: and organization_id = p_organization_id
451: and operation_seq_num = p_operation_seq_num
452: and resource_seq_num = p_resource_seq_num;

Line 460: -- Get the assigned units value from wip_operation_resources. This

456: end;
457:
458: -- Fix bug 5472387.
459: -- The logic to check for assigned units is as follows.
460: -- Get the assigned units value from wip_operation_resources. This
461: -- will be the benchmark against which we check for the total resource
462: -- instance number.
463: -- Get currently added resource instances from wip_op_resource_instances table.
464: -- Get the number of resource instances being added in the current run and add it

Line 642: from bom_resources br, wip_operation_resources wor

638:
639: begin
640: select br.resource_type
641: into l_resource_type
642: from bom_resources br, wip_operation_resources wor
643: where wor.wip_entity_id = p_wip_entity_id
644: and wor.organization_id = p_organization_id
645: and wor.operation_seq_num = cur_row.operation_seq_num
646: and wor.resource_seq_num = cur_row.resource_seq_num

Line 874: from bom_resources br, wip_operation_resources wor

870:
871: begin
872: select br.resource_type
873: into l_resource_type
874: from bom_resources br, wip_operation_resources wor
875: where wor.wip_entity_id = p_wip_entity_id
876: and wor.organization_id = p_organization_id
877: and wor.operation_seq_num = cur_row.operation_seq_num
878: and wor.resource_seq_num = cur_row.resource_seq_num