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_PRICE_ADJ_MEAS_V

Object Details

Object Name:	QPR_PRICE_ADJ_MEAS_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.

Mapping view for Price Adjustment Cube in the datamart.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INSTANCE	NUMBER		Yes	Unique identifier of the application instance from which the data is sourced.
PSG_SR_LEVEL_VALUE_PK	VARCHAR2	(240)		Identifier of the Pricing Segment dimension to which the measure belongs.
ORD_SR_LEVEL_VALUE_PK	VARCHAR2	(240)		Identifier of the Order dimension to which the measure belongs.
PRD_SR_LEVEL_VALUE_PK	VARCHAR2	(240)		Identifier of the Product dimension to which the measure belongs.
GEO_SR_LEVEL_VALUE_PK	VARCHAR2	(240)		Identifier of the Geography dimension to which the measure belongs.
CUS_SR_LEVEL_VALUE_PK	VARCHAR2	(240)		Identifier of the Customer dimension to which the measure belongs.
ORG_SR_LEVEL_VALUE_PK	VARCHAR2	(240)		Identifier of the Organization dimension to which the measure belongs.
REP_SR_LEVEL_VALUE_PK	VARCHAR2	(240)		Identifier of the Sales Representative dimension to which the measure belongs.
CHN_SR_LEVEL_VALUE_PK	VARCHAR2	(240)		Identifier of the Sales Channel dimension to which the measure belongs.
ADJ_SR_LEVEL_VALUE_PK	VARCHAR2	(240)		Identifier of the Adjustment dimension to which the measure belongs.
VLB_SR_LEVEL_VALUE_PK	VARCHAR2	(0)		Not Currently Used
DSB_SR_LEVEL_VALUE_PK	VARCHAR2	(0)		Not Currently Used
TIM_SR_LEVEL_VALUE_PK	VARCHAR2	(0)		Not Currently Used
END_DATE	DATE			Identifier of the Time dimension to which the measure belongs.
UD1_SR_LEVEL_VALUE_PK	VARCHAR2	(0)		Identifier of the User-Defined dimension to which the measure belongs.
UD2_SR_LEVEL_VALUE_PK	VARCHAR2	(0)		Identifier of the User-Defined dimension to which the measure belongs.
UD3_SR_LEVEL_VALUE_PK	VARCHAR2	(0)		Identifier of the User-Defined dimension to which the measure belongs.
UD4_SR_LEVEL_VALUE_PK	VARCHAR2	(0)		Identifier of the User-Defined dimension to which the measure belongs.
UD5_SR_LEVEL_VALUE_PK	VARCHAR2	(0)		Identifier of the User-Defined dimension to which the measure belongs.
ON_INV_ADJ_AMT_REV	NUMBER			Total on-invoice adjustment amount
ON_INV_ADJ_AMT_PREC	NUMBER			On invoice adjustment as percent of list price
USER_MEASURE1	NUMBER			User defined measure value, if any.
USER_MEASURE2	NUMBER			User defined measure value, if any.
USER_MEASURE3	NUMBER			User defined measure value, if any.
USER_MEASURE4	NUMBER			User defined measure value, if any.
USER_MEASURE5	NUMBER			User defined measure value, if any.
USER_MEASURE6	NUMBER			User defined measure value, if any.
USER_MEASURE7	NUMBER			User defined measure value, if any.
USER_MEASURE8	NUMBER			User defined measure value, if any.
USER_MEASURE9	NUMBER			User defined measure value, if any.
USER_MEASURE10	NUMBER			User defined measure value, if any.
USER_MEASURE11	VARCHAR2	(240)		User defined measure value, if any.
USER_MEASURE12	VARCHAR2	(240)		User defined measure value, if any.
USER_MEASURE13	VARCHAR2	(240)		User defined measure value, if any.
USER_MEASURE14	VARCHAR2	(240)		User defined measure value, if any.
USER_MEASURE15	VARCHAR2	(240)		User defined measure value, if any.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INSTANCE
,      PSG_SR_LEVEL_VALUE_PK
,      ORD_SR_LEVEL_VALUE_PK
,      PRD_SR_LEVEL_VALUE_PK
,      GEO_SR_LEVEL_VALUE_PK
,      CUS_SR_LEVEL_VALUE_PK
,      ORG_SR_LEVEL_VALUE_PK
,      REP_SR_LEVEL_VALUE_PK
,      CHN_SR_LEVEL_VALUE_PK
,      ADJ_SR_LEVEL_VALUE_PK
,      VLB_SR_LEVEL_VALUE_PK
,      DSB_SR_LEVEL_VALUE_PK
,      TIM_SR_LEVEL_VALUE_PK
,      END_DATE
,      UD1_SR_LEVEL_VALUE_PK
,      UD2_SR_LEVEL_VALUE_PK
,      UD3_SR_LEVEL_VALUE_PK
,      UD4_SR_LEVEL_VALUE_PK
,      UD5_SR_LEVEL_VALUE_PK
,      ON_INV_ADJ_AMT_REV
,      ON_INV_ADJ_AMT_PREC
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      USER_MEASURE6
,      USER_MEASURE7
,      USER_MEASURE8
,      USER_MEASURE9
,      USER_MEASURE10
,      USER_MEASURE11
,      USER_MEASURE12
,      USER_MEASURE13
,      USER_MEASURE14
,      USER_MEASURE15
FROM APPS.QPR_PRICE_ADJ_MEAS_V;

Dependencies

[top of page]

APPS.QPR_PRICE_ADJ_MEAS_V references the following:

APPS: QPR_MAINTAIN_AW - show dependent code; QPR_MEASURE_DATA; QPR_PLAN_MEASURES; QPR_SR_UTIL - show dependent code

APPS.QPR_PRICE_ADJ_MEAS_V is not referenced by any database object