VIEW: QPR.QPR_HIER_LEVELS#

Source

View Text - Preformatted

select HIERARCHY_LEVEL_ID HIERARCHY_LEVEL_ID, HIERARCHY_ID HIERARCHY_ID, PRICE_PLAN_ID PRICE_PLAN_ID, LEVEL_SEQ_NUM LEVEL_SEQ_NUM, LEVEL_PPA_CODE LEVEL_PPA_CODE, TEMPLATE_FLAG TEMPLATE_FLAG, SEEDED_FLAG SEEDED_FLAG, INCLUDE_FLAG INCLUDE_FLAG, LVL_SHORT_NAME LVL_SHORT_NAME, LVL_LONG_NAME LVL_LONG_NAME, LVL_PLURAL_NAME LVL_PLURAL_NAME, MAPPING_VIEW_NAME MAPPING_VIEW_NAME, MAP_COLUMN MAP_COLUMN, USER_MAPPING_VIEW_NAME USER_MAPPING_VIEW_NAME, USER_MAP_COLUMN USER_MAP_COLUMN, 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_HIER_LEVELS"

View Text - HTML Formatted

SELECT HIERARCHY_LEVEL_ID HIERARCHY_LEVEL_ID
, HIERARCHY_ID HIERARCHY_ID
, PRICE_PLAN_ID PRICE_PLAN_ID
, LEVEL_SEQ_NUM LEVEL_SEQ_NUM
, LEVEL_PPA_CODE LEVEL_PPA_CODE
, TEMPLATE_FLAG TEMPLATE_FLAG
, SEEDED_FLAG SEEDED_FLAG
, INCLUDE_FLAG INCLUDE_FLAG
, LVL_SHORT_NAME LVL_SHORT_NAME
, LVL_LONG_NAME LVL_LONG_NAME
, LVL_PLURAL_NAME LVL_PLURAL_NAME
, MAPPING_VIEW_NAME MAPPING_VIEW_NAME
, MAP_COLUMN MAP_COLUMN
, USER_MAPPING_VIEW_NAME USER_MAPPING_VIEW_NAME
, USER_MAP_COLUMN USER_MAP_COLUMN
, 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_HIER_LEVELS"