DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.QPR_HIER_LEVELS_V

Object Details
Object Name: QPR_HIER_LEVELS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view is on table qpr_hier_levels which contains the level details of each dimension hierarchy of price plan


[View Source]

Columns
Name Datatype Length Mandatory Comments
HIERARCHY_LEVEL_ID NUMBER
Yes Unique identifier for the hierarchy level of a plan.
HIERARCHY_ID NUMBER
Yes Identifies the hierarchy to which the level is associated.
LEVEL_ID NUMBER
Yes Unique Identifier for a level in all hierarchies of a dimension.
PRICE_PLAN_ID NUMBER
Yes Unique identifier of the price plan.
LEVEL_SEQ_NUM NUMBER
Yes Indicates the position of a level in a hierarchy.
LEVEL_PPA_CODE VARCHAR2 (32)
Unique Code for a Level, which remains same across price plans
LVL_SHORT_NAME VARCHAR2 (30)
Short name of the level.
LVL_LONG_NAME VARCHAR2 (240)
Long name of the level.
LVL_PLURAL_NAME VARCHAR2 (240)
Plural name of the level.
MAPPING_VIEW_NAME VARCHAR2 (30)
Identifies the seeded source table or view name from which the level values are obtained.
MAP_COLUMN VARCHAR2 (30)
Identifies the seeded source table or view column name from which the level values are obtained.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT HIERARCHY_LEVEL_ID
,      HIERARCHY_ID
,      LEVEL_ID
,      PRICE_PLAN_ID
,      LEVEL_SEQ_NUM
,      LEVEL_PPA_CODE
,      LVL_SHORT_NAME
,      LVL_LONG_NAME
,      LVL_PLURAL_NAME
,      MAPPING_VIEW_NAME
,      MAP_COLUMN
FROM APPS.QPR_HIER_LEVELS_V;

Dependencies

[top of page]

APPS.QPR_HIER_LEVELS_V references the following:

SchemaAPPS
SynonymQPR_HIER_LEVELS

APPS.QPR_HIER_LEVELS_V is not referenced by any database object