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

TABLE: MSC.MSC_DRP_HORI_PLANS

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

Temporary Table Details

MSC.MSC_DRP_HORI_PLANS 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_DRP_HORI_PLANS_N1 NORMAL NONUNIQUE Tablespace ColumnQUERY_ID
ColumnHORIZONTAL_PLAN_TYPE
ColumnORGANIZATION_ID
ColumnSR_INSTANCE_ID
ColumnINVENTORY_ITEM_ID
ColumnROW_TYPE
Columns
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
SR_INSTANCE_ID NUMBER
Yes
INVENTORY_ITEM_ID NUMBER
Yes
HORIZONTAL_PLAN_TYPE NUMBER

ROW_TYPE NUMBER

SUB_ORG_ID NUMBER

BUCKET_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
QUANTITY NUMBER

WEIGHT NUMBER

VOLUME NUMBER

CHAR1 VARCHAR2 (250)
Query Text

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


SELECT QUERY_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      INVENTORY_ITEM_ID
,      HORIZONTAL_PLAN_TYPE
,      ROW_TYPE
,      SUB_ORG_ID
,      BUCKET_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      QUANTITY
,      WEIGHT
,      VOLUME
,      CHAR1
FROM MSC.MSC_DRP_HORI_PLANS;

Dependencies

[top of page]

MSC.MSC_DRP_HORI_PLANS does not reference any database object

MSC.MSC_DRP_HORI_PLANS is referenced by following:

SchemaAPPS
SynonymMSC_DRP_HORI_PLANS