VIEW: QPR.QPR_DIMENSIONS#

Source

View Text - Preformatted

select PRICE_PLAN_DIM_ID PRICE_PLAN_DIM_ID, PRICE_PLAN_ID PRICE_PLAN_ID, DIM_CODE DIM_CODE, DIM_SEQ_NUM DIM_SEQ_NUM, DIM_PPA_CODE DIM_PPA_CODE, TEMPLATE_FLAG TEMPLATE_FLAG, SEEDED_FLAG SEEDED_FLAG, MAND_DIM_FLAG MAND_DIM_FLAG, INCLUDE_FLAG INCLUDE_FLAG, TIME_DIM_FLAG TIME_DIM_FLAG, LOB_ENABLED_FLAG LOB_ENABLED_FLAG, DIM_SHORT_NAME DIM_SHORT_NAME, DIM_LONG_NAME DIM_LONG_NAME, DIM_PLURAL_NAME DIM_PLURAL_NAME, NATIVE_KEY_FLAG NATIVE_KEY_FLAG, MEASURE_DIM_FLAG MEASURE_DIM_FLAG, SPARSE_FLAG SPARSE_FLAG, LOWEST_LVL LOWEST_LVL, LIST_PRICE_PLAN_FLAG LIST_PRICE_PLAN_FLAG, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_ID from "QPR"."QPR_DIMENSIONS"

View Text - HTML Formatted

SELECT PRICE_PLAN_DIM_ID PRICE_PLAN_DIM_ID
, PRICE_PLAN_ID PRICE_PLAN_ID
, DIM_CODE DIM_CODE
, DIM_SEQ_NUM DIM_SEQ_NUM
, DIM_PPA_CODE DIM_PPA_CODE
, TEMPLATE_FLAG TEMPLATE_FLAG
, SEEDED_FLAG SEEDED_FLAG
, MAND_DIM_FLAG MAND_DIM_FLAG
, INCLUDE_FLAG INCLUDE_FLAG
, TIME_DIM_FLAG TIME_DIM_FLAG
, LOB_ENABLED_FLAG LOB_ENABLED_FLAG
, DIM_SHORT_NAME DIM_SHORT_NAME
, DIM_LONG_NAME DIM_LONG_NAME
, DIM_PLURAL_NAME DIM_PLURAL_NAME
, NATIVE_KEY_FLAG NATIVE_KEY_FLAG
, MEASURE_DIM_FLAG MEASURE_DIM_FLAG
, SPARSE_FLAG SPARSE_FLAG
, LOWEST_LVL LOWEST_LVL
, LIST_PRICE_PLAN_FLAG LIST_PRICE_PLAN_FLAG
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_ID
FROM "QPR"."QPR_DIMENSIONS"