MSC_SR_SOURCE_ORG
MSC_SR_SOURCE_ORG stores the source organizations or source suppliers for Sourcing Rules or Bills of distribution. This table is a child of MSC_SR_RECEIPT_ORG. This table is populated by the Define Sourcing Rules and Define Bills of distribution form of Oracle Supply Chain Planning at planning server. This table also stores the sourcing information defined from source applications.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
MSC_SR_SOURCE_ORG_PK |
SR_SOURCE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| SR_SOURCE_ID | NUMBER | 18 | Yes | Unique identifier for a certain row | ||
| SOURCING_RULE_NAME | VARCHAR2 | 80 | Name of the sourcing rule used in supply chain sourcing. | |||
| SR_SR_SOURCE_ID | NUMBER | 18 | Unique identifier for a row from the source application instance | |||
| EFFECTIVE_DATE | DATE | Effective date of the source orgs. | ||||
| RECEIPT_ORG_INSTANCE_ID | NUMBER | 18 | This value indicates the Receipt organization source system identifier. | Obsolete | ||
| SR_RECEIPT_ORG | NUMBER | 18 | Source side value of the Receipt organization in the sourcing. | |||
| ORGANIZATION_ID | NUMBER | 18 | ORGANIZATION ID | |||
| SR_RECEIPT_ID | NUMBER | Yes | Identifier from the sourcing rule receipt org | |||
| SOURCE_PARTNER_ID | NUMBER | 18 | This value indicates the Source supplier identifier. | |||
| SOURCE_PARTNER_SITE_ID | NUMBER | 18 | Source supplier site identifier | |||
| CARRIER_ID | NUMBER | 38 | Unique identifier for the carrier | |||
| MODE_OF_TRANSPORT | NUMBER | 18 | MODE_OF_TRANSPORT | |||
| SERVICE_LEVEL | NUMBER | 18 | Service level specified in the shipping method. | |||
| ALLOCATION_PERCENT | NUMBER | Percent of supply allocated to this source | ||||
| RANK | NUMBER | This value indicates the Rank of the record. | ||||
| SHIP_METHOD | VARCHAR2 | 30 | Shipping method used to move the material. | |||
| SOURCE_TYPE | NUMBER | Flag indicating the source type | ||||
| SR_INSTANCE_ID | NUMBER | 18 | Source instance id for the source organization | Obsolete | ||
| DELETED_FLAG | NUMBER | Flag to indicate whether the row is no longer valid. SYS_YES means the row will be deleted | ||||
| SOURCE_ORGANIZATION_ID | NUMBER | 18 | This value indicates the Source organization identifier. | |||
| SOURCE_ORG_INSTANCE_ID | NUMBER | 18 | Source intance identifier of the source organization identifier | Obsolete | ||
| 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. | |||
| REFRESH_NUMBER | NUMBER | Refresh number assigned by collection proram | ||||
| REPLENISHMENT_TYPE | NUMBER | Indicate type of replenishment. Null/0 = Force Transfer; 1 = Partial transfer; 2 = Full transfer | ||||
| MIN_TRANSFER_QTY | NUMBER | Minimum transfer quantity specified while defining the sourcing. | ||||
| MAX_TRANSFER_QTY | NUMBER | Maximum transfer quantity | ||||
| TRANSFER_LOT_MULTIPLE | NUMBER | This value indicates the Transfer lot multiple. | ||||
| FIXED_TRANSFER_QTY | NUMBER | This value indicates the fixed transfer quantity. | ||||
| TRANSFER_TYPE | NUMBER | This value indicates the Transfer type specified in the sourcing. | ||||
| COLLECTED_FLAG | NUMBER | Flag indicates whether the row is collected from source | ||||
| CIRCULAR_SRC | VARCHAR2 | 1 | Y if sourcing rule is a circular sourcing rule | |||
| FROM_REGION_ID | NUMBER | Origin region or zone identifier | ||||
| CIRCULAR_SRC_RANK | NUMBER | Rank for source for a circular sourcing | ||||
| 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. | ||
| FROM_QTY | NUMBER | From Quantity. This is the initial value of quantity in the Qty based sourcing setup. | ||||
| TO_QTY | NUMBER | To Quantity of the Quantity type sourcing rule. | ||||
| QTY_UOM | VARCHAR2 | 3 | Quantity unit of measure specified in the sourcing. | |||
| SOURCE_PARTNER_SITE_CODE | VARCHAR2 | 15 | source partner site code identifier | |||
| RELEASE_TO_INSTANCE_ID | NUMBER | 18 | The source instance to which the supply data is released. | |||
| 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_SOURCING_RULES. | |||
| CREATE_MOVEMENT_REQUEST | NUMBER | This column identifies whether to create a movement request or Transfer order between subinventories of the same org. Relevant for Replenishment planning. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MSC_SR_SOURCE_ORG | msc_sr_receipt_org | SR_RECEIPT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_SR_SOURCE_ORG_N1 | Non Unique | Default | SR_SR_SOURCE_ID, COLLECTED_FLAG |
| MSC_SR_SOURCE_ORG_N3 | Non Unique | Default | SR_RECEIPT_ID, SOURCE_ORGANIZATION_ID, SOURCE_PARTNER_ID, SOURCE_PARTNER_SITE_ID |
| MSC_SR_SOURCE_ORG_U1 | Unique | Default | SR_SOURCE_ID, COLLECTED_FLAG |
| MSC_SR_SOURCE_ORG_U2 | Unique | Default | SR_SOURCE_ID |