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]

TABLE: QPR.QPR_DIMENSION_VALUES

Object Details

Object Name:	QPR_DIMENSION_VALUES
Object Type:	TABLE
Owner:	QPR
Subobject Name:
Status:	VALID

This table contains the operational data store dimension data. This value becomes the source for building datamarts.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QPR_DIMENSION_VALUES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	DIM_VALUE_ID
QPR_DIMENSION_VALUES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INSTANCE_ID DIM_CODE HIERARCHY_CODE LEVEL1_VALUE
QPR_DIMENSION_VALUES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INSTANCE_ID DIM_CODE HIERARCHY_CODE CHECK_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
DIM_VALUE_ID	NUMBER		Yes	Unique Identifier for the dimension data.
INSTANCE_ID	NUMBER		Yes	Unique identifier of the application instance from which the data is sourced.
DIM_CODE	VARCHAR2	(30)		Identifies the dimension to which the data belongs.
HIERARCHY_CODE	VARCHAR2	(30)		Identifies the dimension hierarchy to which the data belongs.
LEVEL1_VALUE	VARCHAR2	(240)		Contains the level value of the dimension, populated based on the mapping defined in QPR_DIM_SOURCES.
LEVEL1_DESC	VARCHAR2	(240)		Contains the level value description of the dimension, populated based on the mapping defined in QPR_DIM_SOURCES.
LEVEL1_ATTRIBUTE1	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL1_ATTRIBUTE2	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL1_ATTRIBUTE3	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL1_ATTRIBUTE4	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL1_ATTRIBUTE5	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL2_VALUE	VARCHAR2	(240)		Contains the level value of the dimension, populated based on the mapping defined in QPR_DIM_SOURCES.
LEVEL2_DESC	VARCHAR2	(240)		Contains the level value description of the dimension, populated based on the mapping defined in QPR_DIM_SOURCES.
LEVEL2_ATTRIBUTE1	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL2_ATTRIBUTE2	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL2_ATTRIBUTE3	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL2_ATTRIBUTE4	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL2_ATTRIBUTE5	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL3_VALUE	VARCHAR2	(240)		Contains the level value of the dimension, populated based on the mapping defined in QPR_DIM_SOURCES.
LEVEL3_DESC	VARCHAR2	(240)		Contains the level value description of the dimension, populated based on the mapping defined in QPR_DIM_SOURCES.
LEVEL3_ATTRIBUTE1	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL3_ATTRIBUTE2	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL3_ATTRIBUTE3	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL3_ATTRIBUTE4	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL3_ATTRIBUTE5	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL4_VALUE	VARCHAR2	(240)		Contains the level value of the dimension, populated based on the mapping defined in QPR_DIM_SOURCES.
LEVEL4_DESC	VARCHAR2	(240)		Contains the level value description of the dimension, populated based on the mapping defined in QPR_DIM_SOURCES.
LEVEL4_ATTRIBUTE1	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL4_ATTRIBUTE2	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL4_ATTRIBUTE3	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL4_ATTRIBUTE4	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL4_ATTRIBUTE5	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL5_VALUE	VARCHAR2	(240)		Contains the level value of the dimension, populated based on the mapping defined in QPR_DIM_SOURCES.
LEVEL5_DESC	VARCHAR2	(240)		Contains the level value description of the dimension, populated based on the mapping defined in QPR_DIM_SOURCES.
LEVEL5_ATTRIBUTE1	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL5_ATTRIBUTE2	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL5_ATTRIBUTE3	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL5_ATTRIBUTE4	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL5_ATTRIBUTE5	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL6_VALUE	VARCHAR2	(240)		Contains the level value of the dimension, populated based on the mapping defined in QPR_DIM_SOURCES.
LEVEL6_DESC	VARCHAR2	(240)		Contains the level value description of the dimension, populated based on the mapping defined in QPR_DIM_SOURCES.
LEVEL6_ATTRIBUTE1	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL6_ATTRIBUTE2	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL6_ATTRIBUTE3	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL6_ATTRIBUTE4	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL6_ATTRIBUTE5	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL7_VALUE	VARCHAR2	(240)		Contains the level value of the dimension, populated based on the mapping defined in QPR_DIM_SOURCES.
LEVEL7_DESC	VARCHAR2	(240)		Contains the level value description of the dimension, populated based on the mapping defined in QPR_DIM_SOURCES.
LEVEL7_ATTRIBUTE1	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL7_ATTRIBUTE2	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL7_ATTRIBUTE3	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL7_ATTRIBUTE4	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL7_ATTRIBUTE5	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL8_VALUE	VARCHAR2	(240)		Contains the level value of the dimension, populated based on the mapping defined in QPR_DIM_SOURCES.
LEVEL8_DESC	VARCHAR2	(240)		Contains the level value description of the dimension, populated based on the mapping defined in QPR_DIM_SOURCES.
LEVEL8_ATTRIBUTE1	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL8_ATTRIBUTE2	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL8_ATTRIBUTE3	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL8_ATTRIBUTE4	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
LEVEL8_ATTRIBUTE5	VARCHAR2	(240)		Contains the level attribute value, populated based on the mapping defined in QPR_DIMENSION_SOURCES.
CHECK_DATE	DATE			Contains a time value related to the dimension entry. Example, the booked date for an order dimension. This can be used to control the pulling of dimension data to analytic workspace.
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 DIM_VALUE_ID
,      INSTANCE_ID
,      DIM_CODE
,      HIERARCHY_CODE
,      LEVEL1_VALUE
,      LEVEL1_DESC
,      LEVEL1_ATTRIBUTE1
,      LEVEL1_ATTRIBUTE2
,      LEVEL1_ATTRIBUTE3
,      LEVEL1_ATTRIBUTE4
,      LEVEL1_ATTRIBUTE5
,      LEVEL2_VALUE
,      LEVEL2_DESC
,      LEVEL2_ATTRIBUTE1
,      LEVEL2_ATTRIBUTE2
,      LEVEL2_ATTRIBUTE3
,      LEVEL2_ATTRIBUTE4
,      LEVEL2_ATTRIBUTE5
,      LEVEL3_VALUE
,      LEVEL3_DESC
,      LEVEL3_ATTRIBUTE1
,      LEVEL3_ATTRIBUTE2
,      LEVEL3_ATTRIBUTE3
,      LEVEL3_ATTRIBUTE4
,      LEVEL3_ATTRIBUTE5
,      LEVEL4_VALUE
,      LEVEL4_DESC
,      LEVEL4_ATTRIBUTE1
,      LEVEL4_ATTRIBUTE2
,      LEVEL4_ATTRIBUTE3
,      LEVEL4_ATTRIBUTE4
,      LEVEL4_ATTRIBUTE5
,      LEVEL5_VALUE
,      LEVEL5_DESC
,      LEVEL5_ATTRIBUTE1
,      LEVEL5_ATTRIBUTE2
,      LEVEL5_ATTRIBUTE3
,      LEVEL5_ATTRIBUTE4
,      LEVEL5_ATTRIBUTE5
,      LEVEL6_VALUE
,      LEVEL6_DESC
,      LEVEL6_ATTRIBUTE1
,      LEVEL6_ATTRIBUTE2
,      LEVEL6_ATTRIBUTE3
,      LEVEL6_ATTRIBUTE4
,      LEVEL6_ATTRIBUTE5
,      LEVEL7_VALUE
,      LEVEL7_DESC
,      LEVEL7_ATTRIBUTE1
,      LEVEL7_ATTRIBUTE2
,      LEVEL7_ATTRIBUTE3
,      LEVEL7_ATTRIBUTE4
,      LEVEL7_ATTRIBUTE5
,      LEVEL8_VALUE
,      LEVEL8_DESC
,      LEVEL8_ATTRIBUTE1
,      LEVEL8_ATTRIBUTE2
,      LEVEL8_ATTRIBUTE3
,      LEVEL8_ATTRIBUTE4
,      LEVEL8_ATTRIBUTE5
,      CHECK_DATE
,      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_DIMENSION_VALUES;

Dependencies

[top of page]

QPR.QPR_DIMENSION_VALUES does not reference any database object

QPR.QPR_DIMENSION_VALUES is referenced by following:

APPS: QPR_DIMENSION_VALUES