[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSC_MATERIAL_PLANS |
|---|---|
| Object Type: | TABLE |
| Owner: | MSC |
| FND Design Data: |  MSC.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.
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.
| Tablespace: |  |
|---|---|
| PCT Free: | 10 |
| PCT Used: | 40 |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MSC_MATERIAL_PLANS_N1 | NORMAL | NONUNIQUE |
|
 QUERY_ID
|
| 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 |
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
FROM MSC.MSC_MATERIAL_PLANS;
MSC.MSC_MATERIAL_PLANS does not reference any database object
MSC.MSC_MATERIAL_PLANS is referenced by following:
APPS
MSC_MATERIAL_PLANS
|
|
|
|