MSC_DEMAND_RECOM_MAPS
This table is used in Demand Fulfillment View. This is a join table that maps both msc_risk_demands and msc_recommendations.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
msc_demand_recom_maps_PK |
PLAN_ID, RECOMMENDATION_ID, DEMAND_ID, RECOMMENDATION_TYPE |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| PLAN_ID | NUMBER | Yes | This value indicates the plan identifier for the record | |
| RECOMMENDATION_ID | NUMBER | Yes | The recommendation identifier, the value matches the recommendations_id in msc_recommendations for the plan | |
| DEMAND_ID | NUMBER | Yes | The demand identifier, the value matches the demand_id in msc_demands for the plan | |
| RECOMMENDATION_TYPE | NUMBER | Yes | The value indicates the recommendation type, 1-Expedite Buy order, 2-Expedite Transfer order, 3-Expedite Make order, 4-Resource Capacity, 5-Supplier Capacity, 6-Resource Capacity Constraints, 7-Supplier Capacity Constraints, 8-Late Maturity Supply | |
| EXCEPTION_DETAIL_ID | NUMBER | This is the id of the exception in msc_exception_details for the problem that makes this end demand at risk and is solved by this recommendation. This is populated only for recommendation of type Resource Capacity, Supplier Capacity, Resource Capacity Constraints, Supplier Capacity Constraints | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_DEMAND_RECOM_MAPS_N1 | Non Unique | Default | PLAN_ID, DEMAND_ID, RECOMMENDATION_TYPE |
| MSC_DEMAND_RECOM_MAPS_U1 | Unique | Default | PLAN_ID, RECOMMENDATION_ID, DEMAND_ID, RECOMMENDATION_TYPE |