MSC_HVGOP_UNSUPPORTED_ITEMS
This table holds the items which are not supported by HVGOP. All the requests for these items should be promised by C++ Engine GOP flow.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
msc_hvgop_unsupported_ite_PK |
SR_ITEM_ID, CALLING_INSTANCE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SR_ITEM_ID | NUMBER | 18 | Yes | This column holds the fusion side generated inventory_item_id. During orchestration, this column is used for fusion Order Management requests. | |
| ITEM_ID | NUMBER | 18 | Yes | This column holds the planning side generated inventory_item_id. During orchestration, this column is used for Manage Order Promising Demands UI requests. | |
| ITEM_NAME | VARCHAR2 | 300 | Yes | This column holds the item name. During orchestration, this column is used for public web service calls. | |
| CALLING_INSTANCE | NUMBER | 18 | Yes | This column holds the value of Source system Id. | |
| BACK_TO_BACK_FLAG | NUMBER | 1 | This column will hold value as 1 in case the item is back to back enabled in any organization. | ||
| ALLOCATION_FLAG | NUMBER | 1 | This column will hold value as 1 if the allocation rule is assigned for this item in any organization. | ||
| MAKE_SOURCING_FLAG | NUMBER | 1 | This column will hold value as 1 in case item (which is not a Model/Optional Class/Config Item) having 'search_components_code enabled' or 'planning_make_buy_code as MAKE and MAKE Sourcing Rule defined' in any organization. | ||
| COMPONENT_FLAG | NUMBER | 1 | This column will hold value as 1 in case item is a component of Assembly (Assembly is not a Model/Optional Class/Config Item) and Assembly is also part of MSC_HVGOP_UNSUPPORTED_ITEMS table. | ||
| COMPONENT_SUBS_FLAG | NUMBER | 1 | This column will hold value as 1 in case item is substitute for a component of Assembly (Assembly is not a Model/Opt.Class/Config) and Assembly is also part of MSC_HVGOP_UNSUPPORTED_ITEMS table. | ||
| PTP_FLAG | NUMBER | 1 | This column will hold value as 1 in case the item having ATP rule with PROFITABLE_TO_PROMISE_CODE enabled in any organization. | ||
| ATF_FLAG | NUMBER | 1 | This column will hold value as 1 in case the item having ATP rule with ATP_TIME_FENCE defined in any organization. | ||
| WD_RES_FLAG | NUMBER | 1 | This column will hold value as 1 in case Model/Optional Class/Config Item having work definition with resources enabled for GOP in any organization. | ||
| SUPPLIER_CAPACITY_FLAG | NUMBER | 1 | This column will hold value as 1 in case item is having supplier capacity defined and having supply_chain_search_code enabled at ATP Rule level in any organization. | ||
| HAVING_MANDATORY_COMP_FLAG | NUMBER | 1 | This column will hold value as 1 in case Model, Option Class or Config Item is having Mandatory component and mandatory component is having search_components_code enabled at ATP Rule level in any organization. | ||
| PLAN_INTEGRATION_FLAG | NUMBER | 1 | This column will hold value as 1 in case the user is using plan integration. In such cases, all items of having supply/demands from Plan Outputs will have this flag enabled. | ||
| PROMISED_BY_CPP_GOP_FLAG | NUMBER | 1 | This column will hold value as 1 whenever C++ engine promises for this item(belong to any org). | ||
| DELETED_FLAG | NUMBER | 1 | We will use this column to find the items which are eligible to get deleted from this table. Eg: To start with say an item is back_to_back enabled (rest all other columns hold value as null). So we will have an entry in this table with BACK_TO_BACK_FLAG as 1. Now say there is a change in set up of this item (belong to any org) and is not a back_to_back enabled, then we need to delete data from this table. So, this column will be first updated to '1' and then as on we trace through all queries, we will flip this value to 2 if found. At the end of the process, we will delete the items that are in this table with deleted_flag as '1'and PROMISED_BY_CPP_GOP_FLAG is null. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of 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_HVGOP_UNSUPPORTED_ITEMS_N1 | Non Unique | Default | DELETED_FLAG, PROMISED_BY_CPP_GOP_FLAG |
| MSC_HVGOP_UNSUPPORTED_ITEMS_U1 | Unique | Default | SR_ITEM_ID, CALLING_INSTANCE |
| MSC_HVGOP_UNSUPPORTED_ITEMS_U2 | Unique | Default | ITEM_NAME, CALLING_INSTANCE |
| MSC_HVGOP_UNSUPPORTED_ITEMS_U3 | Unique | Default | ITEM_ID, CALLING_INSTANCE |