[Home] [Help] [Dependency Information]
Object Name: | GME_BATCH_SALES_ORDERS |
---|---|
Object Type: | TABLE |
Owner: | GME |
FND Design Data: | GME.GME_BATCH_SALES_ORDERS |
Subobject Name: | |
Status: | VALID |
This table tracks the sales order(s) used to generate the batch(es).
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GME_BATCH_SALES_ORDERS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
BATCH_ID
ORDER_ID LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (10) | Yes | The batch created to supply the sales order. FK to GME_BATCH_HEADER |
ORDER_ID | NUMBER | Yes | Surrogate key to OE_ORDER_HEADERS.HEADER_ID (Order Management Sales Order Table) | |
CREATION_DATE | DATE | Standard WHO Column | ||
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Columns | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO Columns |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Columns |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Columns | |
LINE_ID | NUMBER | Yes | Surrogate key to OE_ORDER_LINES_ALL.LINE_ID (OrderManagement Sales Order Lines Table). |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, ORDER_ID
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LINE_ID
FROM GME.GME_BATCH_SALES_ORDERS;
GME.GME_BATCH_SALES_ORDERS does not reference any database object
GME.GME_BATCH_SALES_ORDERS is referenced by following:
|
|
|