5022: SET operation_seq_num = 1
5023: WHERE bill_sequence_id = to_sequence_id
5024: AND NOT EXISTS (
5025: SELECT NULL
5026: FROM bom_operation_sequences bos
5027: WHERE routing_sequence_id = to_rtg_seq_id
5028: AND bos.operation_seq_num = bic.operation_seq_num);
5029: END IF;
5030:
6053: fnd_global.conc_program_id,
6054: sysdate
6055: FROM bom_component_operations bco,
6056: bom_components_b bic,
6057: bom_operation_sequences bos,
6058: bom_copy_explosions_v bev
6059: WHERE bic.bill_sequence_id = to_sequence_id
6060: AND NVL (bic.eco_for_production, 2) = 2
6061: AND bco.component_sequence_id = bic.created_by
6148: fnd_global.conc_program_id,
6149: sysdate
6150: FROM bom_component_operations bco,
6151: bom_inventory_components bic,
6152: bom_operation_sequences bos
6153: WHERE bic.bill_sequence_id = to_sequence_id
6154: AND NVL (bic.eco_for_production, 2) = 2
6155: AND bco.component_sequence_id = bic.created_by
6156: AND bos.routing_sequence_id = to_rtg_seq_id
10748: SET operation_seq_num = 1
10749: WHERE bill_sequence_id = to_sequence_id
10750: AND NOT EXISTS (
10751: SELECT NULL
10752: FROM bom_operation_sequences bos
10753: WHERE routing_sequence_id = to_rtg_seq_id
10754: AND bos.operation_seq_num = bic.operation_seq_num);
10755: END IF;
10756:
11571: fnd_global.conc_program_id,
11572: sysdate
11573: FROM bom_component_operations bco,
11574: bom_components_b bic,
11575: bom_operation_sequences bos,
11576: bom_copy_explosions_v bev
11577: WHERE bic.bill_sequence_id = to_sequence_id
11578: AND NVL (bic.eco_for_production, 2) = 2
11579: AND bco.component_sequence_id = bic.created_by