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

TABLE: QPR.QPR_DIMENSIONS

Object Details
Object Name: QPR_DIMENSIONS
Object Type: TABLE
Owner: QPR
Subobject Name:
Status: VALID


This table contains the dimension details of a price plan.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
QPR_DIMENSIONS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRICE_PLAN_DIM_ID
QPR_DIMENSIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRICE_PLAN_ID
ColumnDIM_PPA_CODE
Columns
Name Datatype Length Mandatory Comments
PRICE_PLAN_DIM_ID NUMBER
Yes Unique Identifier of the dimension
PRICE_PLAN_ID NUMBER
Yes Reference plan identifier for the dimension.
DIM_CODE VARCHAR2 (60) Yes Code to identify the dimension of a plan.
DIM_SEQ_NUM NUMBER
Yes Indicates the order of dimension in a plan, based on its sparsity.
DIM_PPA_CODE VARCHAR2 (30) Yes Unique code to identify a dimension. The code is same across plans for a given dimension.
TEMPLATE_FLAG VARCHAR2 (1)
Indicates whether the row is part of template or not. Takes values 'Y'/'N'.
SEEDED_FLAG VARCHAR2 (1)
Indicates if the value is seeded data or not.Takes values 'Y'/'N'.
MAND_DIM_FLAG VARCHAR2 (1)
Indicates whether a dimension is mandatory in a plan. Takes values 'Y'/'N'.
INCLUDE_FLAG VARCHAR2 (1)
Indicates if a dimension is included in the plan template or not. Takes values 'Y'/'N'.
TIME_DIM_FLAG VARCHAR2 (1)
Indicates whether the dimension is a time dimension or user dimension. Takes values 'Y'/'N'.
LOB_ENABLED_FLAG VARCHAR2 (1)
Indicates if the dimension is a candidate to be included in the line of business filters. Takes values 'Y'/'N'. Applicable only for plan template rows.
DIM_SHORT_NAME VARCHAR2 (30)
Short name of the dimension
DIM_LONG_NAME VARCHAR2 (240)
Long name of the dimension
DIM_PLURAL_NAME VARCHAR2 (240)
Plural name of the dimension
NATIVE_KEY_FLAG VARCHAR2 (1)
Indicates whether the unique key of the dimension data source will be used to ensure the uniqueness of dimension members. Takes values 'Y'/'N'. Surrogate key will be generated if value is 'N'.
MEASURE_DIM_FLAG VARCHAR2 (1)
Indicates whether the dimension contains measures as its members. Takes values 'Y'/'N'
SPARSE_FLAG VARCHAR2 (1)
Indicates whether the diimension is sparse or dense. Takes values 'Y'/'N'.
LOWEST_LVL VARCHAR2 (30)
Indicates the lowest level in the dimension hierarchy.
LIST_PRICE_PLAN_FLAG VARCHAR2 (1)
Indicates if the dimensions are included in the list price plan or not. Takes values 'Y'/'N'.
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
PROGRAM_ID NUMBER

Identifies the concurrent program
PROGRAM_LOGIN_ID NUMBER

Identifies the Oracle Applicaitons Consurrent Program Login ID
PROGRAM_APPLICATION_ID NUMBER

Identifies the Oracle Application that spawned the consurrent program
REQUEST_ID NUMBER

Identifies the concurrent request instance that spawned the concurrent program
Query Text

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


SELECT PRICE_PLAN_DIM_ID
,      PRICE_PLAN_ID
,      DIM_CODE
,      DIM_SEQ_NUM
,      DIM_PPA_CODE
,      TEMPLATE_FLAG
,      SEEDED_FLAG
,      MAND_DIM_FLAG
,      INCLUDE_FLAG
,      TIME_DIM_FLAG
,      LOB_ENABLED_FLAG
,      DIM_SHORT_NAME
,      DIM_LONG_NAME
,      DIM_PLURAL_NAME
,      NATIVE_KEY_FLAG
,      MEASURE_DIM_FLAG
,      SPARSE_FLAG
,      LOWEST_LVL
,      LIST_PRICE_PLAN_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM QPR.QPR_DIMENSIONS;

Dependencies

[top of page]

QPR.QPR_DIMENSIONS does not reference any database object

QPR.QPR_DIMENSIONS is referenced by following:

SchemaAPPS
SynonymQPR_DIMENSIONS