MSC_SR_ASSIGNMENTS
MSC_SR_ASSIGNMENTS stores the assignment of sourcing rules or bills of distribution to items, organizations, category, or at the global level. This table is populated by the Assign Sourcing Rules form of Oracle Supply Chain Planning. This table is used by the Memory-based Snapshot to determine the sourcing information or an item in an organization. The Memory-based Snapshot uses the most granular ASSIGNMENT_LEVEL to determine the sourcing for an item-organization. This table also stores assignments defined from source applications.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
MSC_SR_ASSIGNMENTS_PK |
ASSIGNMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| ASSIGNMENT_ID | NUMBER | 18 | Yes | Sourcing rule/Bill of Distribution identifier | ||
| GEOGRAPHY_TYPE | VARCHAR2 | 30 | Geography type code for this rule | |||
| SOURCING_RULE_NAME | VARCHAR2 | 80 | Name of the sourcing rule used in supply chain sourcing. | |||
| SR_ASSIGNMENT_ID | NUMBER | 18 | Yes | Sourcing rule/Bills of Distribution identifier from source application instance | ||
| ASSIGNMENT_SET_NAME | VARCHAR2 | 80 | Name assigned to the assignment set | |||
| ASSIGNMENT_SET_ID | NUMBER | Yes | Unique Identifier of the assignment set | |||
| SOURCING_RULE_ID | NUMBER | Yes | Sourcing rule/Bill of Distribution identifier | |||
| SOURCING_RULE_TYPE | NUMBER | Sourcing rule type. This indicates whether it is a Bill of distribution or a Sourcing rule. | ||||
| ORGANIZATION_ID | NUMBER | 18 | Organization identifier | |||
| INVENTORY_ITEM_ID | NUMBER | 18 | Identifies the inventory item id | |||
| PARTNER_ID | NUMBER | 18 | Contains CustomerId. Maps to MSC_SR_ASSIGNMENTS.PARTNER_ID | |||
| SHIP_TO_SITE_ID | NUMBER | 18 | Identifier of the party/partner where the shipment if headed for. | |||
| CATEGORY_SET_ID | NUMBER | 18 | Unique identifier for the category set | |||
| CATEGORY_NAME | VARCHAR2 | 250 | Name assigned to the item category | |||
| CATEGORY_ID | NUMBER | 18 | Unique identifier for the category | |||
| SR_INSTANCE_ID | NUMBER | 18 | Source application instance identifier of item org | Obsolete | ||
| DELETED_FLAG | NUMBER | Flag to indicate whether the row is no longer valid. SYS_YES means the row will be deleted | ||||
| 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. | |||
| PROGRAM_UPDATE_DATE | DATE | This value indicates the update date of the program. | ||||
| 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. | |||
| ASSIGNMENT_TYPE | NUMBER | Yes | Sourcing Assignment type for the item. | |||
| REFRESH_NUMBER | NUMBER | Refresh number populated by the collection program | ||||
| SR_ASSIGNMENT_INSTANCE_ID | NUMBER | 18 | Source application instance identifier of the assignment record | |||
| COLLECTED_FLAG | NUMBER | Flag indicates whether the row is collected from source | ||||
| REGION_ID | NUMBER | 18 | Region identifier that is specified in the sourcing assignment. | |||
| REGION_ZONE_FLAG | VARCHAR2 | 1 | This flag indicates whether the geography is marked as Region or Zone. | |||
| ALLOCATION_RULE_ID | NUMBER | 18 | Identifier to the allocation rule | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| DEMAND_CLASS_ID | NUMBER | 18 | Destination side demand class id | |||
| UPGRADED_FLAG | NUMBER | 4 | Flag to indicate data upgrade status | |||
| SUB_INVENTORY_ID | NUMBER | 18 | This column contains Subinventory Id for the Org when Plan Subinventories flag is set in MSC_ASSIGNMENT_SETS. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MSC_SR_ASSIGNMENTS | msc_sourcing_rules | SOURCING_RULE_ID |
| MSC_SR_ASSIGNMENTS | msc_assignment_sets | ASSIGNMENT_ID |
| msc_item_sourcing | msc_sr_assignments | ASSIGNMENT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| MSC_SR_ASSIGNMENTS_N1 | Non Unique | Default | ASSIGNMENT_TYPE, ASSIGNMENT_SET_ID | |
| MSC_SR_ASSIGNMENTS_N2 | Non Unique | Default | PARTNER_ID, SHIP_TO_SITE_ID, ASSIGNMENT_SET_ID, ASSIGNMENT_TYPE | |
| MSC_SR_ASSIGNMENTS_N3 | Non Unique | Default | ASSIGNMENT_SET_ID, ASSIGNMENT_TYPE, ORGANIZATION_ID, INVENTORY_ITEM_ID | |
| MSC_SR_ASSIGNMENTS_N4 | Non Unique | Default | SOURCING_RULE_ID | |
| MSC_SR_ASSIGNMENTS_N5 | Non Unique | Default | ASSIGNMENT_SET_ID, ASSIGNMENT_TYPE, CATEGORY_ID, CATEGORY_SET_ID | |
| MSC_SR_ASSIGNMENTS_N6 | Non Unique | Default | ASSIGNMENT_SET_ID, ASSIGNMENT_TYPE, INVENTORY_ITEM_ID | |
| MSC_SR_ASSIGNMENTS_U1 | Unique | Default | ASSIGNMENT_ID, COLLECTED_FLAG | |
| MSC_SR_ASSIGNMENTS_U2 | Unique | Default | SR_ASSIGNMENT_INSTANCE_ID, SR_ASSIGNMENT_ID, COLLECTED_FLAG | Obsolete |
| MSC_SR_ASSIGNMENTS_U3 | Unique | Default | ASSIGNMENT_ID |