MSC_RISK_DEMANDS
This table is created for maintaining the list of demands that are at risk for a particular plan. This is used in Supply Planning Demand Fulfillment View.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
msc_risk_demands_PK |
PLAN_ID, DEMAND_ID |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| PLAN_ID | NUMBER | Yes | This value indicates the plan identifier for the record | |
| BASE_PLAN_ID | NUMBER | Describes the Plan Id of the Base Plan | ||
| CUM_ORDER_VALUE | NUMBER | This value indicates the cumulative order value for the record | ||
| DEMAND_ID | NUMBER | Yes | This value indicates the demand identifier of the demand at risk | |
| ORGANIZATION_ID | NUMBER | Describes Id of the Organization for the record | ||
| INVENTORY_ITEM_ID | NUMBER | Describes Id of the Item Name for the record | ||
| STATUS | NUMBER | Describes Status of the At Risk Demand | ||
| ORDER_NUMBER | VARCHAR2 | 240 | Describes Order Number of the At Risk Demand | |
| ORDER_LINE_NUMBER | VARCHAR2 | 150 | Describes Order Line Number of the At Risk Demand | |
| DESIGNATOR_ID | NUMBER | Describes Forecast Designator of the At Risk Demand | ||
| ORDER_TYPE | NUMBER | Describes Demand Type of the At Risk Demand | ||
| PRIORITY | NUMBER | Describes priority of the At Risk Demand | ||
| CUSTOMER_ID | NUMBER | Describes Id of the Customer for the record | ||
| CUSTOMER_SITE_ID | NUMBER | Describes Id of the Customer Site for the record | ||
| QUANTITY | NUMBER | Describes Quantity of the At Risk Demand | ||
| ORDER_VALUE | NUMBER | Describes Order Value of the At Risk Demand | ||
| LATE_QUANTITY | NUMBER | Describes Late Quantity of the At Risk Demand | ||
| LATE_DEMAND_VALUE | NUMBER | Describes Late Demand Value of the At Risk Demand | ||
| SUGGESTED_DUE_DATE | DATE | Describes Due Date of the At Risk Demand | ||
| DEMAND_CLASS | VARCHAR2 | 100 | Describes Demand Class of the At Risk Demand | |
| NOTES_COUNT | NUMBER | Describes Notes Count of the At Risk Demand | ||
| MATERIAL_AVAILABLE_DATE | DATE | Describes Material Available Date of the At Risk Demand | ||
| REQUEST_SHIP_DATE | DATE | Describes Request Ship Date of the At Risk Demand | ||
| PLANNED_ARRIVAL_DATE | DATE | Describes Planned Arrival Date of the At Risk Demand | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |
| CUM_RECOM_COUNT | NUMBER | Cumulative recommendations count | ||
| DAYS_LATE | NUMBER | Describes Days Late of the At Risk Demand | ||
| PLAN_TYPE | NUMBER | Describes if the plan is Constrained or Unconstrained plan | ||
| RISK_DEMANDS_DISPLAY_ORDER | NUMBER | RISK_DEMANDS_DISPLAY_ORDER used for sorting the At Risk Demands based on Order_Value/Pending Recommendations |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_RISK_DEMANDS_N1 | Non Unique | Default | PLAN_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID |
| MSC_RISK_DEMANDS_U1 | Unique | Default | PLAN_ID, DEMAND_ID |