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

TABLE: MSC.MSC_MATERIAL_PLANS

Object Details
Object Name: MSC_MATERIAL_PLANS
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_MATERIAL_PLANS
Subobject Name:
Status: VALID


MSC_MATERIAL_PLANS is a generic table used by forms for querying data.
This table is used to display material horizontal plan information in the
Planner Workbench. QUERY_ID is the query identifier used while populating
the table. The QUANTITY columns contain generic data used in the PL/SQL
procedure to select data.
This table is also used to generate horizontal bucketed view of supply and demand in Oracle Supply Chain Hub.


Temporary Table Details

MSC.MSC_MATERIAL_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_MATERIAL_PLANS_N1 NORMAL NONUNIQUE Tablespace ColumnQUERY_ID
Columns
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER
Yes Query identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
SR_INSTANCE_ID NUMBER
Yes Source application instance identifer
PLAN_ID NUMBER
Yes Plan identifier
PLAN_ORGANIZATION_ID NUMBER

Planned organization identifier
PLAN_INSTANCE_ID NUMBER

Source application instance identifier for the planned org
ORGANIZATION_CODE VARCHAR2 (7)
Planned organization code
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
ITEM_SEGMENTS VARCHAR2 (255)
Decribe the inventory item
HORIZONTAL_PLAN_TYPE NUMBER

Horizontal plan type
BUCKET_TYPE NUMBER
Yes Bucket type
BUCKET_DATE DATE
Yes Bucket date
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
HORIZONTAL_PLAN_TYPE_TEXT VARCHAR2 (80)
Horizontal plan type text
QUANTITY1 NUMBER

Generic quantity column
QUANTITY2 NUMBER

Generic quantity column
QUANTITY3 NUMBER

Generic quantity column
QUANTITY4 NUMBER

Generic quantity column
QUANTITY5 NUMBER

Generic quantity column
QUANTITY6 NUMBER

Generic quantity column
QUANTITY7 NUMBER

Generic quantity column
QUANTITY8 NUMBER

Generic quantity column
QUANTITY9 NUMBER

Generic quantity column
QUANTITY10 NUMBER

Generic quantity column
QUANTITY11 NUMBER

Generic quantity column
QUANTITY12 NUMBER

Generic quantity column
QUANTITY13 NUMBER

Generic quantity column
QUANTITY14 NUMBER

Generic quantity column
QUANTITY15 NUMBER

Generic quantity column
QUANTITY16 NUMBER

Generic quantity column
QUANTITY17 NUMBER

Generic quantity column
QUANTITY18 NUMBER

Generic quantity column
QUANTITY19 NUMBER

Generic quantity column
QUANTITY20 NUMBER

Generic quantity column
QUANTITY21 NUMBER

Generic quantity column
QUANTITY22 NUMBER

Generic quantity column
QUANTITY23 NUMBER

Generic quantity column
QUANTITY24 NUMBER

Generic quantity column
QUANTITY25 NUMBER

Generic quantity column
QUANTITY26 NUMBER

Generic quantity column
QUANTITY27 NUMBER

Generic quantity column
QUANTITY28 NUMBER

Generic quantity column
QUANTITY29 NUMBER

Generic quantity column
QUANTITY30 NUMBER

Generic quantity column
QUANTITY31 NUMBER

Generic quantity column
QUANTITY32 NUMBER

Generic quantity column
QUANTITY33 NUMBER

Generic quantity column
QUANTITY34 NUMBER

Generic quantity column
QUANTITY35 NUMBER

Generic quantity column
QUANTITY36 NUMBER

Generic quantity column
QUANTITY37 NUMBER

QUANTITY38 NUMBER

QUANTITY39 NUMBER

QUANTITY40 NUMBER

QUANTITY41 NUMBER

QUANTITY42 NUMBER

QUANTITY43 NUMBER

QUANTITY44 NUMBER

QUANTITY45 NUMBER

QUANTITY46 NUMBER

QUANTITY47 NUMBER

QUANTITY48 NUMBER

QUANTITY49 NUMBER

QUANTITY50 NUMBER

QUANTITY51 NUMBER

QUANTITY52 NUMBER

QUANTITY53 NUMBER

QUANTITY54 NUMBER

QUANTITY55 NUMBER

QUANTITY56 NUMBER

Query Text

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


SELECT QUERY_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      PLAN_ID
,      PLAN_ORGANIZATION_ID
,      PLAN_INSTANCE_ID
,      ORGANIZATION_CODE
,      INVENTORY_ITEM_ID
,      ITEM_SEGMENTS
,      HORIZONTAL_PLAN_TYPE
,      BUCKET_TYPE
,      BUCKET_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      HORIZONTAL_PLAN_TYPE_TEXT
,      QUANTITY1
,      QUANTITY2
,      QUANTITY3
,      QUANTITY4
,      QUANTITY5
,      QUANTITY6
,      QUANTITY7
,      QUANTITY8
,      QUANTITY9
,      QUANTITY10
,      QUANTITY11
,      QUANTITY12
,      QUANTITY13
,      QUANTITY14
,      QUANTITY15
,      QUANTITY16
,      QUANTITY17
,      QUANTITY18
,      QUANTITY19
,      QUANTITY20
,      QUANTITY21
,      QUANTITY22
,      QUANTITY23
,      QUANTITY24
,      QUANTITY25
,      QUANTITY26
,      QUANTITY27
,      QUANTITY28
,      QUANTITY29
,      QUANTITY30
,      QUANTITY31
,      QUANTITY32
,      QUANTITY33
,      QUANTITY34
,      QUANTITY35
,      QUANTITY36
,      QUANTITY37
,      QUANTITY38
,      QUANTITY39
,      QUANTITY40
,      QUANTITY41
,      QUANTITY42
,      QUANTITY43
,      QUANTITY44
,      QUANTITY45
,      QUANTITY46
,      QUANTITY47
,      QUANTITY48
,      QUANTITY49
,      QUANTITY50
,      QUANTITY51
,      QUANTITY52
,      QUANTITY53
,      QUANTITY54
,      QUANTITY55
,      QUANTITY56
FROM MSC.MSC_MATERIAL_PLANS;

Dependencies

[top of page]

MSC.MSC_MATERIAL_PLANS does not reference any database object

MSC.MSC_MATERIAL_PLANS is referenced by following:

SchemaAPPS
SynonymMSC_MATERIAL_PLANS