[Home] [Help] [Dependency Information]
Object Name: | QPR_HIERARCHIES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is on table qpr_hierarchies which contains the hierarchy details for each dimension of a price plan.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HIERARCHY_ID | NUMBER | Yes | Unique Identifier of a hierarchy. | |
PRICE_PLAN_DIM_ID | NUMBER | Yes | Identifies the dimension for which the hierarchy is defined. | |
PRICE_PLAN_ID | NUMBER | Yes | Unique identifier of the price plan. | |
HIERARCHY_PPA_CODE | VARCHAR2 | (32) | Unique hierarchy identification code, which is same across plans for a given hierarchy. | |
DIM_CODE | VARCHAR2 | (60) | Yes | Price plan dimension code for which hierarchy is defined. |
DEFAULT_FLAG | VARCHAR2 | (1) | Identifies the default hierarchy for a dimension. Takes values 'Y'/'N'. | |
HIER_TYPE_CODE | VARCHAR2 | (10) | Indicates the type of Hierarchy. | |
HIER_SHORT_NAME | VARCHAR2 | (30) | Short name of the hierarchy. | |
HIER_LONG_NAME | VARCHAR2 | (240) | Long name of the hierarchy. | |
HIER_PLURAL_NAME | VARCHAR2 | (240) | Plural name of the hierarchy. | |
CALENDAR_CODE | VARCHAR2 | (30) | Calendar code used for the fiscal-time hierarchy. | |
HIER_DEFAULT_ORDER | VARCHAR2 | (50) | Not currently used |
Cut, paste (and edit) the following text to query this object:
SELECT HIERARCHY_ID
, PRICE_PLAN_DIM_ID
, PRICE_PLAN_ID
, HIERARCHY_PPA_CODE
, DIM_CODE
, DEFAULT_FLAG
, HIER_TYPE_CODE
, HIER_SHORT_NAME
, HIER_LONG_NAME
, HIER_PLURAL_NAME
, CALENDAR_CODE
, HIER_DEFAULT_ORDER
FROM APPS.QPR_HIERARCHIES_V;
|
|
|