[Home] [Help]
239:
240: SELECT COUNT (*)
241: INTO total_component_operations
242: FROM bom_inventory_components bic,
243: bom_component_operations bco
244: WHERE bic.bill_sequence_id = from_bill_seq_id
245: AND NVL (bic.eco_for_production, 2) = 2
246: AND bic.component_sequence_id = bco.component_sequence_id
247: AND ((x_unit_assembly = 'N'
5973:
5974: /* Copy the component operations (One To Many changes) */
5975: IF specific_copy_flag = 'Y'
5976: THEN
5977: INSERT INTO bom_component_operations
5978: (comp_operation_seq_id,
5979: operation_seq_num,
5980: operation_sequence_id,
5981: last_update_date,
6010: program_application_id,
6011: program_id,
6012: program_update_date
6013: )
6014: SELECT bom_component_operations_s.NEXTVAL,
6015: bco.operation_seq_num,
6016: bos.operation_sequence_id,
6017: SYSDATE,
6018: user_id,
6051: fnd_global.conc_request_id,
6052: NULL,
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
6068: OR (specific_copy_flag = 'Y'
6069: AND copy_all_comps_flag = 'Y')
6070: )
6071: THEN
6072: INSERT INTO bom_component_operations
6073: (comp_operation_seq_id,
6074: operation_seq_num,
6075: operation_sequence_id,
6076: last_update_date,
6105: program_application_id,
6106: program_id,
6107: program_update_date
6108: )
6109: SELECT bom_component_operations_s.NEXTVAL,
6110: bco.operation_seq_num,
6111: bos.operation_sequence_id,
6112: SYSDATE,
6113: user_id,
6146: fnd_global.conc_request_id,
6147: NULL,
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
11491:
11492: sql_stmt_num := 51;
11493:
11494: /* Copy the component operations (One To Many changes) */
11495: INSERT INTO bom_component_operations
11496: (comp_operation_seq_id,
11497: operation_seq_num,
11498: operation_sequence_id,
11499: last_update_date,
11528: program_application_id,
11529: program_id,
11530: program_update_date
11531: )
11532: SELECT bom_component_operations_s.NEXTVAL,
11533: bco.operation_seq_num,
11534: bos.operation_sequence_id,
11535: SYSDATE,
11536: user_id,
11569: fnd_global.conc_request_id,
11570: NULL,
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