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_SALES_MEAS_V1

Object Details

Object Name:	QPR_PRICE_SALES_MEAS_V1
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 Sales Data and Price Sales 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	(0)		Identifier of the Adjustment dimension to which the measure belongs.
TIM_SR_LEVEL_VALUE_PK	VARCHAR2	(0)		Not Currently Used
END_DATE	DATE			Identifier of the Time dimension to which the measure belongs.
ORDERED_QUANTITY	NUMBER			Quantity ordered
GROSS_REVENUE	NUMBER			Revenue derived as selling price multiplied by ordered quantity
GROSS_REVENUE_FREIGHT	NUMBER			Revenue including freight charges
LIST_PRICE	NUMBER			Price List price
SELLING_PRICE	NUMBER			Invoice Price
ADJUSTED_PRICE	NUMBER			Pocket Price derived as Selling Price minus total off invoice adjustment.
NO_OF_ORDER_LINE	NUMBER			Takes a value of 1 for each line. This when rolled up in the datamart, will give the total lines in a specific hierarchy.
DISC_PERC	NUMBER			Total discount 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.
QTY_UOM	VARCHAR2	(40)		Unit of measure for the quantity measures
POCKET_PRICE	NUMBER			Pocket Price derived as selling price minus off invoice adjustments
TOTAL_OFFADJ_REV	NUMBER			Total Off invoice adjustment amount
TOTAL_COST	NUMBER			Total Cost incured.
MARGIN_PERC	NUMBER			Pocket margin as precent of list price
MODEL_QTY	NUMBER			Takes the value of ordered quantity, if the item of the given line is of type 'MODEL' or 'KIT'. Otherwise, it takes a value of 0

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
,      TIM_SR_LEVEL_VALUE_PK
,      END_DATE
,      ORDERED_QUANTITY
,      GROSS_REVENUE
,      GROSS_REVENUE_FREIGHT
,      LIST_PRICE
,      SELLING_PRICE
,      ADJUSTED_PRICE
,      NO_OF_ORDER_LINE
,      DISC_PERC
,      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
,      QTY_UOM
,      POCKET_PRICE
,      TOTAL_OFFADJ_REV
,      TOTAL_COST
,      MARGIN_PERC
,      MODEL_QTY
FROM APPS.QPR_PRICE_SALES_MEAS_V1;

Dependencies

[top of page]

APPS.QPR_PRICE_SALES_MEAS_V1 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_SALES_MEAS_V1 is not referenced by any database object