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


TABLE: MST.MST_MULTI_SELECTION_GT

Object Details
Object Name: MST_MULTI_SELECTION_GT
Object Type: TABLE
Owner: MST
Subobject Name:
Status: VALID

Temporary Table Details

MST.MST_MULTI_SELECTION_GT 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.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
RECORD_USE_TYPE VARCHAR2 (30)
WINDOW_CONTEXT VARCHAR2 (30)
DATA_CONTEXT VARCHAR2 (30)
TRIP_ID NUMBER

CONTINUOUS_MOVE_ID NUMBER

DELIVERY_ID NUMBER

SOURCE_CODE VARCHAR2 (30)
SOURCE_HEADER_NUMBER VARCHAR2 (150)
CUSTOMER_ID NUMBER

SUPPLIER_ID NUMBER

CARRIER_ID NUMBER

FACILITY_ID NUMBER

LOCATION_ID NUMBER

Query Text

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


SELECT RECORD_USE_TYPE
,      WINDOW_CONTEXT
,      DATA_CONTEXT
,      TRIP_ID
,      CONTINUOUS_MOVE_ID
,      DELIVERY_ID
,      SOURCE_CODE
,      SOURCE_HEADER_NUMBER
,      CUSTOMER_ID
,      SUPPLIER_ID
,      CARRIER_ID
,      FACILITY_ID
,      LOCATION_ID
FROM MST.MST_MULTI_SELECTION_GT;

Dependencies

[top of page]

MST.MST_MULTI_SELECTION_GT does not reference any database object

MST.MST_MULTI_SELECTION_GT is referenced by following:

SchemaAPPS
SynonymMST_MULTI_SELECTION_GT