[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
5631: sql_stmt_num := 50;
5632:
5633: IF specific_copy_flag = 'Y'
5634: THEN
5635: INSERT INTO bom_substitute_components
5636: (substitute_component_id,
5637: last_update_date,
5638: last_updated_by,
5639: creation_date,
5704: bsc.attribute13,
5705: bsc.attribute14,
5706: bsc.attribute15,
5707: bsc.enforce_int_requirements
5708: FROM bom_substitute_components bsc,
5709: bom_components_b bic,
5710: mtl_system_items msi,
5711: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
5712: bom_copy_explosions_v bev
5774: OR (specific_copy_flag = 'Y'
5775: AND copy_all_subcomps_flag = 'Y')
5776: )
5777: THEN
5778: INSERT INTO bom_substitute_components
5779: (substitute_component_id,
5780: last_update_date,
5781: last_updated_by,
5782: creation_date,
5847: bsc.attribute13,
5848: bsc.attribute14,
5849: bsc.attribute15,
5850: bsc.enforce_int_requirements
5851: FROM bom_substitute_components bsc,
5852: bom_inventory_components bic,
5853: mtl_system_items msi,
5854: MTL_SYSTEM_ITEMS AA -- Added corresponding to Bug 6510185
5855: WHERE bic.bill_sequence_id = to_sequence_id
11193:
11194:
11195: sql_stmt_num := 50;
11196:
11197: INSERT INTO bom_substitute_components
11198: (substitute_component_id,
11199: last_update_date,
11200: last_updated_by,
11201: creation_date,
11266: bsc.attribute13,
11267: bsc.attribute14,
11268: bsc.attribute15,
11269: bsc.enforce_int_requirements
11270: FROM bom_substitute_components bsc,
11271: bom_components_b bic,
11272: mtl_system_items msi,
11273: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
11274: bom_copy_explosions_v bev