[Home] [Help]
2307: SELECT acd_type,
2308: operation_sequence_id,
2309: resource_seq_num,
2310: resource_id
2311: FROM bom_operation_resources
2312: WHERE operation_sequence_id= chng_operation_rec.operation_sequence_id;
2313:
2314: chng_resource_rec chng_resource_rows%rowtype;
2315:
5427: IF chng_operation_rec.acd_type = acd_change
5428: -- Copy attached resources in the old operation to the new operation,
5429: -- except the disabled resource.
5430: THEN
5431: INSERT INTO bom_operation_resources
5432: (
5433: operation_sequence_id
5434: , resource_seq_num
5435: , resource_id
5517: , principle_flag
5518: , change_notice
5519: , acd_type
5520: , original_system_reference
5521: FROM bom_operation_resources a
5522: WHERE operation_sequence_id =
5523: chng_operation_rec.old_operation_sequence_id
5524: --* Commented following line for Bug 3520302
5525: --* AND nvl(acd_type, acd_add) = acd_add
5526: --* Added for Bug 3520302
5527: AND nvl(acd_type, acd_add) in (acd_add,acd_change)
5528: AND resource_seq_num NOT IN (
5529: SELECT b.resource_seq_num
5530: FROM bom_operation_resources b
5531: WHERE b.operation_sequence_id =
5532: chng_operation_rec.operation_sequence_id);
5533:
5534: /* Fix for bug 4606950 - In the above select query, modified the sub-query in the where clause.
5535: Replaced the resource_id with resource_seq_num. The old sub-query was commented as below*/
5536: /*
5537: AND resource_id NOT IN (
5538: SELECT b.resource_id
5539: FROM bom_operation_resources b
5540: WHERE b.operation_sequence_id =
5541: chng_operation_rec.operation_sequence_id
5542: and b.resource_seq_num = a.resource_seq_num);
5543: */
5802: -- Check whether all resources in same resource group have been
5803: -- disabled, if so, delete the sub resources too.
5804: /* Commented the below delete st for bug 4577459 . This delete st deletes all rows from the table
5805: that have been created through the routing form irrespective of which routing they belong to.
5806: As while implementing the ECO we do not delete the bom_operation_resources data the sub resources
5807: associated need not be deleted */
5808: /* DELETE
5809: FROM bom_sub_operation_resources sr
5810: WHERE NOT EXISTS (
5808: /* DELETE
5809: FROM bom_sub_operation_resources sr
5810: WHERE NOT EXISTS (
5811: SELECT 1
5812: FROM bom_operation_resources bor
5813: WHERE bor.operation_sequence_id = sr.operation_sequence_id
5814: AND bor.substitute_group_num = sr.substitute_group_num
5815: AND bor.acd_type <> 3
5816: );*/
9039: */
9040: -- Delete all the resources assigned to the operations whose
9041: -- eco_for_production = 1.
9042: /*
9043: DELETE FROM bom_operation_resources
9044: WHERE operation_sequence_id IN
9045: ( SELECT operation_sequence_id
9046: FROM bom_operation_sequences
9047: WHERE revised_item_sequence_id = p_revised_item_sequence_id