[Home] [Help] [Dependency Information]
Object Name: | GML_LOT_ERES_TEMP |
---|---|
Object Type: | TABLE |
Owner: | GML |
Subobject Name: | |
Status: | VALID |
GML.GML_LOT_ERES_TEMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_TRANSACTION_ID | NUMBER | (20) | ||
LOT_NUM | VARCHAR2 | (30) | ||
SUBLOT_NUM | VARCHAR2 | (32) | ||
QUANTITY | NUMBER | |||
EXPIRATION_DATE | DATE | |||
ITEM_ID | NUMBER | (20) | ||
OPM_ITEM_ID | NUMBER | (20) | ||
SECONDARY_QUANTITY | NUMBER | |||
REASON_CODE | VARCHAR2 | (4) | ||
LOT_ID | NUMBER | (20) |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_TRANSACTION_ID
, LOT_NUM
, SUBLOT_NUM
, QUANTITY
, EXPIRATION_DATE
, ITEM_ID
, OPM_ITEM_ID
, SECONDARY_QUANTITY
, REASON_CODE
, LOT_ID
FROM GML.GML_LOT_ERES_TEMP;
GML.GML_LOT_ERES_TEMP does not reference any database object
GML.GML_LOT_ERES_TEMP is referenced by following:
|
|
|