VIEW: APPS.QPR_MEAS_AGGRS_V

Source

View Text - Preformatted

SELECT a.meas_agg_id, a.cube_dim_id, a.measure_id, a.price_plan_id, b.cube_id, b.dim_code, c.dim_seq_num, a.override_flag, a.aggmap_name, a.aggmap_cache_store, a.aggmap_cache_na, a.dim_opcode, a.set_level_flag, a.dim_expression_type, a.dim_expression, a.weighted_measure_flag, a.weight_measure_name, a.wnafill, a.divide_by_zero_flag, a.decimal_overflow_flag, a.naskip_flag FROM qpr_meas_aggrs a, qpr_cube_dims_v b, qpr_dimensions c WHERE a.cube_dim_id=b.cube_dim_id and b.price_plan_dim_id = c.price_plan_dim_id

View Text - HTML Formatted

SELECT A.MEAS_AGG_ID
, A.CUBE_DIM_ID
, A.MEASURE_ID
, A.PRICE_PLAN_ID
, B.CUBE_ID
, B.DIM_CODE
, C.DIM_SEQ_NUM
, A.OVERRIDE_FLAG
, A.AGGMAP_NAME
, A.AGGMAP_CACHE_STORE
, A.AGGMAP_CACHE_NA
, A.DIM_OPCODE
, A.SET_LEVEL_FLAG
, A.DIM_EXPRESSION_TYPE
, A.DIM_EXPRESSION
, A.WEIGHTED_MEASURE_FLAG
, A.WEIGHT_MEASURE_NAME
, A.WNAFILL
, A.DIVIDE_BY_ZERO_FLAG
, A.DECIMAL_OVERFLOW_FLAG
, A.NASKIP_FLAG
FROM QPR_MEAS_AGGRS A
, QPR_CUBE_DIMS_V B
, QPR_DIMENSIONS C
WHERE A.CUBE_DIM_ID=B.CUBE_DIM_ID
AND B.PRICE_PLAN_DIM_ID = C.PRICE_PLAN_DIM_ID