[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'
5877:
5878: /* Copy the component operations (One To Many changes) */
5879: IF specific_copy_flag = 'Y'
5880: THEN
5881: INSERT INTO bom_component_operations
5882: (comp_operation_seq_id,
5883: operation_seq_num,
5884: operation_sequence_id,
5885: last_update_date,
5914: program_application_id,
5915: program_id,
5916: program_update_date
5917: )
5918: SELECT bom_component_operations_s.NEXTVAL,
5919: bco.operation_seq_num,
5920: bos.operation_sequence_id,
5921: SYSDATE,
5922: user_id,
5955: fnd_global.conc_request_id,
5956: NULL,
5957: fnd_global.conc_program_id,
5958: sysdate
5959: FROM bom_component_operations bco,
5960: bom_components_b bic,
5961: bom_operation_sequences bos,
5962: bom_copy_explosions_v bev
5963: WHERE bic.bill_sequence_id = to_sequence_id
5972: OR (specific_copy_flag = 'Y'
5973: AND copy_all_comps_flag = 'Y')
5974: )
5975: THEN
5976: INSERT INTO bom_component_operations
5977: (comp_operation_seq_id,
5978: operation_seq_num,
5979: operation_sequence_id,
5980: last_update_date,
6009: program_application_id,
6010: program_id,
6011: program_update_date
6012: )
6013: SELECT bom_component_operations_s.NEXTVAL,
6014: bco.operation_seq_num,
6015: bos.operation_sequence_id,
6016: SYSDATE,
6017: user_id,
6050: fnd_global.conc_request_id,
6051: NULL,
6052: fnd_global.conc_program_id,
6053: sysdate
6054: FROM bom_component_operations bco,
6055: bom_inventory_components bic,
6056: bom_operation_sequences bos
6057: WHERE bic.bill_sequence_id = to_sequence_id
6058: AND NVL (bic.eco_for_production, 2) = 2
11338:
11339: sql_stmt_num := 51;
11340:
11341: /* Copy the component operations (One To Many changes) */
11342: INSERT INTO bom_component_operations
11343: (comp_operation_seq_id,
11344: operation_seq_num,
11345: operation_sequence_id,
11346: last_update_date,
11375: program_application_id,
11376: program_id,
11377: program_update_date
11378: )
11379: SELECT bom_component_operations_s.NEXTVAL,
11380: bco.operation_seq_num,
11381: bos.operation_sequence_id,
11382: SYSDATE,
11383: user_id,
11416: fnd_global.conc_request_id,
11417: NULL,
11418: fnd_global.conc_program_id,
11419: sysdate
11420: FROM bom_component_operations bco,
11421: bom_components_b bic,
11422: bom_operation_sequences bos,
11423: bom_copy_explosions_v bev
11424: WHERE bic.bill_sequence_id = to_sequence_id