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 237: from wip_operations wo, wip_operation_resources wor

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

Line 337: from wip_operations wo, wip_operation_resources wor

333: l_resource_id number;
334: begin
335: select wo.department_id, wor.resource_id
336: into l_dept_id, l_resource_id
337: from wip_operations wo, wip_operation_resources wor
338: where wo.wip_entity_id = p_wip_entity_id
339: and wo.operation_seq_num = p_operation_seq_num
340: and wo.organization_id = p_organization_id
341: and wo.repetitive_schedule_id is null

Line 443: from wip_operation_resources

439: l_count := 0;
440:
441: begin
442: select assigned_units into l_assigned_units
443: from wip_operation_resources
444: where wip_entity_id = p_wip_entity_id
445: and organization_id = p_organization_id
446: and operation_seq_num = p_operation_seq_num
447: and resource_seq_num = p_resource_seq_num;

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

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

Line 637: from bom_resources br, wip_operation_resources wor

633:
634: begin
635: select br.resource_type
636: into l_resource_type
637: from bom_resources br, wip_operation_resources wor
638: where wor.wip_entity_id = p_wip_entity_id
639: and wor.organization_id = p_organization_id
640: and wor.operation_seq_num = cur_row.operation_seq_num
641: and wor.resource_seq_num = cur_row.resource_seq_num

Line 869: from bom_resources br, wip_operation_resources wor

865:
866: begin
867: select br.resource_type
868: into l_resource_type
869: from bom_resources br, wip_operation_resources wor
870: where wor.wip_entity_id = p_wip_entity_id
871: and wor.organization_id = p_organization_id
872: and wor.operation_seq_num = cur_row.operation_seq_num
873: and wor.resource_seq_num = cur_row.resource_seq_num