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

VIEW: APPS.QPR_HIERARCHIES_V

Object Details
Object Name: QPR_HIERARCHIES_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_hierarchies which contains the hierarchy details for each dimension of a price plan.


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.QPR_HIERARCHIES_V references the following:

SchemaAPPS
SynonymQPR_DIMENSIONS
SynonymQPR_HIERARCHIES
APPS.QPR_HIERARCHIES_V is referenced by following:

SchemaAPPS
Package BodyQPR_DEAL_PVT - show dependent code
Package BodyQPR_MAINTAIN_AW - show dependent code