SCH_PR_REPLACEMENT_DETAILS
This table contains the details of impacted inventory organizations that undergoes replacement and reinstatement which includes the replacement options such as alternate supplier, alternate item, corresponding source document and Requisitioning Business Unit. It also indicates the status of mass replacement actions and replacement period at individual organization level.
Details
-
Schema: FUSION
-
Object owner: SCH
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
SCH_PR_REPLACEMENT_DETAILS_PK |
REPLACEMENT_DETAIL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REPLACEMENT_ID | NUMBER | 18 | Yes | Unique Identifier for a replacement instance initiated for a combination of supplier, supplier site and item in a procurement business unit. | |
| GROUP_ID | NUMBER | 18 | Indicates the grouping of impacted organizations for a replacement task. | ||
| REPLACEMENT_DETAIL_ID | NUMBER | 18 | Yes | Replacement Details Unique Identifier. | |
| DETAIL_STATUS | VARCHAR2 | 30 | Yes | Indicates if the replacement at organization level is Pending or Replaced or Reinstated or Replacement in progress or Reinstate in progress. | |
| REPLACEMENT_REQUEST_ID | NUMBER | 18 | Request Id of the replacement action. | ||
| REINSTATE_REQUEST_ID | NUMBER | 18 | Request Id of the reinstate action. | ||
| ORGANIZATION_ID | NUMBER | 18 | Yes | Inventory organization unique identifier for which unfulfilled purchase order lines exist or replenishment attributes must be updated. | |
| REQUISITIONING_BU_ID | NUMBER | 18 | Yes | Requisitioning business unit unique identifier. | |
| SOURCE_DOCUMENT_NUMBER | VARCHAR2 | 30 | Blanket purchase agreement number that acts as a source document to replace purchase order lines or update replenishment attributes. | ||
| SOURCE_DOCUMENT_LINE_NUMBER | NUMBER | Blanket purchase agreement line number that acts as a source document line to replace purchase order lines or update replenishment attributes. | |||
| REINSTATE_SRC_DOC_NUM | VARCHAR2 | 30 | Blanket purchase agreement number that acts as a source document to replace purchase order lines during reinstate action or reinstate replenishment attributes. | ||
| REINSTATE_SRC_DOC_LINE_NUM | NUMBER | Blanket purchase agreement line number that acts as a source document line to replace purchase order lines during reinstate action or reinstate replenishment attributes. | |||
| ALT_VENDOR_ID | NUMBER | 18 | Unique identifier for the alternate supplier that replaces the primary supplier for which replacement instance is initiated. | ||
| ALT_VENDOR_SITE_ID | NUMBER | 18 | Unique identifier for the alternate supplier site that replaces the primary supplier site for which replacement instance is initiated. | ||
| SUBSTITUTE_ITEM_ID | NUMBER | 18 | Unique identifier for the substitute item that replaces the primary item for which replacement instance is initiated. | ||
| SUBSTITUTE_MPN_ID | NUMBER | 18 | Unique identifier for the substitute manufacturer part number that replaces the primary item for which replacement instance is initiated. | ||
| SUBSTITUTE_TYPE | VARCHAR2 | 30 | Yes | Indicates if the replacement is by supplier or item. | |
| REPLACEMENT_REP_NOTIFY_FLAG | VARCHAR2 | 1 | Yes | Indicates if the notification is sent to update the replenishment attributes or not for replacement. | |
| REINSTATE_REP_NOTIFY_FLAG | VARCHAR2 | 1 | Yes | Indicates if the notification is sent to reinstate the replenishment attributes or not. | |
| REPLACEMENT_START_DATE | DATE | Date when the mass replacement is initiated for the first time for an organization. | |||
| REPLACEMENT_END_DATE | DATE | Date when the mass reinstatement is initiated for the first time for an organization. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| 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. | |
| 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_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. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 80 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| DETAIL_INV_STATUS | VARCHAR2 | 30 | This status should be visible only for the planner, indicates if the replacement at organization level is Pending or Replaced or Reinstated or No Change Required. | ||
| COPY_FROM_DISRUPTED_TXN_FLAG | VARCHAR2 | 1 | Indicates whether to create new item transaction default for the replacement item just by copying all the attributes from the original item through the mass replacement process. | ||
| COPY_FROM_DISRUPTED_ITEM_FLAG | VARCHAR2 | 1 | Indicates whether to create new item subinventories for the replacement item just by copying all the replenishment attributes, subinventories and stock locators from the original item subinventories through the mass replacement process. | ||
| REPLENISH_BY_INV_SOURCE_FLAG | VARCHAR2 | 1 | Indicates whether the subinventories to which the original item is associated that have the replenishment source as Organization or Subinventory should also be updated by the mass replacement process or not. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| SCH_PR_REPLACEMENT_DETAILS | SCH_PR_REPLACEMENTS | REPLACEMENT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SCH_PR_REPLACEMENT_DETAILS_N1 | Non Unique | Default | REPLACEMENT_ID, DETAIL_STATUS |
| SCH_PR_REPLACEMENT_DETAILS_N2 | Non Unique | Default | ORGANIZATION_ID, REQUISITIONING_BU_ID |
| SCH_PR_REPLACEMENT_DETAILS_N3 | Non Unique | Default | DETAIL_INV_STATUS |
| SCH_PR_REPLACEMENT_DETAILS_N4 | Non Unique | Default | GROUP_ID |
| SCH_PR_REPLACEMENT_DETAILS_U1 | Unique | Default | REPLACEMENT_DETAIL_ID |