246: ,v_unassigned_category_name level9_name
247: from dual,
248: mth_dim_hierarchy mdh,
249: (select distinct hierarchy_id
250: from mth_dim_level_lookup) mdll
251: where mdh.dimension_name= 'ITEM' and
252: mdll.hierarchy_id (+) = mdh.hierarchy_id);
253:
254: -- Balance the item denorm table
1194: ,v_unassigned_category_name level9_name
1195: from dual,
1196: mth_dim_hierarchy mdh,
1197: (select distinct hierarchy_id
1198: from mth_dim_level_lookup) mdll
1199: where mdh.dimension_name= 'ITEM' and
1200: mdll.hierarchy_id (+) = mdh.hierarchy_id);
1201:
1202: -- Balance the item denorm table