[Home] [Help] [Dependency Information]
Object Name: | QPR_MRG_BAND_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) | ||
MGB_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_MB | NUMBER | |||
GROSS_REV_MGR_BAND | NUMBER | |||
LIST_PRICE_MB | NUMBER | |||
SELLING_PRICE_MB | NUMBER | |||
ADJUSTED_PRICE_MB | NUMBER | |||
NO_OF_ORDER_LINE_MB | NUMBER | |||
MAX_MRG | NUMBER | |||
MIN_MRG | 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
, MGB_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_MB
, GROSS_REV_MGR_BAND
, LIST_PRICE_MB
, SELLING_PRICE_MB
, ADJUSTED_PRICE_MB
, NO_OF_ORDER_LINE_MB
, MAX_MRG
, MIN_MRG
, 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_MRG_BAND_MEAS_ALL_V;
APPS.QPR_MRG_BAND_MEAS_ALL_V is not referenced by any database object
|
|
|