160: AND inventory_item_id = p_inventory_item_id_old;
161:
162: select substitute_item_quantity
163: into X_substitute_item_quantity
164: from bom_substitute_components
165: where substitute_component_id = p_inventory_item_id_new
166: and component_sequence_id = X_comp_seq_id
167: and acd_type is null ;
168: