[Home] [Help] [Dependency Information]

TABLE: MSD.MSD_DEM_LOCATIONS_GTT

Object Details

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

Temporary Table Details

MSD.MSD_DEM_LOCATIONS_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_INV_ORG_PK
,      SR_SHIP_TO_LOC_PK
,      SR_SALES_CHANNEL_PK
,      INSTANCE
,      SITE_TYPE
FROM MSD.MSD_DEM_LOCATIONS_GTT;

Dependencies

[top of page]

MSD.MSD_DEM_LOCATIONS_GTT does not reference any database object

MSD.MSD_DEM_LOCATIONS_GTT is referenced by following:

APPS

MSD_DEM_LOCATIONS_GTT