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_MEASURE_DATA

Object Details

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

This table contains the operational data store measure data. This data becomes the source for building data marts.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QPR_MEASURE_DATA_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	MEASURE_VALUE_ID
QPR_MEASURE_DATA_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INSTANCE_ID MEASURE_TYPE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
MEASURE_VALUE_ID	NUMBER		Yes	Unique Identifier for the measure data.
INSTANCE_ID	NUMBER		Yes	Unique identifier of the application instance from which the data is sourced.
MEASURE_TYPE_CODE	VARCHAR2	(30)		Indicates the functional group to which the data belongs.
PSG_LEVEL_VALUE	VARCHAR2	(240)		Contains the fact data corresponding to lowest level of the pricing segment dimension.
ORD_LEVEL_VALUE	VARCHAR2	(240)		Contains the fact data corresponding to lowest level of the order dimension.
TIME_LEVEL_VALUE	DATE			Contains the fact data corresponding to lowest level of the time dimension.
PRD_LEVEL_VALUE	VARCHAR2	(240)		Contains the fact data corresponding to lowest level of the product dimension.
GEO_LEVEL_VALUE	VARCHAR2	(240)		Contains the fact data corresponding to lowest level of the geography dimension.
CUS_LEVEL_VALUE	VARCHAR2	(240)		Contains the fact data corresponding to lowest level of the customer dimension.
ORG_LEVEL_VALUE	VARCHAR2	(240)		Contains the fact data corresponding to lowest level of the organization dimension.
REP_LEVEL_VALUE	VARCHAR2	(240)		Contains the fact data corresponding to lowest level of the sales representative dimension.
CHN_LEVEL_VALUE	VARCHAR2	(240)		Contains the fact data corresponding to lowest level of the sales channel dimension.
ADJ_LEVEL_VALUE	VARCHAR2	(240)		Contains the fact data corresponding to lowest level of the adjustment dimension.
VLB_LEVEL_VALUE	VARCHAR2	(240)		Contains the fact data corresponding to lowest level of the volume band dimension.
DSB_LEVEL_VALUE	VARCHAR2	(240)		Contains the fact data corresponding to lowest level of the discount band dimension.
COS_LEVEL_VALUE	VARCHAR2	(240)		Contains the fact data corresponding to lowest level of the cost dimension.
OFFADJ_LEVEL_VALUE	VARCHAR2	(240)		Contains the fact data corresponding to lowest level of the Off invoice adjustment dimension.
MGB_LEVEL_VALUE	VARCHAR2	(240)		Contains the fact data corresponding to lowest level of margin band dimension.
USR1_LEVEL_VALUE	VARCHAR2	(240)		Contains the fact data corresponding to lowest level of user-defined dimension.
USR2_LEVEL_VALUE	VARCHAR2	(240)		Contains the fact data corresponding to lowest level of user-defined dimension.
USR3_LEVEL_VALUE	VARCHAR2	(240)		Contains the fact data corresponding to lowest level of user-defined dimension.
USR4_LEVEL_VALUE	VARCHAR2	(240)		Contains the fact data corresponding to lowest level of user-defined dimension.
USR5_LEVEL_VALUE	VARCHAR2	(240)		Contains the fact data corresponding to lowest level of user-defined dimension.
MEASURE1_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE2_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE3_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE4_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE5_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE6_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE7_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE8_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE9_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE10_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE11_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE12_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE13_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE14_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE15_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE16_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE17_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE18_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE19_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE20_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE21_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE22_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE23_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE24_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE25_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE26_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE27_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE28_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE29_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE30_NUMBER	NUMBER			Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE1_CHAR	VARCHAR2	(240)		Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE2_CHAR	VARCHAR2	(240)		Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE3_CHAR	VARCHAR2	(240)		Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE4_CHAR	VARCHAR2	(240)		Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE5_CHAR	VARCHAR2	(240)		Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE6_CHAR	VARCHAR2	(240)		Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE7_CHAR	VARCHAR2	(240)		Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE8_CHAR	VARCHAR2	(240)		Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE9_CHAR	VARCHAR2	(240)		Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE10_CHAR	VARCHAR2	(240)		Contains the measure value, populated based on the mapping defined in QPR_MEASURE_SOURCES.
MEASURE_UOM	VARCHAR2	(40)		Contains the base unit of measure for the quantity related measures.
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 MEASURE_VALUE_ID
,      INSTANCE_ID
,      MEASURE_TYPE_CODE
,      PSG_LEVEL_VALUE
,      ORD_LEVEL_VALUE
,      TIME_LEVEL_VALUE
,      PRD_LEVEL_VALUE
,      GEO_LEVEL_VALUE
,      CUS_LEVEL_VALUE
,      ORG_LEVEL_VALUE
,      REP_LEVEL_VALUE
,      CHN_LEVEL_VALUE
,      ADJ_LEVEL_VALUE
,      VLB_LEVEL_VALUE
,      DSB_LEVEL_VALUE
,      COS_LEVEL_VALUE
,      OFFADJ_LEVEL_VALUE
,      MGB_LEVEL_VALUE
,      USR1_LEVEL_VALUE
,      USR2_LEVEL_VALUE
,      USR3_LEVEL_VALUE
,      USR4_LEVEL_VALUE
,      USR5_LEVEL_VALUE
,      MEASURE1_NUMBER
,      MEASURE2_NUMBER
,      MEASURE3_NUMBER
,      MEASURE4_NUMBER
,      MEASURE5_NUMBER
,      MEASURE6_NUMBER
,      MEASURE7_NUMBER
,      MEASURE8_NUMBER
,      MEASURE9_NUMBER
,      MEASURE10_NUMBER
,      MEASURE11_NUMBER
,      MEASURE12_NUMBER
,      MEASURE13_NUMBER
,      MEASURE14_NUMBER
,      MEASURE15_NUMBER
,      MEASURE16_NUMBER
,      MEASURE17_NUMBER
,      MEASURE18_NUMBER
,      MEASURE19_NUMBER
,      MEASURE20_NUMBER
,      MEASURE21_NUMBER
,      MEASURE22_NUMBER
,      MEASURE23_NUMBER
,      MEASURE24_NUMBER
,      MEASURE25_NUMBER
,      MEASURE26_NUMBER
,      MEASURE27_NUMBER
,      MEASURE28_NUMBER
,      MEASURE29_NUMBER
,      MEASURE30_NUMBER
,      MEASURE1_CHAR
,      MEASURE2_CHAR
,      MEASURE3_CHAR
,      MEASURE4_CHAR
,      MEASURE5_CHAR
,      MEASURE6_CHAR
,      MEASURE7_CHAR
,      MEASURE8_CHAR
,      MEASURE9_CHAR
,      MEASURE10_CHAR
,      MEASURE_UOM
,      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_MEASURE_DATA;

Dependencies

[top of page]

QPR.QPR_MEASURE_DATA does not reference any database object

QPR.QPR_MEASURE_DATA is referenced by following:

APPS: QPR_MEASURE_DATA