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

TABLE: MST.MST_MAP_SELECTED_OBJECTS

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

Temporary Table Details

MST.MST_MAP_SELECTED_OBJECTS 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
OBJECT_NUMBER VARCHAR2 (100)
OBJECT_TYPE VARCHAR2 (10)
TRIP_ID NUMBER

DELIVERY_ID NUMBER

MODE_OF_TRANSPORT VARCHAR2 (30)
CARRIER_ID NUMBER

CARRIER_NAME VARCHAR2 (100)
SERVICE_LEVEL VARCHAR2 (30)
SERVICE_LEVEL_TL VARCHAR2 (30)
VEHICLE_TYPE_ID NUMBER

VECHICLE_TYPE VARCHAR2 (100)
DEPARTURE VARCHAR2 (100)
ARRIVAL VARCHAR2 (100)
ORIGIN_FACILITY VARCHAR2 (100)
ORIGIN_FACILITY_ID NUMBER

DESTINATION_FACILITY VARCHAR2 (100)
DESTINATION_FACILITY_ID NUMBER

Query Text

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


SELECT OBJECT_NUMBER
,      OBJECT_TYPE
,      TRIP_ID
,      DELIVERY_ID
,      MODE_OF_TRANSPORT
,      CARRIER_ID
,      CARRIER_NAME
,      SERVICE_LEVEL
,      SERVICE_LEVEL_TL
,      VEHICLE_TYPE_ID
,      VECHICLE_TYPE
,      DEPARTURE
,      ARRIVAL
,      ORIGIN_FACILITY
,      ORIGIN_FACILITY_ID
,      DESTINATION_FACILITY
,      DESTINATION_FACILITY_ID
FROM MST.MST_MAP_SELECTED_OBJECTS;

Dependencies

[top of page]

MST.MST_MAP_SELECTED_OBJECTS does not reference any database object

MST.MST_MAP_SELECTED_OBJECTS is referenced by following:

SchemaAPPS
SynonymMST_MAP_SELECTED_OBJECTS