APPS.ZPB_DEBUG dependencies on ZPB_DIMENSIONS

Line 115: from zpb_dimensions_vl dvl

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;

Line 163: zpb_dimensions dims

159: attrs.label,
160: dims.aw_name,
161: attrs.pers_cwm_name
162: from zpb_attributes_vl attrs,
163: zpb_dimensions dims
164: where attrs.dimension_id = l_dim_id and
165: dims.dimension_id = attrs.range_dim_id;
166:
167: v_attr c_attributes%ROWTYPE;

Line 219: zpb_dimensions dims

215:
216: select dims.epb_id,
217: dims.aw_name
218: from zpb_cube_dims cds,
219: zpb_dimensions dims
220: where cds.dimension_id = dims.dimension_id
221: and cds.cube_id = l_cube_id;
222:
223: v_cube_dim c_cube_dims%ROWTYPE;

Line 499: from zpb_dimensions_vl dvl

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;

Line 547: zpb_dimensions dims

543: attrs.label,
544: dims.aw_name,
545: attrs.pers_cwm_name
546: from zpb_attributes_vl attrs,
547: zpb_dimensions dims
548: where attrs.dimension_id = l_dim_id and
549: dims.dimension_id = attrs.range_dim_id;
550:
551: v_attr c_attributes%ROWTYPE;

Line 603: zpb_dimensions dims

599:
600: select dims.epb_id,
601: dims.aw_name
602: from zpb_cube_dims cds,
603: zpb_dimensions dims
604: where cds.dimension_id = dims.dimension_id
605: and cds.cube_id = l_cube_id;
606:
607: v_cube_dim c_cube_dims%ROWTYPE;