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

TABLE: MSC.MSC_VMI_GRAPH

Object Details
Object Name: MSC_VMI_GRAPH
Object Type: TABLE
Owner: MSC
Subobject Name:
Status: VALID

Temporary Table Details

MSC.MSC_VMI_GRAPH 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
Indexes
Index Type Uniqueness Tablespace Column
MSC_VMI_GRAPH_N1 NORMAL NONUNIQUE Tablespace ColumnQUERY_ID
Columns
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER
Yes
GRAPH_DATE DATE

ONHAND NUMBER

ORDER_FORECAST NUMBER

REQ NUMBER

PO NUMBER

ASN NUMBER

RECEIPT NUMBER

PROJECTED_ONHAND NUMBER

SUPPLY_WITHIN_LEAD_TIME NUMBER

MIN NUMBER

MAX NUMBER

SAFETY_STOCK NUMBER

RECOMMENDED_REPLENISHMENT NUMBER

Query Text

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


SELECT QUERY_ID
,      GRAPH_DATE
,      ONHAND
,      ORDER_FORECAST
,      REQ
,      PO
,      ASN
,      RECEIPT
,      PROJECTED_ONHAND
,      SUPPLY_WITHIN_LEAD_TIME
,      MIN
,      MAX
,      SAFETY_STOCK
,      RECOMMENDED_REPLENISHMENT
FROM MSC.MSC_VMI_GRAPH;

Dependencies

[top of page]

MSC.MSC_VMI_GRAPH does not reference any database object

MSC.MSC_VMI_GRAPH is referenced by following:

SchemaAPPS
SynonymMSC_VMI_GRAPH