VIEW: APPS.QPR_CUBE_DIMS_V

Source

View Text - Preformatted

SELECT cd.CUBE_DIM_ID, cd.CUBE_ID, cd.PRICE_PLAN_ID, cd.PRICE_PLAN_DIM_ID, cd.DIM_SEQ_NUM, d.DIM_CODE, nvl(cd.USER_MAPPING_VIEW_NAME,cd.MAPPING_VIEW_NAME), nvl(cd.USER_MAP_COLUMN,cd.MAP_COLUMN), d.lowest_lvl, cd.AGGMAP_NAME, cd.SET_LEVEL_FLAG, cd.DIM_EXPRESSION_TYPE, cd.DIM_EXPRESSION, cd.DIM_OPCODE, cd.WEIGHTED_MEASURE_FLAG, cd.WEIGHT_MEASURE_NAME, cd.WNAFILL, cd.DIVIDE_BY_ZERO_FLAG, cd.DECIMAL_OVERFLOW_FLAG, cd.NASKIP_FLAG FROM QPR_CUBE_DIMS cd, QPR_DIMENSIONS d WHERE cd.price_plan_id = d.price_plan_id and cd.price_plan_dim_id = d.price_plan_dim_id

View Text - HTML Formatted

SELECT CD.CUBE_DIM_ID
, CD.CUBE_ID
, CD.PRICE_PLAN_ID
, CD.PRICE_PLAN_DIM_ID
, CD.DIM_SEQ_NUM
, D.DIM_CODE
, NVL(CD.USER_MAPPING_VIEW_NAME
, CD.MAPPING_VIEW_NAME)
, NVL(CD.USER_MAP_COLUMN
, CD.MAP_COLUMN)
, D.LOWEST_LVL
, CD.AGGMAP_NAME
, CD.SET_LEVEL_FLAG
, CD.DIM_EXPRESSION_TYPE
, CD.DIM_EXPRESSION
, CD.DIM_OPCODE
, CD.WEIGHTED_MEASURE_FLAG
, CD.WEIGHT_MEASURE_NAME
, CD.WNAFILL
, CD.DIVIDE_BY_ZERO_FLAG
, CD.DECIMAL_OVERFLOW_FLAG
, CD.NASKIP_FLAG
FROM QPR_CUBE_DIMS CD
, QPR_DIMENSIONS D
WHERE CD.PRICE_PLAN_ID = D.PRICE_PLAN_ID
AND CD.PRICE_PLAN_DIM_ID = D.PRICE_PLAN_DIM_ID