Base Parameter

				
					select bpi.id      
      ,bpi.intl_id item
      ,bpi.bu_id
      ,bpi.sbu_id
      ,bpi.raw_val
      ,bpi.val
      ,bpi.is_set
      ,bpi.is_empty
      ,bpi.valid_from
      ,bpi.mdf_seq_nr
  from base_par            bp
      ,base_par_item_all_v bpi
 where bpi.base_par_id = bp.id
   and bp.intl_id  like '%stex%'
-- and  bpi.intl_id like 'insti%'
 order by base_par, bu_id nulls first, sbu_id nulls first, item
;