eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.QPR_DIMENSIONS_V

Object Details

Object Name:	QPR_DIMENSIONS_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_dimensions which contains the dimension details of a price plan.

[View Source]

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_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'.

Query Text

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;

Dependencies

[top of page]

APPS.QPR_DIMENSIONS_V references the following:

APPS: QPR_DIMENSIONS

APPS.QPR_DIMENSIONS_V is not referenced by any database object