[Home] [Help] [Dependency Information]
Object Name: | QPR_SR_ORDER_DATA_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Order measure source view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SR_INV_ORG_PK | NUMBER | Organization key | ||
INV_ORG | VARCHAR2 | (0) | Inventory organization | |
SR_ITEM_PK | NUMBER | Item key | ||
ITEM | VARCHAR2 | (0) | Item | |
SR_CUSTOMER_PK | NUMBER | Customer key | ||
CUSTOMER | VARCHAR2 | (0) | Customer | |
SR_SALES_CHANNEL_PK | VARCHAR2 | (40) | Sales channel key | |
SALES_CHANNEL | VARCHAR2 | (0) | Sales channel | |
SR_SALES_REP_PK | NUMBER | Sales rep key | ||
SALES_REP | VARCHAR2 | (0) | Sales representative | |
SR_SHIP_TO_LOC_PK | NUMBER | Geography key | ||
SHIP_TO_LOC | VARCHAR2 | (0) | Geography | |
OU_ID | NUMBER | Organization unit | ||
BOOKED_DATE | DATE | Booked date | ||
AMOUNT | NUMBER | Amount | ||
QTY_ORDERED | NUMBER | Ordered quantity | ||
BASE_LIST_PRICE | NUMBER | Base list price | ||
UNIT_SELLING_PRICE | NUMBER | Unit selling price | ||
ADJUSTED_SELLING_PRICE | NUMBER | Adjusted selling price | ||
NO_OF_ORDER_LINES | NUMBER | Number of order lines | ||
DISC_PERC | NUMBER | Discount percentage | ||
SR_USER_DEFINED1_PK | NUMBER | Not used | ||
USER_DEFINED1 | VARCHAR2 | (0) | Not used | |
SR_USER_DEFINED2_PK | NUMBER | Not used | ||
USER_DEFINED2 | VARCHAR2 | (0) | Not used | |
SR_USER_DEFINED3_PK | NUMBER | Not used | ||
USER_DEFINED3 | VARCHAR2 | (0) | Not used | |
SR_USER_DEFINED4_PK | NUMBER | Not used | ||
USER_DEFINED4 | VARCHAR2 | (0) | Not used | |
SR_USER_DEFINED5_PK | NUMBER | Not used | ||
USER_DEFINED5 | VARCHAR2 | (0) | Not used | |
SR_ORDER_LINE_PK | NUMBER | Yes | Order dimension key | |
ORDERLINE | VARCHAR2 | (0) | Order line id | |
SR_ADJ_ID_PK | NUMBER | Not used | ||
ADJUSTMENT_ID | VARCHAR2 | (0) | Not used | |
UOM_CODE | VARCHAR2 | (4000) | UOM | |
ITEM_TYPE_CODE | VARCHAR2 | (30) | Item type code |
Cut, paste (and edit) the following text to query this object:
SELECT SR_INV_ORG_PK
, INV_ORG
, SR_ITEM_PK
, ITEM
, SR_CUSTOMER_PK
, CUSTOMER
, SR_SALES_CHANNEL_PK
, SALES_CHANNEL
, SR_SALES_REP_PK
, SALES_REP
, SR_SHIP_TO_LOC_PK
, SHIP_TO_LOC
, OU_ID
, BOOKED_DATE
, AMOUNT
, QTY_ORDERED
, BASE_LIST_PRICE
, UNIT_SELLING_PRICE
, ADJUSTED_SELLING_PRICE
, NO_OF_ORDER_LINES
, DISC_PERC
, SR_USER_DEFINED1_PK
, USER_DEFINED1
, SR_USER_DEFINED2_PK
, USER_DEFINED2
, SR_USER_DEFINED3_PK
, USER_DEFINED3
, SR_USER_DEFINED4_PK
, USER_DEFINED4
, SR_USER_DEFINED5_PK
, USER_DEFINED5
, SR_ORDER_LINE_PK
, ORDERLINE
, SR_ADJ_ID_PK
, ADJUSTMENT_ID
, UOM_CODE
, ITEM_TYPE_CODE
FROM APPS.QPR_SR_ORDER_DATA_V;
APPS.QPR_SR_ORDER_DATA_V is not referenced by any database object
|
|
|