[Home] [Help] [Dependency Information]
Object Name: | QPR_PRICE_SALES_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 | NUMBER | Yes | ||
PSG_SR_LEVEL_VALUE_PK | VARCHAR2 | (240) | ||
ORD_SR_LEVEL_VALUE_PK | VARCHAR2 | (240) | ||
PRD_SR_LEVEL_VALUE_PK | VARCHAR2 | (240) | ||
GEO_SR_LEVEL_VALUE_PK | VARCHAR2 | (240) | ||
CUS_SR_LEVEL_VALUE_PK | VARCHAR2 | (240) | ||
ORG_SR_LEVEL_VALUE_PK | VARCHAR2 | (240) | ||
REP_SR_LEVEL_VALUE_PK | VARCHAR2 | (240) | ||
CHN_SR_LEVEL_VALUE_PK | VARCHAR2 | (240) | ||
ADJ_SR_LEVEL_VALUE_PK | VARCHAR2 | (0) | ||
VLB_SR_LEVEL_VALUE_PK | VARCHAR2 | (0) | ||
DSB_SR_LEVEL_VALUE_PK | VARCHAR2 | (0) | ||
TIM_SR_LEVEL_VALUE_PK | VARCHAR2 | (0) | ||
END_DATE | DATE | |||
UD1_SR_LEVEL_VALUE_PK | VARCHAR2 | (0) | ||
UD2_SR_LEVEL_VALUE_PK | VARCHAR2 | (0) | ||
UD3_SR_LEVEL_VALUE_PK | VARCHAR2 | (0) | ||
UD4_SR_LEVEL_VALUE_PK | VARCHAR2 | (0) | ||
UD5_SR_LEVEL_VALUE_PK | VARCHAR2 | (0) | ||
ORDERED_QUANTITY | NUMBER | |||
GROSS_REVENUE | NUMBER | |||
GROSS_REVENUE_FREIGHT | NUMBER | |||
LIST_PRICE | NUMBER | |||
SELLING_PRICE | NUMBER | |||
ADJUSTED_PRICE | NUMBER | |||
NO_OF_ORDER_LINE | NUMBER | |||
DISC_PERC | NUMBER | |||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
USER_MEASURE6 | NUMBER | |||
USER_MEASURE7 | NUMBER | |||
USER_MEASURE8 | NUMBER | |||
USER_MEASURE9 | NUMBER | |||
USER_MEASURE10 | NUMBER | |||
USER_MEASURE11 | VARCHAR2 | (240) | ||
USER_MEASURE12 | VARCHAR2 | (240) | ||
USER_MEASURE13 | VARCHAR2 | (240) | ||
USER_MEASURE14 | VARCHAR2 | (240) | ||
USER_MEASURE15 | VARCHAR2 | (240) | ||
CEIL_PASS_EXCEPTIONS | NUMBER | |||
CEIL_FAIL_EXCEPTIONS | NUMBER | |||
CEIL_NA_EXCEPTIONS | NUMBER | |||
CEIL_HI_SEVER_THRE | NUMBER | |||
CEIL_ME_SEVER_THRE | NUMBER | |||
CEIL_LO_SEVER_THRE | NUMBER | |||
CEIL_HI_POL_IMP_RANK | NUMBER | |||
CEIL_ME_POL_IMP_RANK | NUMBER | |||
CEIL_LO_POL_IMP_RANK | NUMBER | |||
CEIL_GROSS_REV_COMP | NUMBER | |||
CEIL_GROSS_REV_NON_COMP | NUMBER | |||
CEIL_REV_AT_LIS_PRICE | NUMBER | |||
CEIL_REV_AT_POL_LIMIT | NUMBER | |||
FU_PASS_EXCEPTIONS | NUMBER | |||
FU_FAIL_EXCEPTIONS | NUMBER | |||
FU_NA_EXCEPTIONS | NUMBER | |||
FU_HI_SEVER_THRE | NUMBER | |||
FU_ME_SEVER_THRE | NUMBER | |||
FU_LO_SEVER_THRE | NUMBER | |||
FU_HI_POL_IMP_RANK | NUMBER | |||
FU_ME_POL_IMP_RANK | NUMBER | |||
FU_LO_POL_IMP_RANK | NUMBER | |||
FU_GROSS_REV_COMP | NUMBER | |||
FU_GROSS_REV_NON_COMP | NUMBER | |||
FU_REV_AT_LIS_PRICE | NUMBER | |||
FU_REV_AT_POL_LIMIT | NUMBER | |||
TARGET_PASS_EXCEPTIONS | NUMBER | |||
TARGET_FAIL_EXCEPTIONS | NUMBER | |||
TARGET_NA_EXCEPTIONS | NUMBER | |||
TARGET_HI_SEVER_THRE | NUMBER | |||
TARGET_ME_SEVER_THRE | NUMBER | |||
TARGET_LO_SEVER_THRE | NUMBER | |||
TARGET_HI_POL_IMP_RANK | NUMBER | |||
TARGET_ME_POL_IMP_RANK | NUMBER | |||
TARGET_LO_POL_IMP_RANK | NUMBER | |||
TARGET_GROSS_REV_COMP | NUMBER | |||
TARGET_GROSS_REV_NON_COMP | NUMBER | |||
TARGET_REV_AT_LIS_PRICE | NUMBER | |||
TARGET_REV_AT_POL_LIMIT | NUMBER | |||
REG_PASS_EXCEPTIONS | NUMBER | |||
REG_FAIL_EXCEPTIONS | NUMBER | |||
REG_NA_EXCEPTIONS | NUMBER | |||
REG_HI_SEVER_THRE | NUMBER | |||
REG_ME_SEVER_THRE | NUMBER | |||
REG_LO_SEVER_THRE | NUMBER | |||
REG_HI_POL_IMP_RANK | NUMBER | |||
REG_ME_POL_IMP_RANK | NUMBER | |||
REG_LO_POL_IMP_RANK | NUMBER | |||
REG_GROSS_REV_COMP | NUMBER | |||
REG_GROSS_REV_NON_COMP | NUMBER | |||
REG_REV_AT_LIS_PRICE | NUMBER | |||
REG_REV_AT_POL_LIMIT | NUMBER | |||
CORP_PASS_EXCEPTIONS | NUMBER | |||
CORP_FAIL_EXCEPTIONS | NUMBER | |||
CORP_NA_EXCEPTIONS | NUMBER | |||
CORP_HI_SEVER_THRE | NUMBER | |||
CORP_ME_SEVER_THRE | NUMBER | |||
CORP_LO_SEVER_THRE | NUMBER | |||
CORP_HI_POL_IMP_RANK | NUMBER | |||
CORP_ME_POL_IMP_RANK | NUMBER | |||
CORP_LO_POL_IMP_RANK | NUMBER | |||
CORP_GROSS_REV_COMP | NUMBER | |||
CORP_GROSS_REV_NON_COMP | NUMBER | |||
CORP_REV_AT_LIS_PRICE | NUMBER | |||
CORP_REV_AT_POL_LIMIT | NUMBER | |||
GSA_PASS_EXCEPTIONS | NUMBER | |||
GSA_FAIL_EXCEPTIONS | NUMBER | |||
GSA_NA_EXCEPTIONS | NUMBER | |||
GSA_HI_SEVER_THRE | NUMBER | |||
GSA_ME_SEVER_THRE | NUMBER | |||
GSA_LO_SEVER_THRE | NUMBER | |||
GSA_HI_POL_IMP_RANK | NUMBER | |||
GSA_ME_POL_IMP_RANK | NUMBER | |||
GSA_LO_POL_IMP_RANK | NUMBER | |||
GSA_GROSS_REV_COMP | NUMBER | |||
GSA_GROSS_REV_NON_COMP | NUMBER | |||
GSA_REV_AT_LIS_PRICE | NUMBER | |||
GSA_REV_AT_POL_LIMIT | NUMBER | |||
GROSS_REV_NON_COMP | NUMBER | |||
GROSS_REV_COMP | NUMBER | |||
QTY_UOM | VARCHAR2 | (40) | ||
POCKET_PRICE | NUMBER | |||
TOTAL_OFFADJ_REV | NUMBER | |||
TOTAL_COST | NUMBER | |||
MARGIN_PERC | NUMBER | |||
MODEL_QTY | NUMBER |
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
, 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
, CEIL_PASS_EXCEPTIONS
, CEIL_FAIL_EXCEPTIONS
, CEIL_NA_EXCEPTIONS
, CEIL_HI_SEVER_THRE
, CEIL_ME_SEVER_THRE
, CEIL_LO_SEVER_THRE
, CEIL_HI_POL_IMP_RANK
, CEIL_ME_POL_IMP_RANK
, CEIL_LO_POL_IMP_RANK
, CEIL_GROSS_REV_COMP
, CEIL_GROSS_REV_NON_COMP
, CEIL_REV_AT_LIS_PRICE
, CEIL_REV_AT_POL_LIMIT
, FU_PASS_EXCEPTIONS
, FU_FAIL_EXCEPTIONS
, FU_NA_EXCEPTIONS
, FU_HI_SEVER_THRE
, FU_ME_SEVER_THRE
, FU_LO_SEVER_THRE
, FU_HI_POL_IMP_RANK
, FU_ME_POL_IMP_RANK
, FU_LO_POL_IMP_RANK
, FU_GROSS_REV_COMP
, FU_GROSS_REV_NON_COMP
, FU_REV_AT_LIS_PRICE
, FU_REV_AT_POL_LIMIT
, TARGET_PASS_EXCEPTIONS
, TARGET_FAIL_EXCEPTIONS
, TARGET_NA_EXCEPTIONS
, TARGET_HI_SEVER_THRE
, TARGET_ME_SEVER_THRE
, TARGET_LO_SEVER_THRE
, TARGET_HI_POL_IMP_RANK
, TARGET_ME_POL_IMP_RANK
, TARGET_LO_POL_IMP_RANK
, TARGET_GROSS_REV_COMP
, TARGET_GROSS_REV_NON_COMP
, TARGET_REV_AT_LIS_PRICE
, TARGET_REV_AT_POL_LIMIT
, REG_PASS_EXCEPTIONS
, REG_FAIL_EXCEPTIONS
, REG_NA_EXCEPTIONS
, REG_HI_SEVER_THRE
, REG_ME_SEVER_THRE
, REG_LO_SEVER_THRE
, REG_HI_POL_IMP_RANK
, REG_ME_POL_IMP_RANK
, REG_LO_POL_IMP_RANK
, REG_GROSS_REV_COMP
, REG_GROSS_REV_NON_COMP
, REG_REV_AT_LIS_PRICE
, REG_REV_AT_POL_LIMIT
, CORP_PASS_EXCEPTIONS
, CORP_FAIL_EXCEPTIONS
, CORP_NA_EXCEPTIONS
, CORP_HI_SEVER_THRE
, CORP_ME_SEVER_THRE
, CORP_LO_SEVER_THRE
, CORP_HI_POL_IMP_RANK
, CORP_ME_POL_IMP_RANK
, CORP_LO_POL_IMP_RANK
, CORP_GROSS_REV_COMP
, CORP_GROSS_REV_NON_COMP
, CORP_REV_AT_LIS_PRICE
, CORP_REV_AT_POL_LIMIT
, GSA_PASS_EXCEPTIONS
, GSA_FAIL_EXCEPTIONS
, GSA_NA_EXCEPTIONS
, GSA_HI_SEVER_THRE
, GSA_ME_SEVER_THRE
, GSA_LO_SEVER_THRE
, GSA_HI_POL_IMP_RANK
, GSA_ME_POL_IMP_RANK
, GSA_LO_POL_IMP_RANK
, GSA_GROSS_REV_COMP
, GSA_GROSS_REV_NON_COMP
, GSA_REV_AT_LIS_PRICE
, GSA_REV_AT_POL_LIMIT
, GROSS_REV_NON_COMP
, GROSS_REV_COMP
, QTY_UOM
, POCKET_PRICE
, TOTAL_OFFADJ_REV
, TOTAL_COST
, MARGIN_PERC
, MODEL_QTY
FROM APPS.QPR_PRICE_SALES_MEAS_V;
APPS.QPR_PRICE_SALES_MEAS_V is not referenced by any database object
|
|
|