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

TABLE: MSC.MSC_GANTT_DTL_QUERY

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

Temporary Table Details

MSC.MSC_GANTT_DTL_QUERY 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
Indexes
Index Type Uniqueness Tablespace Column
MSC_GANTT_DTL_QUERY_N1 NORMAL NONUNIQUE Tablespace ColumnQUERY_ID
ColumnROW_INDEX
Columns
Name Datatype Length Mandatory Comments
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

QUERY_ID NUMBER

ROW_INDEX NUMBER

ROW_TYPE NUMBER

PARENT_ID NUMBER

SR_INSTANCE_ID NUMBER

ORGANIZATION_ID NUMBER

INVENTORY_ITEM_ID NUMBER

TRANSACTION_ID NUMBER

SUPPLY_ID NUMBER

START_DATE DATE

END_DATE DATE

CEPST DATE

CEPCT DATE

ULPST DATE

ULPCT DATE

UEPST DATE

UEPCT DATE

EACT DATE

RESOURCE_UNITS NUMBER

RESOURCE_HOURS NUMBER

LATE_FLAG NUMBER

SCHEDULE_FLAG NUMBER

SUP_FIRM_FLAG NUMBER

RES_FIRM_FLAG NUMBER

DISPLAY_FLAG NUMBER

STATUS NUMBER

APPLIED NUMBER

ITEM_NAME VARCHAR2 (250)
ORG_CODE VARCHAR2 (10)
SUPPLY_QTY NUMBER

BATCH_NUMBER NUMBER

ALTERNATE_FLAG VARCHAR2 (30)
ORDER_TYPE NUMBER

ORDER_TYPE_TEXT VARCHAR2 (250)
OP_SHORT_DESC VARCHAR2 (250)
GROUP_SEQUENCE_NUMBER NUMBER

GROUP_SEQUENCE_ID NUMBER

BATCH_QTY NUMBER

BATCH_UTIL_PCT NUMBER

SUPP_AVAIL_QTY NUMBER

SUPP_OVERLOAD_QTY NUMBER

SUPP_CONSUME_QTY NUMBER

SUPP_CUM_AVAIL_QTY NUMBER

BAR_LABEL VARCHAR2 (500)
ORDER_NUMBER VARCHAR2 (300)
OP_SEQ_NUM NUMBER

RESOURCE_DESCRIPTION VARCHAR2 (300)
ASSEMBLY_ITEM_DESC VARCHAR2 (300)
SCHEDULE_QTY NUMBER

FROM_SETUP_CODE VARCHAR2 (30)
TO_SETUP_CODE VARCHAR2 (30)
STD_OP_CODE VARCHAR2 (30)
CHANGEOVER_TIME NUMBER

CHANGEOVER_PENALTY NUMBER

MIN_CAPACITY NUMBER

MAX_CAPACITY NUMBER

CAPACITY_USED NUMBER

RESOURCE_SEQ_NUM NUMBER

Query Text

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


SELECT LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      QUERY_ID
,      ROW_INDEX
,      ROW_TYPE
,      PARENT_ID
,      SR_INSTANCE_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      TRANSACTION_ID
,      SUPPLY_ID
,      START_DATE
,      END_DATE
,      CEPST
,      CEPCT
,      ULPST
,      ULPCT
,      UEPST
,      UEPCT
,      EACT
,      RESOURCE_UNITS
,      RESOURCE_HOURS
,      LATE_FLAG
,      SCHEDULE_FLAG
,      SUP_FIRM_FLAG
,      RES_FIRM_FLAG
,      DISPLAY_FLAG
,      STATUS
,      APPLIED
,      ITEM_NAME
,      ORG_CODE
,      SUPPLY_QTY
,      BATCH_NUMBER
,      ALTERNATE_FLAG
,      ORDER_TYPE
,      ORDER_TYPE_TEXT
,      OP_SHORT_DESC
,      GROUP_SEQUENCE_NUMBER
,      GROUP_SEQUENCE_ID
,      BATCH_QTY
,      BATCH_UTIL_PCT
,      SUPP_AVAIL_QTY
,      SUPP_OVERLOAD_QTY
,      SUPP_CONSUME_QTY
,      SUPP_CUM_AVAIL_QTY
,      BAR_LABEL
,      ORDER_NUMBER
,      OP_SEQ_NUM
,      RESOURCE_DESCRIPTION
,      ASSEMBLY_ITEM_DESC
,      SCHEDULE_QTY
,      FROM_SETUP_CODE
,      TO_SETUP_CODE
,      STD_OP_CODE
,      CHANGEOVER_TIME
,      CHANGEOVER_PENALTY
,      MIN_CAPACITY
,      MAX_CAPACITY
,      CAPACITY_USED
,      RESOURCE_SEQ_NUM
FROM MSC.MSC_GANTT_DTL_QUERY;

Dependencies

[top of page]

MSC.MSC_GANTT_DTL_QUERY does not reference any database object

MSC.MSC_GANTT_DTL_QUERY is referenced by following:

SchemaAPPS
SynonymMSC_GANTT_DTL_QUERY