[Home] [Help] [Dependency Information]
Object Name: | MSC_GANTT_DTL_QUERY |
---|---|
Object Type: | TABLE |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_GANTT_DTL_QUERY_N1 | NORMAL | NONUNIQUE |
QUERY_ID
ROW_INDEX |
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 |
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;
MSC.MSC_GANTT_DTL_QUERY does not reference any database object
MSC.MSC_GANTT_DTL_QUERY is referenced by following:
|
|
|