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

TABLE: GME.GME_EXCEPTIONS_GTMP

Object Details
Object Name: GME_EXCEPTIONS_GTMP
Object Type: TABLE
Owner: GME
FND Design Data: TableGME.GME_EXCEPTIONS_GTMP
Subobject Name:
Status: VALID

This is a new table that holds material details information for the exception materials

Temporary Table Details

GME.GME_EXCEPTIONS_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$TRANSACTION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

The organization for which the parameters are defined.
PENDING_MOVE_ORDER_IND NUMBER (1)
To indicate if Pending Move Orders exist 0 No move order exist 1 Move Order Exist
PENDING_RESERVATIONS_IND NUMBER (1)
To indicate Pending Reservations exist. 0 No reservations exist 1 reservations Exist
ONHAND_QTY NUMBER

On hand quantity
ATT NUMBER

Available to Transact
ATR NUMBER

Available to Reserve
MATERIAL_DETAIL_ID NUMBER

Identifier to Material Details
TRANSACTED_QTY NUMBER

Quantity already transacted
EXCEPTION_QTY NUMBER

Quantity not able to transact
BATCH_ID NUMBER

Identifier to Batch Header
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ORGANIZATION_ID
,      PENDING_MOVE_ORDER_IND
,      PENDING_RESERVATIONS_IND
,      ONHAND_QTY
,      ATT
,      ATR
,      MATERIAL_DETAIL_ID
,      TRANSACTED_QTY
,      EXCEPTION_QTY
,      BATCH_ID
FROM GME.GME_EXCEPTIONS_GTMP;

Dependencies

[top of page]

GME.GME_EXCEPTIONS_GTMP does not reference any database object

GME.GME_EXCEPTIONS_GTMP is referenced by following:

SchemaAPPS
SynonymGME_EXCEPTIONS_GTMP