[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSC_ST_ITEM_SOURCING |
|---|---|
| Object Type: | TABLE |
| Owner: | MSC |
| FND Design Data: |  MSC.MSC_ST_ITEM_SOURCING
|
| Subobject Name: | |
| Status: | VALID |
This is a denormalized table for staging Sourcing Rules related data from Legacy Instances.
The data in this table would be processed by the 'Pre-Processor' and sent to MSC_ST_ASSIGNMENT_SETS, MSC_ST_SR_ASSIGNMENTS, MSC_ST_SOURCING_RULES, MSC_ST_SR_RECEIPT_ORG and MSC_ST_SR_SOURCE_ORG. ODS Load would then transfer the data from these five staging tables to corresponding ODS tables.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SR_SOURCE_ID | NUMBER | Source Id | ||
| SR_RECEIPT_ID | NUMBER | Receipt Id | ||
| REFRESH_ID | NUMBER | Refresh Id | ||
| ASSIGNMENT_ID | NUMBER | Assignment Id | ||
| SOURCING_RULE_ID | NUMBER | Sourcing Rule Id | ||
| ASSIGNMENT_SET_ID | NUMBER | Assignment Set Id | ||
| CATEGORY_ID | NUMBER | Category Id | ||
| CATEGORY_SET_ID | NUMBER | Category Set Id | ||
| INVENTORY_ITEM_ID | NUMBER | Inventory Item Id | ||
| ORGANIZATION_ID | NUMBER | Organization ID | ||
| SR_INSTANCE_ID | NUMBER | Instance ID | ||
| RECEIPT_ORGANIZATION_ID | NUMBER | Receipt Organization Id | ||
| RECEIPT_ORG_INSTANCE_ID | NUMBER | Receipt Organization Instance | ||
| EFFECTIVE_DATE | DATE | Effectivity date | ||
| DISABLE_DATE | DATE | Disable date | ||
| SOURCE_ORGANIZATION_ID | NUMBER | Source Organization Id | ||
| SOURCE_ORG_INSTANCE_ID | NUMBER | Source organization instance identifier | ||
| SOURCE_PARTNER_ID | NUMBER | Source Partner Id | ||
| SOURCE_PARTNER_SITE_ID | NUMBER | Source Partner Site identifier | ||
| ALLOCATION_PERCENT | NUMBER | Percent of supply allocated to this source | ||
| RANK | NUMBER | Rank of source | ||
| SOURCE_TYPE | NUMBER | Type of source. Possible values 1- Transfer from, 2- Make it, 3- Buy From | ||
| DESCRIPTION | VARCHAR2 | (80) | sourcing/assignment description | |
| PLANNING_ACTIVE | NUMBER | Flag indicates whether the row is planning active. Possible values 1- Yes and 2-No | ||
| SHIP_METHOD | VARCHAR2 | (30) | Ship method | |
| ASSIGNMENT_TYPE | NUMBER | Assignment Set Type. Possible values 1- Global, 2- Category, 3- Item, 4- Organization, 5- Category-Org, 6- Item_Org | ||
| ITEM_NAME | VARCHAR2 | (250) | Item name | |
| CATEGORY_NAME | VARCHAR2 | (163) | Category name | |
| ORGANIZATION_CODE | VARCHAR2 | (7) | Organization code | |
| SR_INSTANCE_CODE | VARCHAR2 | (3) | Source instance code | |
| RECEIPT_ORGANIZATION_CODE | VARCHAR2 | (7) | Receipt Organization Code | |
| RECEIPT_ORG_INSTANCE_CODE | VARCHAR2 | (3) | Receipt Organization Instance Code | |
| SOURCE_ORGANIZATION_CODE | VARCHAR2 | (7) | Source Organization Code | |
| SOURCE_ORG_INSTANCE_CODE | VARCHAR2 | (3) | Source Organization Instance Code | |
| SOURCE_PARTNER_NAME | VARCHAR2 | (255) | Source Partner Name | |
| SOURCE_PARTNER_SITE_CODE | VARCHAR2 | (30) | Source Partner Site Code | |
| SOURCING_RULE_NAME | VARCHAR2 | (80) | Sourcing Rule Name | |
| ASSIGNMENT_SET_NAME | VARCHAR2 | (34) | Assignment Set Name | |
| DELETED_FLAG | NUMBER | Deleted Flag | ||
| MESSAGE_ID | NUMBER | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XMLl | ||
| ERROR_TEXT | VARCHAR2 | (2000) | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error | |
| PROCESS_FLAG | NUMBER | Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed | ||
| BATCH_ID | NUMBER | Batch identifier generated during pre-processing. | ||
| DATA_SOURCE_TYPE | VARCHAR2 | (15) | Source Type indicating the source of the records | |
| ST_TRANSACTION_ID | NUMBER | Transaction ID generated during pre-processing to uniquely identify a record in the staging table | ||
| LAST_UPDATED_BY | NUMBER | Standard WHO Column | ||
| LAST_UPDATE_DATE | DATE | Standard WHO Column | ||
| CREATED_BY | NUMBER | Standard WHO Column | ||
| CREATION_DATE | DATE | Standard WHO Column | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard WHO Column | ||
| REQUEST_ID | NUMBER | Concurrent WHO column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent WHO column | ||
| PROGRAM_ID | NUMBER | Concurrent WHO column | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent WHO column | ||
| COMPANY_NAME | VARCHAR2 | (255) | Company Name | |
| COMPANY_ID | NUMBER | Company Id | ||
| SOURCE_ORG_ID | NUMBER | This is the Organization ID for the Organization in the legacy(source) system.This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||
| SOURCE_RECEIPT_ORGANIZATION_ID | NUMBER | This is the Receipt Organization ID for the Receipt Organization in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||
| SOURCE_INVENTORY_ITEM_ID | NUMBER | This is the Inventory Item ID for the Item in the legacy(source) system.This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||
| SOURCE_CATEGORY_SET_ID | NUMBER | This is the Category Set ID for the Category Set in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||
| SOURCE_CATEGORY_ID | NUMBER | This is the Category ID for the Category in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||
| SOURCE_SOURCE_PARTNER_ID | NUMBER | This is the Trading Partner ID for the Trading Partner in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||
| SOURCE_SOURCE_PARTNER_SITE_ID | NUMBER | This is the Trading Partner Site ID for the Trading Partner Site in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||
| SOURCE_SOURCE_ORGANIZATION_ID | NUMBER | This is the Organization ID for the Sourcing Organization in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||
| SOURCE_SOURCING_RULE_ID | NUMBER | This is the Sourcing Rule ID for the Sourcing Rule in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||
| SOURCE_ASSIGNMENT_SET_ID | NUMBER | This is the Assignment Set ID for the Assignment Set in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||
| SOURCE_SR_RECEIPT_ID | NUMBER | This is the Receipt ID for the Receipt in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||
| SOURCE_SR_SOURCE_ID | NUMBER | This is the Organization Line ID for the Organization Line in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||
| SOURCE_ASSIGNMENT_ID | NUMBER | This is the Assignment ID for the Assignment in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. |
Cut, paste (and edit) the following text to query this object:
SELECT SR_SOURCE_ID
, SR_RECEIPT_ID
, REFRESH_ID
, ASSIGNMENT_ID
, SOURCING_RULE_ID
, ASSIGNMENT_SET_ID
, CATEGORY_ID
, CATEGORY_SET_ID
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, SR_INSTANCE_ID
, RECEIPT_ORGANIZATION_ID
, RECEIPT_ORG_INSTANCE_ID
, EFFECTIVE_DATE
, DISABLE_DATE
, SOURCE_ORGANIZATION_ID
, SOURCE_ORG_INSTANCE_ID
, SOURCE_PARTNER_ID
, SOURCE_PARTNER_SITE_ID
, ALLOCATION_PERCENT
, RANK
, SOURCE_TYPE
, DESCRIPTION
, PLANNING_ACTIVE
, SHIP_METHOD
, ASSIGNMENT_TYPE
, ITEM_NAME
, CATEGORY_NAME
, ORGANIZATION_CODE
, SR_INSTANCE_CODE
, RECEIPT_ORGANIZATION_CODE
, RECEIPT_ORG_INSTANCE_CODE
, SOURCE_ORGANIZATION_CODE
, SOURCE_ORG_INSTANCE_CODE
, SOURCE_PARTNER_NAME
, SOURCE_PARTNER_SITE_CODE
, SOURCING_RULE_NAME
, ASSIGNMENT_SET_NAME
, DELETED_FLAG
, MESSAGE_ID
, ERROR_TEXT
, PROCESS_FLAG
, BATCH_ID
, DATA_SOURCE_TYPE
, ST_TRANSACTION_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, COMPANY_NAME
, COMPANY_ID
, SOURCE_ORG_ID
, SOURCE_RECEIPT_ORGANIZATION_ID
, SOURCE_INVENTORY_ITEM_ID
, SOURCE_CATEGORY_SET_ID
, SOURCE_CATEGORY_ID
, SOURCE_SOURCE_PARTNER_ID
, SOURCE_SOURCE_PARTNER_SITE_ID
, SOURCE_SOURCE_ORGANIZATION_ID
, SOURCE_SOURCING_RULE_ID
, SOURCE_ASSIGNMENT_SET_ID
, SOURCE_SR_RECEIPT_ID
, SOURCE_SR_SOURCE_ID
, SOURCE_ASSIGNMENT_ID
FROM MSC.MSC_ST_ITEM_SOURCING;
MSC.MSC_ST_ITEM_SOURCING does not reference any database object
MSC.MSC_ST_ITEM_SOURCING is referenced by following:
MSC
MSC_ST_ITEM_SOURCING#
|
|
|
|