VIEW: APPS.QPR_SET_LEVELS_V

Source

View Text - Preformatted

SELECT a.set_dim_level_id, a.cube_dim_id, a.price_plan_id, a.measure_id, b.cube_code, c.dim_code, a.aggmap_name, a.level_short_name, a.dim_expression_type FROM qpr_set_levels a, qpr_cubes b, qpr_cube_dims_v c WHERE a.cube_dim_id = c.cube_dim_id and c.cube_id = b.cube_id

View Text - HTML Formatted

SELECT A.SET_DIM_LEVEL_ID
, A.CUBE_DIM_ID
, A.PRICE_PLAN_ID
, A.MEASURE_ID
, B.CUBE_CODE
, C.DIM_CODE
, A.AGGMAP_NAME
, A.LEVEL_SHORT_NAME
, A.DIM_EXPRESSION_TYPE
FROM QPR_SET_LEVELS A
, QPR_CUBES B
, QPR_CUBE_DIMS_V C
WHERE A.CUBE_DIM_ID = C.CUBE_DIM_ID
AND C.CUBE_ID = B.CUBE_ID