MSC_INSTANCE_ORGS
This stores the information of the association links between each organization and MSC.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
MSC_INSTANCE_ORGS_PK |
SR_INSTANCE_ID, SR_ORGANIZATION_CODE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SR_INSTANCE_ID | NUMBER | Yes | Identifier of the source system from where the data is collected. | ||
| ORGANIZATION_CODE | VARCHAR2 | 49 | Yes | Organization code in the Planning System. | |
| ENABLE_ATP_WS | NUMBER | This flag indicates whether ATP web service is enabled. | |||
| ORGANIZATION_ID | NUMBER | Organization Identifier in the Planning System. | |||
| DESCRIPTION | VARCHAR2 | 240 | Description of the instance org | ||
| 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. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ENABLED_FLAG | NUMBER | Yes | Determine whether this record is enabled | ||
| ORG_GROUP | VARCHAR2 | 30 | This value indicates the organization group name/code used while launching planning collections. | ||
| SUPPLIER_CAPACITY_LRN | NUMBER | Last refresh number of the collection cycle that collected Supplier capacity entity. | |||
| BOM_LRN | NUMBER | Last refresh number of the collection cycle that collected Bill of Materials entity. | |||
| BOR_LRN | NUMBER | Last refresh number of the collection cycle that collected Bill of Resources entity. | |||
| FORECAST_LRN | NUMBER | Last refresh number of the collection cycle that collected Forecast entity. | |||
| ITEM_LRN | NUMBER | Last refresh number of the collection cycle that collected Item org entity. | |||
| MDS_LRN | NUMBER | Last refresh number of the collection cycle that collected MDS. | |||
| MPS_LRN | NUMBER | Last refresh number of the collection cycle that collected MPS. | |||
| OH_LRN | NUMBER | Last refresh number of the collection cycle that collected Onhand entity. | |||
| RESERVATIONS_LRN | NUMBER | Last refresh number of the collection cycle that collected Reservations entity. | |||
| PO_LRN | NUMBER | Last refresh number of the collection cycle that collected Purchase order entity. | |||
| SO_LRN | NUMBER | Last refresh number of the collection cycle that collected Sales orders entity. | |||
| USER_SUPPLY_DEMAND_LRN | NUMBER | Last refresh number of the collection cycle that collected User Supply Demand entity. | |||
| WIP_LRN | NUMBER | Last refresh number of the collection cycle that collected Work in process entity. | |||
| NRA_LRN | NUMBER | Last refresh number of the collection cycle that collected NRA. | |||
| SAF_STOCK_LRN | NUMBER | Last refresh number of the collection cycle that collected Safety stocks entity. | |||
| UNIT_NO_LRN | NUMBER | Last refresh number of the collection cycle that collected Unit number entity. | |||
| UOM_LRN | NUMBER | Last refresh number of the collection cycle that collected Units of measure entity. | |||
| CALENDAR_LRN | NUMBER | Last refresh number of the collection cycle that collected Calendars entity. | |||
| TRIP_LRN | NUMBER | Last refresh number of the collection cycle that collected Trip. | |||
| ORG_LRN | NUMBER | Last refresh number of the collection cycle that collected Organization entity. | |||
| DP_ENABLED_FLAG | NUMBER | Organization enabled for demand planning. | |||
| LAST_SUCC_ASL_REF_TIME | DATE | Time stamp of the collection cycle that collected ASL entity successfully. | |||
| LAST_SUCC_ITEM_REF_TIME | DATE | Time stamp of the collection cycle that collected Item entity successfully. | |||
| ORGANIZATION_TYPE | NUMBER | This value indicates the type of organization. | |||
| ERO_LRN | NUMBER | Last refresh number of the collection cycle that collected ERO entity. | |||
| IRO_LRN | NUMBER | Last refresh number of the collection cycle that collected IRO entity. | |||
| LAST_SUCC_IRO_REF_TIME | DATE | Time stamp of the collection cycle that collected IRO entity successfully. | |||
| LAST_SUCC_RES_REF_TIME | DATE | Time stamp of the collection cycle that collected Resources entity successfully. | |||
| SR_ORGANIZATION_CODE | VARCHAR2 | 18 | Yes | Organization Code at source instance | |
| SR_ORGANIZATION_ID | NUMBER | Organization Identifier at source instance. | |||
| FULFILLMENT_INSTANCE_FLAG | NUMBER | Flag to indicate the instance mapped is fulfillment instance or not, for that organization. 1 - Yes 2- No | |||
| INVENTORY_FLAG | VARCHAR2 | 1 | Specifies the type of the org Y - Inventory Org N - Item Org | ||
| DROP_SHIP_VAL_ORG_FLAG | NUMBER | 1 | Flag to indicate the drop ship validation org. 1 - Yes 2- No | ||
| ALLOW_EXT_INV_FLAG | NUMBER | Flag that indicates if FBDI upload of Fusion source data is allowed for Inventory related entity (Onhand). Valid values are 1(Yes), 2(No) and Null (same as No). | |||
| ALLOW_EXT_PRC_FLAG | NUMBER | Flag that indicates if FBDI upload of Fusion source data is allowed for Purchasing related entities (PORD/PREQ/INTRST/POINRCV). Valid values are 1(Yes), 2(No) and Null (same as No). | |||
| ALLOW_EXT_FOM_FLAG | NUMBER | Flag that indicates if FBDI upload of Fusion source data is allowed for Order Management related entities (SO/Reservation). Valid values are 1(Yes), 2(No) and Null (same as No). | |||
| ALLOW_EXT_WIE_FLAG | NUMBER | Flag that indicates if FBDI upload of Fusion source data is allowed for Work Order Execution related entities (WOSUP/WRES/WCOMP/BYPROD). Valid values are 1(Yes), 2(No) and Null (same as No). | |||
| ALLOW_EXT_WIS_FLAG | NUMBER | Flag that indicates if FBDI upload of Fusion source data is allowed for Work Order Setup related entities (BOM/BOMCOMP/COMPSUBS/RTNG/RTGOPR/RESRC/RESAVL). Valid values are 1(Yes), 2(No) and Null (same as No). | |||
| ALLOW_EXT_LOG_FLAG | NUMBER | Flag that indicates if FBDI upload of Fusion source data is allowed for Logistics related entity (TO). Valid values are 1(Yes), 2(No) and Null (same as No). | |||
| PARENT_SR_ORGANIZATION_ID | NUMBER | Organization Identifier of parent organization at source instance. | |||
| PARENT_SR_ORGANIZATION_CODE | VARCHAR2 | 18 | Organization Code of parent organization at source instance. | ||
| MODELED_SUBINVENTORY_CODE | VARCHAR2 | 10 | Modeled Subinventory code for child organization. | ||
| PARENT_ORGANIZATION_ID | NUMBER | Organization Identifier of parent organization in the Planning System. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MSC_INSTANCE_ORGS | msc_apps_instances | SR_INSTANCE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| MSC_INSTANCE_ORGS_N1 | Non Unique | Default | SR_INSTANCE_ID, SR_ORGANIZATION_ID | |
| MSC_INSTANCE_ORGS_N2 | Non Unique | Default | ORGANIZATION_ID, FULFILLMENT_INSTANCE_FLAG, SR_INSTANCE_ID | |
| MSC_INSTANCE_ORGS_U1 | Unique | Default | SR_INSTANCE_ID, SR_ORGANIZATION_CODE | |
| MSC_INSTANCE_ORGS_U2 | Unique | Default | ORGANIZATION_CODE | Obsolete |