[Home] [Help] [Dependency Information]
Object Name: | GML_BATCH_SO_ALLOC_HISTORY |
---|---|
Object Type: | TABLE |
Owner: | GML |
FND Design Data: | GML.GML_BATCH_SO_ALLOC_HISTORY |
Subobject Name: | |
Status: | VALID |
OM batch reservations history table
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GML_BATCH_SO_ALLOC_HISTORY_PK | NORMAL | UNIQUE | APPS_TS_SUMMARY | ALLOC_REC_ID |
GML_BATCH_SO_ALLOC_HISTORY_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | TRANS_ID |
GML_BATCH_SO_ALLOC_HISTORY_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | BATCH_TRANS_ID |
GML_BATCH_SO_ALLOC_HISTORY_N3 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | BATCH_LINE_ID |
GML_BATCH_SO_ALLOC_HISTORY_N4 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALLOC_REC_ID | NUMBER | (15) | Yes | Primary Key |
BATCH_RES_ID | NUMBER | (15) | Yes | Reference to gml_batch_so_reservations.batch_res_id, indicating the reservation record that converted to allocation record |
BATCH_ID | NUMBER | (15) | Yes | Reference to gme_batch_header.batch_id, indicating the batch that the reservation is against |
TRANS_ID | NUMBER | (15) | Trans id of the OMSO allocation that is converted from the reservation record | |
ORDER_NO | NUMBER | Order number of the reservation | ||
BATCH_NO | NUMBER | Batch number of the reservation | ||
PLANT_CODE | VARCHAR2 | (4) | Plant code of the reservation | |
BATCH_TYPE | NUMBER | (5) | Batch type of the reservation | |
LINE_ID | NUMBER | (15) | Yes | Sales order line id that the reservation is made of |
LOT_ID | NUMBER | (15) | Lot id that the OMSO allocation is made to | |
LOCATION | VARCHAR2 | (32) | Location that the OMSO allocation is made of | |
WHSE_CODE | VARCHAR2 | (5) | Warehouse code that the OMSO allocation is made of | |
RULE_ID | NUMBER | (15) | Rule that is used when OMSO allocation is made | |
RESERVED_QTY | NUMBER | Quantity of the reservation | ||
RESERVED_QTY2 | NUMBER | Quantity2 of the reservation | ||
ALLOC_QTY | NUMBER | Quantity that OM Allocation is made | ||
ALLOC_QTY2 | NUMBER | Quantity2 that OM Allocation is made | ||
TRANS_UM | VARCHAR2 | (5) | Same as primary UOM | |
TRANS_UM2 | VARCHAR2 | (5) | Same as secondary UOM | |
FAILURE_REASON | VARCHAR2 | (3000) | Place holder for the reasons that allocation failed | |
BATCH_TRANS_ID | NUMBER | The batch trans id (transaction with doc type of PROD) that OMSO is created from | ||
BATCH_LINE_ID | NUMBER | The batch line id associated with the reservation | ||
DELETE_MARK | NUMBER | (5) | Delete Mark | |
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATED_DATE | DATE | Standard Who Column | ||
PROGRAM_APPLICATION_ID | NUMBER | Program application ID | ||
PROGRAM_ID | NUMBER | (15) | Program ID | |
LAST_UPDATED_BY | NUMBER | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT ALLOC_REC_ID
, BATCH_RES_ID
, BATCH_ID
, TRANS_ID
, ORDER_NO
, BATCH_NO
, PLANT_CODE
, BATCH_TYPE
, LINE_ID
, LOT_ID
, LOCATION
, WHSE_CODE
, RULE_ID
, RESERVED_QTY
, RESERVED_QTY2
, ALLOC_QTY
, ALLOC_QTY2
, TRANS_UM
, TRANS_UM2
, FAILURE_REASON
, BATCH_TRANS_ID
, BATCH_LINE_ID
, DELETE_MARK
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_DATE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, LAST_UPDATED_BY
FROM GML.GML_BATCH_SO_ALLOC_HISTORY;
GML.GML_BATCH_SO_ALLOC_HISTORY does not reference any database object
GML.GML_BATCH_SO_ALLOC_HISTORY is referenced by following:
|
|
|