DBA Data[Home] [Help]

VIEW: APPS.QPR_HIER_LEVELS_V

Source

View Text - Preformatted

SELECT HIERARCHY_LEVEL_ID, HIERARCHY_ID, HIERARCHY_LEVEL_ID, PRICE_PLAN_ID, LEVEL_SEQ_NUM, LEVEL_PPA_CODE||'_L', LVL_SHORT_NAME, LVL_LONG_NAME, LVL_PLURAL_NAME, nvl(USER_MAPPING_VIEW_NAME, MAPPING_VIEW_NAME) , nvl(USER_MAP_COLUMN, MAP_COLUMN) FROM QPR_HIER_LEVELS
View Text - HTML Formatted

SELECT HIERARCHY_LEVEL_ID
, HIERARCHY_ID
, HIERARCHY_LEVEL_ID
, PRICE_PLAN_ID
, LEVEL_SEQ_NUM
, LEVEL_PPA_CODE||'_L'
, LVL_SHORT_NAME
, LVL_LONG_NAME
, LVL_PLURAL_NAME
, NVL(USER_MAPPING_VIEW_NAME
, MAPPING_VIEW_NAME)
, NVL(USER_MAP_COLUMN
, MAP_COLUMN)
FROM QPR_HIER_LEVELS