[Home] [Help] [Dependency Information]
Object Name: | QPR_COST_MEAS_ALL_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) | ||
COS_SR_LEVEL_VALUE_PK | VARCHAR2 | (240) | ||
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 | |||
LIST_PRICE | NUMBER | |||
SELLING_PRICE | NUMBER | |||
ADJUSTED_PRICE | NUMBER | |||
NO_OF_ORDER_LINE | NUMBER | |||
COST_AMT_REV | 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) |
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
, COS_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
, LIST_PRICE
, SELLING_PRICE
, ADJUSTED_PRICE
, NO_OF_ORDER_LINE
, COST_AMT_REV
, 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
FROM APPS.QPR_COST_MEAS_ALL_V;
APPS.QPR_COST_MEAS_ALL_V is not referenced by any database object
|
|
|