[Home] [Help] [Dependency Information]
Object Name: | QPR_POLICY_MEAS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
|
|
|