base par
f
,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 bu_id = 9
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
;
