[Home] [Help] [Dependency Information]
Object Name: | QPR_PRICE_SALES_MEAS_ALL_V1 |
---|---|
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) | ||
TIM_SR_LEVEL_VALUE_PK | VARCHAR2 | (0) | ||
END_DATE | DATE | |||
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) | ||
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
, 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_ALL_V1;
APPS.QPR_PRICE_SALES_MEAS_ALL_V1 is not referenced by any database object
|
|
|