[Home] [Help]
5283:
5284: -- Copy attached substitute resources in the old operation to the new operation,
5285: -- except the disabled substitute resource.
5286:
5287: INSERT INTO bom_sub_operation_resources
5288: (
5289: operation_sequence_id
5290: , substitute_group_num
5291: , resource_id
5373: , schedule_seq_num
5374: , change_notice
5375: , acd_type
5376: , original_system_reference
5377: FROM bom_sub_operation_resources
5378: WHERE operation_sequence_id =
5379: chng_operation_rec.old_operation_sequence_id
5380: AND nvl(acd_type, acd_add) = acd_add
5381: AND resource_id NOT IN (
5379: chng_operation_rec.old_operation_sequence_id
5380: AND nvl(acd_type, acd_add) = acd_add
5381: AND resource_id NOT IN (
5382: SELECT resource_id
5383: FROM bom_sub_operation_resources
5384: WHERE operation_sequence_id =
5385: chng_operation_rec.operation_sequence_id );
5386:
5387: -- Copy attachment of the Operation Sequences
5541: that have been created through the routing form irrespective of which routing they belong to.
5542: As while implementing the ECO we do not delete the bom_operation_resources data the sub resources
5543: associated need not be deleted */
5544: /* DELETE
5545: FROM bom_sub_operation_resources sr
5546: WHERE NOT EXISTS (
5547: SELECT 1
5548: FROM bom_operation_resources bor
5549: WHERE bor.operation_sequence_id = sr.operation_sequence_id
8684:
8685: IF p_bill_sequence_id <> -1 THEN
8686: -- Delete all the substitute resources assigned to the operations
8687: -- whose eco_for_production = 1.
8688: /* DELETE FROM bom_sub_operation_resources
8689: WHERE operation_sequence_id IN
8690: ( SELECT operation_sequence_id
8691: FROM bom_operation_sequences
8692: WHERE revised_item_sequence_id = p_revised_item_sequence_id