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_POLICY_MEAS_V

Object Details

Object Name:	QPR_POLICY_MEAS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INSTANCE_ID	NUMBER		Yes
POLICY_TYPE	VARCHAR2	(30)
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.
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.
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.
PASS_EXCEPTIONS	NUMBER
FAIL_EXCEPTIONS	NUMBER
NA_EXCEPTIONS	NUMBER
HI_SEVER_THRE	NUMBER
ME_SEVER_THRE	NUMBER
LO_SEVER_THRE	NUMBER
HI_POL_IMP_RANK	NUMBER
ME_POL_IMP_RANK	NUMBER
LO_POL_IMP_RANK	NUMBER
GROSS_REV_COMP	NUMBER
GROSS_REV_NON_COMP	NUMBER
REV_AT_LIS_PRICE	NUMBER
REV_AT_POL_LIMIT	NUMBER

Query Text

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


SELECT INSTANCE_ID
,      POLICY_TYPE
,      ORD_LEVEL_VALUE
,      TIME_LEVEL_VALUE
,      PRD_LEVEL_VALUE
,      GEO_LEVEL_VALUE
,      CUS_LEVEL_VALUE
,      ORG_LEVEL_VALUE
,      REP_LEVEL_VALUE
,      CHN_LEVEL_VALUE
,      VLB_LEVEL_VALUE
,      DSB_LEVEL_VALUE
,      USR1_LEVEL_VALUE
,      USR2_LEVEL_VALUE
,      USR3_LEVEL_VALUE
,      USR4_LEVEL_VALUE
,      USR5_LEVEL_VALUE
,      PASS_EXCEPTIONS
,      FAIL_EXCEPTIONS
,      NA_EXCEPTIONS
,      HI_SEVER_THRE
,      ME_SEVER_THRE
,      LO_SEVER_THRE
,      HI_POL_IMP_RANK
,      ME_POL_IMP_RANK
,      LO_POL_IMP_RANK
,      GROSS_REV_COMP
,      GROSS_REV_NON_COMP
,      REV_AT_LIS_PRICE
,      REV_AT_POL_LIMIT
FROM APPS.QPR_POLICY_MEAS_V;

Dependencies

[top of page]

APPS.QPR_POLICY_MEAS_V references the following:

APPS: QPR_MEASURE_DATA

APPS.QPR_POLICY_MEAS_V is referenced by following:

APPS: QPR_DSB_BAND_MEAS_ALL_V; QPR_DSB_BAND_MEAS_V; QPR_PRICE_SALES_MEAS_ALL_V; QPR_PRICE_SALES_MEAS_V; QPR_VLB_BAND_MEAS_ALL_V; QPR_VLB_BAND_MEAS_V