[Home] [Help] [Dependency Information]

TABLE: MSD.MSD_DEM_ITEMS_GTT

Object Details

Object Name:	MSD_DEM_ITEMS_GTT
Object Type:	TABLE
Owner:	MSD
FND Design Data:	MSD.MSD_DEM_ITEMS_GTT
Subobject Name:
Status:	VALID

Temporary Table Details

MSD.MSD_DEM_ITEMS_GTT 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:
PCT Free:	10
PCT Used:	40

Columns

Query Text

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

SELECT SR_INSTANCE_ID
,      SR_INVENTORY_ITEM_ID
,      SR_DEMAND_CLASS_PK
,      INVENTORY_ITEM_ID
FROM MSD.MSD_DEM_ITEMS_GTT;

Dependencies

[top of page]

MSD.MSD_DEM_ITEMS_GTT does not reference any database object

MSD.MSD_DEM_ITEMS_GTT is referenced by following:

APPS

MSD_DEM_ITEMS_GTT