[Home] [Help] [Dependency Information]
Object Name: | GME_MATERIAL_DISPENSING_GTMP |
---|---|
Object Type: | TABLE |
Owner: | GME |
FND Design Data: | GME.GME_MATERIAL_DISPENSING_GTMP |
Subobject Name: | |
Status: | VALID |
GME.GME_MATERIAL_DISPENSING_GTMP 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$SESSION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DISPENSE_ID | NUMBER | (15) | Yes | Surrogate to GMO_MATERIAL_DISPENSES |
SUBINVENTORY_CODE | VARCHAR2 | (10) | Subinventory where material is dispensed | |
LOCATOR_ID | NUMBER | Locator where material is dispensed | ||
LOT_NUMBER | VARCHAR2 | (80) | Lot dispensed | |
DISPENSE_UOM | VARCHAR2 | (4) | Yes | Dispense UOM |
DISPENSED_QTY | NUMBER | (15) | Yes | Quantity dispenseed in dispense UOM |
SECONDARY_DISPENSED_QTY | NUMBER | (15) | Quantity dispensed in secondary UOM | |
REVISION | VARCHAR2 | (3) | Item Revision for the dispensed record |
Cut, paste (and edit) the following text to query this object:
SELECT DISPENSE_ID
, SUBINVENTORY_CODE
, LOCATOR_ID
, LOT_NUMBER
, DISPENSE_UOM
, DISPENSED_QTY
, SECONDARY_DISPENSED_QTY
, REVISION
FROM GME.GME_MATERIAL_DISPENSING_GTMP;
GME.GME_MATERIAL_DISPENSING_GTMP does not reference any database object
GME.GME_MATERIAL_DISPENSING_GTMP is referenced by following:
|
|
|