APPS.WIP_UPDATE_SETUP_RESOURCES dependencies on WIP_OP_RESOURCE_INSTANCES

Line 15: delete from wip_op_resource_instances

11:
12: BEGIN
13:
14: -- delete old setup resource instances
15: delete from wip_op_resource_instances
16: where wip_entity_id = p_wip_entity_id
17: and organization_id = p_organization_id
18: and operation_seq_num = p_operation_seq_num
19: and resource_seq_num in (

Line 78: from wip_op_resource_instances wori

74: p_resource_seq_num NUMBER) is
75: select wori.instance_id,
76: wori.serial_number,
77: wori.completion_date
78: from wip_op_resource_instances wori
79: where wori.wip_entity_id = p_wip_entity_id
80: and wori.organization_id = p_organization_id
81: and wori.operation_seq_num = p_operation_seq_num
82: and wori.resource_seq_num = p_resource_seq_num;

Line 133: from wip_op_resource_instances wori1,

129: wori1.serial_number serial_number,
130: wor1.setup_id,
131: nvl(wo.quantity_running,0)+nvl(wo.quantity_completed,0) processed_qty,
132: wor1.start_date start_date
133: from wip_op_resource_instances wori1,
134: wip_operation_resources wor1,
135: wip_operations wo
136: where wor1.wip_entity_id = wori1.wip_entity_id
137: and wor1.operation_seq_num = wori1.operation_seq_num

Line 354: insert into wip_op_resource_instances

350: and wor.organization_id = p_organization_id
351: and wor.operation_seq_num = l_next_operation_seq_num
352: and wor.resource_seq_num = l_next_resource_seq_num;
353:
354: insert into wip_op_resource_instances
355: (ORGANIZATION_ID,
356: WIP_ENTITY_ID,
357: OPERATION_SEQ_NUM,
358: RESOURCE_SEQ_NUM,

Line 467: insert into wip_op_resource_instances

463: if (l_num_of_instances < setup_res_rec.assigned_units) then
464:
465: l_num_of_instances := l_num_of_instances + 1;
466:
467: insert into wip_op_resource_instances
468: (ORGANIZATION_ID,
469: WIP_ENTITY_ID,
470: OPERATION_SEQ_NUM,
471: RESOURCE_SEQ_NUM,

Line 585: delete from wip_op_resource_instances wori

581: p_organization_id IN NUMBER) IS
582: BEGIN
583:
584: -- delete old setup resource instances
585: delete from wip_op_resource_instances wori
586: where wori.wip_entity_id = p_wip_entity_id
587: and wori.organization_id = p_organization_id
588: and wori.resource_seq_num in (
589: select resource_seq_num