MSC_SR_RECEIPT_ORG
MSC_SR_RECEIPT_ORG stores information on the receiving organizations for Sourcing Rules and Bills of Distribution. Each row in this table specifies a receiving organization for a date range. This table is a child of MSC_SOURCING_RULES. In case of Local Sourcing Rules the column RECEIPT_ORGANIZATION_ID is the same as the ORGANIZATION_ID in MSC_SOURCING_RULES. For Global Sourcing Rules the column RECEIPT_ORGANIZATION_ID is Null. This table is populated by the Define Sourcing Rule and Define Bills of distribution forms of Oracle Supply Chain Planning at planning server. This table also stores information on the receiving organizations for Sourcing Rules and Bills Of Distribution defined from source applications.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
MSC_SR_RECEIPT_ORG_PK |
SR_RECEIPT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| SR_RECEIPT_ID | NUMBER | 18 | Yes | Unique identifier for a row generated at planning server | ||
| SOURCING_RULE_NAME | VARCHAR2 | 80 | Name of the sourcing rule used in supply chain sourcing. | |||
| ORGANIZATION_ID | NUMBER | 18 | ORGANIZATION ID | |||
| SR_INSTANCE_ID | NUMBER | 18 | Source application instance identifier | Obsolete | ||
| SR_RECEIPT_ORG | NUMBER | 18 | Source application Sr Receipt identifier | |||
| SR_SR_RECEIPT_ID | NUMBER | 18 | This indicates the source side value of the Apps instance sr_receipt_id. | |||
| SOURCING_RULE_ID | NUMBER | Yes | Sourcing rule/Bill of Distribution identifier | |||
| RECEIPT_PARTNER_ID | NUMBER | This value indicates the Trading partner identifier. | ||||
| RECEIPT_PARTNER_SITE_ID | NUMBER | Trading partner site identifier | ||||
| EFFECTIVE_DATE | DATE | Yes | Effective date of the receipt orgs. | |||
| DISABLE_DATE | DATE | Disable date of the sourcing rule effectivity. | ||||
| DELETED_FLAG | NUMBER | Flag to indicate whether the row is no longer valid. | ||||
| 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 populated by the collection program | ||||
| RECEIPT_ORG_INSTANCE_ID | NUMBER | 18 | Source application instance identitifer associated with the receiving org | Obsolete | ||
| COLLECTED_FLAG | NUMBER | Flag indicating whether the row is collected from source application instance | ||||
| 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. | ||
| UPGRADED_FLAG | NUMBER | 4 | Flag to indicate data upgrade status | |||
| SUB_INVENTORY_ID | NUMBER | 18 | This column contains Subinventory Id. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MSC_SR_RECEIPT_ORG | msc_sourcing_rules | SOURCING_RULE_ID |
| msc_sr_source_org | msc_sr_receipt_org | SR_RECEIPT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| MSC_SR_RECEIPT_ORG_N1 | Non Unique | Default | SOURCING_RULE_ID, SR_RECEIPT_ORG, EFFECTIVE_DATE | |
| MSC_SR_RECEIPT_ORG_N3 | Non Unique | Default | SOURCING_RULE_ID, COLLECTED_FLAG | |
| MSC_SR_RECEIPT_ORG_U1 | Unique | Default | SR_RECEIPT_ID, COLLECTED_FLAG | Obsolete |
| MSC_SR_RECEIPT_ORG_U2 | Unique | Default | SR_SR_RECEIPT_ID, COLLECTED_FLAG | Obsolete |
| MSC_SR_RECEIPT_ORG_U3 | Unique | Default | SOURCING_RULE_ID, SR_RECEIPT_ORG, EFFECTIVE_DATE, COLLECTED_FLAG | Obsolete |
| MSC_SR_RECEIPT_ORG_U4 | Unique | Default | SR_RECEIPT_ID |