[Home] [Help] [Dependency Information]
Object Name: | QPR_DIMENSIONS_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_dimensions which contains the dimension details of a price plan.
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_PPA_CODE | VARCHAR2 | (30) | Yes | Unique code to identify a dimension. The code is same across plans for a given dimension. |
DIM_SEQ_NUM | NUMBER | Yes | Indicates the order of dimension in a plan, based on its sparsity. | |
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 | |
TIME_DIM_FLAG | VARCHAR2 | (1) | Indicates whether the dimension is a time dimension or user dimension. Takes values 'Y'/'N'. | |
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'. |
Cut, paste (and edit) the following text to query this object:
SELECT PRICE_PLAN_DIM_ID
, PRICE_PLAN_ID
, DIM_CODE
, DIM_PPA_CODE
, DIM_SEQ_NUM
, DIM_SHORT_NAME
, DIM_LONG_NAME
, DIM_PLURAL_NAME
, TIME_DIM_FLAG
, NATIVE_KEY_FLAG
, MEASURE_DIM_FLAG
, SPARSE_FLAG
FROM APPS.QPR_DIMENSIONS_V;
APPS.QPR_DIMENSIONS_V is not referenced by any database object
|
|
|