111: dvl.aw_name,
112: dvl.dimension_id,
113: (select count(*) from zpb_hierarchies where dimension_id = dvl.dimension_id and hier_type<>'NULL') hier_cnt,
114: dvl.epb_id
115: from zpb_dimensions_vl dvl
116: where bus_area_id = p_bus_area_id and
117: is_data_dim='YES'
118: order by is_owner_dim desc,
119: name;
495: dvl.aw_name,
496: dvl.dimension_id,
497: (select count(*) from zpb_hierarchies where dimension_id = dvl.dimension_id and hier_type<>'NULL') hier_cnt,
498: dvl.epb_id
499: from zpb_dimensions_vl dvl
500: where bus_area_id = p_bus_area_id and
501: is_data_dim='YES'
502: order by is_owner_dim desc,
503: name;