DBA Data[Home] [Help] [Dependency Information]


TABLE: GML.GML_BATCH_SO_ALLOC_HISTORY

Object Details
Object Name: GML_BATCH_SO_ALLOC_HISTORY
Object Type: TABLE
Owner: GML
FND Design Data: TableGML.GML_BATCH_SO_ALLOC_HISTORY
Subobject Name:
Status: VALID


OM batch reservations history table


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GML_BATCH_SO_ALLOC_HISTORY_PK NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnALLOC_REC_ID
GML_BATCH_SO_ALLOC_HISTORY_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTRANS_ID
GML_BATCH_SO_ALLOC_HISTORY_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnBATCH_TRANS_ID
GML_BATCH_SO_ALLOC_HISTORY_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnBATCH_LINE_ID
GML_BATCH_SO_ALLOC_HISTORY_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnLINE_ID
Columns
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
Query Text

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;

Dependencies

[top of page]

GML.GML_BATCH_SO_ALLOC_HISTORY does not reference any database object

GML.GML_BATCH_SO_ALLOC_HISTORY is referenced by following:

SchemaAPPS
SynonymGML_BATCH_SO_ALLOC_HISTORY