[Home] [Help]
166: sql_stmt_num := 4;
167:
168: SELECT COUNT (*)
169: INTO total_substitute_components
170: FROM bom_substitute_components bsc,
171: bom_inventory_components bic
172: WHERE bic.bill_sequence_id = from_bill_seq_id
173: AND NVL (bic.eco_for_production, 2) = 2
174: AND bic.component_sequence_id = bsc.component_sequence_id
5722: sql_stmt_num := 50;
5723:
5724: IF specific_copy_flag = 'Y'
5725: THEN
5726: INSERT INTO bom_substitute_components
5727: (substitute_component_id,
5728: last_update_date,
5729: last_updated_by,
5730: creation_date,
5795: bsc.attribute13,
5796: bsc.attribute14,
5797: bsc.attribute15,
5798: bsc.enforce_int_requirements
5799: FROM bom_substitute_components bsc,
5800: bom_components_b bic,
5801: mtl_system_items msi,
5802: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
5803: bom_copy_explosions_v bev
5866: OR (specific_copy_flag = 'Y'
5867: AND copy_all_subcomps_flag = 'Y')
5868: )
5869: THEN
5870: INSERT INTO bom_substitute_components
5871: (substitute_component_id,
5872: last_update_date,
5873: last_updated_by,
5874: creation_date,
5939: bsc.attribute13,
5940: bsc.attribute14,
5941: bsc.attribute15,
5942: bsc.enforce_int_requirements
5943: FROM bom_substitute_components bsc,
5944: bom_inventory_components bic,
5945: mtl_system_items msi,
5946: MTL_SYSTEM_ITEMS AA -- Added corresponding to Bug 6510185
5947: WHERE bic.bill_sequence_id = to_sequence_id
11346:
11347:
11348: sql_stmt_num := 50;
11349:
11350: INSERT INTO bom_substitute_components
11351: (substitute_component_id,
11352: last_update_date,
11353: last_updated_by,
11354: creation_date,
11419: bsc.attribute13,
11420: bsc.attribute14,
11421: bsc.attribute15,
11422: bsc.enforce_int_requirements
11423: FROM bom_substitute_components bsc,
11424: bom_components_b bic,
11425: mtl_system_items msi,
11426: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
11427: bom_copy_explosions_v bev