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_PLAN_MEASURES

Object Details

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

This intermediary table holds data during the analytic workspace/datamart maintenance.
This table holds all the scope values per dimension defined as the LOB during price plan definition.
These values are then used to filter the data loaded to the datamart. The table entries are cleared after the maintenance of the datamart.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QPR_PLAN_MEASURES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PRICE_PLAN_DATA_ID
QPR_PLAN_MEASURES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRICE_PLAN_MEAS_GRP_ID PRICE_PLAN_MEAS_GRP_NAME
QPR_PLAN_MEASURES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRICE_PLAN_MEAS_GRP_ID RUN_NUMBER DATE_ATTRIBUTE ATTRIBUTE_3

Columns

Name	Datatype	Length	Mandatory	Comments
PRICE_PLAN_DATA_ID	NUMBER	(15)	Yes	Unique Identifier for the price plan dimension filter data
PRICE_PLAN_ID	NUMBER		Yes	Unique Identifier of the price plan to which the data applies
PRICE_PLAN_MEAS_GRP_ID	NUMBER		Yes	Unique Identifier to identify the dimension to which the set of values apply.
PRICE_PLAN_MEAS_GRP_NAME	VARCHAR2	(240)		Group Name to identify the dimension to which the set of values apply.
DATE_ATTRIBUTE	DATE			Column to store any date attribute of the dimension data.
RUN_NUMBER	NUMBER			Number to identify the maintenance run to which the data belongs.
ATTRIBUTE_1	VARCHAR2	(240)		Stores the unique identifier for the member of the leaf level value of a dimension hierarchy. This is the filter value based on which the dimension and measure data are filtered.
ATTRIBUTE_2	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_3	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_4	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_5	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_6	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_7	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_8	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_9	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_10	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_11	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_12	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_13	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_14	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_15	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_16	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_17	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_18	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_19	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_20	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_21	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_22	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_23	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_24	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_25	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_26	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_27	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_28	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_29	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_30	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_31	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_32	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_33	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_34	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_35	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_36	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_37	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_38	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_39	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_40	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_41	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_42	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_43	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_44	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_45	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_46	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_47	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_48	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_49	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_50	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_51	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_52	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_53	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_54	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_55	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_56	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_57	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_58	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_59	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
ATTRIBUTE_60	VARCHAR2	(240)		Column to store any attribute of the dimension member to be used in data filtering.
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_DATA_ID
,      PRICE_PLAN_ID
,      PRICE_PLAN_MEAS_GRP_ID
,      PRICE_PLAN_MEAS_GRP_NAME
,      DATE_ATTRIBUTE
,      RUN_NUMBER
,      ATTRIBUTE_1
,      ATTRIBUTE_2
,      ATTRIBUTE_3
,      ATTRIBUTE_4
,      ATTRIBUTE_5
,      ATTRIBUTE_6
,      ATTRIBUTE_7
,      ATTRIBUTE_8
,      ATTRIBUTE_9
,      ATTRIBUTE_10
,      ATTRIBUTE_11
,      ATTRIBUTE_12
,      ATTRIBUTE_13
,      ATTRIBUTE_14
,      ATTRIBUTE_15
,      ATTRIBUTE_16
,      ATTRIBUTE_17
,      ATTRIBUTE_18
,      ATTRIBUTE_19
,      ATTRIBUTE_20
,      ATTRIBUTE_21
,      ATTRIBUTE_22
,      ATTRIBUTE_23
,      ATTRIBUTE_24
,      ATTRIBUTE_25
,      ATTRIBUTE_26
,      ATTRIBUTE_27
,      ATTRIBUTE_28
,      ATTRIBUTE_29
,      ATTRIBUTE_30
,      ATTRIBUTE_31
,      ATTRIBUTE_32
,      ATTRIBUTE_33
,      ATTRIBUTE_34
,      ATTRIBUTE_35
,      ATTRIBUTE_36
,      ATTRIBUTE_37
,      ATTRIBUTE_38
,      ATTRIBUTE_39
,      ATTRIBUTE_40
,      ATTRIBUTE_41
,      ATTRIBUTE_42
,      ATTRIBUTE_43
,      ATTRIBUTE_44
,      ATTRIBUTE_45
,      ATTRIBUTE_46
,      ATTRIBUTE_47
,      ATTRIBUTE_48
,      ATTRIBUTE_49
,      ATTRIBUTE_50
,      ATTRIBUTE_51
,      ATTRIBUTE_52
,      ATTRIBUTE_53
,      ATTRIBUTE_54
,      ATTRIBUTE_55
,      ATTRIBUTE_56
,      ATTRIBUTE_57
,      ATTRIBUTE_58
,      ATTRIBUTE_59
,      ATTRIBUTE_60
,      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_PLAN_MEASURES;

Dependencies

[top of page]

QPR.QPR_PLAN_MEASURES does not reference any database object

QPR.QPR_PLAN_MEASURES is referenced by following:

APPS: QPR_PLAN_MEASURES