SCH_PR_ITEM_LOC_DEFAULTS
This table stores the item transaction defaults for the replacement item during the item replacement process. It also archives the item transaction default records for the disrupted item when replacement method is set to Alternate Supplier.
Details
-
Schema: FUSION
-
Object owner: SCH
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
SCH_PR_ITEM_LOC_DEFAULTS_PK |
TRANSACTION_DEFAULTS_ID, REPLACEMENT_DETAIL_ID, ARCHIVE_FLAG, ACTION |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
TRANSACTION_DEFAULTS_ID | NUMBER | 18 | Yes | Primary key of the optional default locator. | |
REPLACEMENT_DETAIL_ID | NUMBER | 18 | Yes | Replacement Details Unique Identifier. | |
ARCHIVE_FLAG | VARCHAR2 | 1 | Yes | Indicates the item subinventory records with original attributes archived for reinstatement purpose during item replacement. | |
ACTION | VARCHAR2 | 30 | Yes | Indicates the action for which the item transaction default record is created or updated. | |
INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Indicates the inventory item identifier of the original item that undergoes item replacement. | |
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. | |
DEFAULT_TYPE | VARCHAR2 | 30 | Yes | Code indicates the default type. | |
SUBINVENTORY_CODE | VARCHAR2 | 10 | Yes | Indicates the subinventory of the original item which undergoes item replacement. | |
LOCATOR_ID | NUMBER | 18 | Yes | This identifies the item locator. | |
ORGANIZATION_ID | NUMBER | 18 | Yes | Indicates the inventory organization identifier for which item transaction defaults undergo item replacement. | |
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. | |
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. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
SCH_PR_ITEM_LOC_DEFAULTS | SCH_PR_REPLACEMENTS | REPLACEMENT_DETAIL_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
SCH_PR_ITEM_LOC_DEFAULTS_U1 | Unique | Default | TRANSACTION_DEFAULTS_ID, REPLACEMENT_DETAIL_ID, ARCHIVE_FLAG, ACTION |
SCH_PR_ITEM_LOC_DEFAULTS_U2 | Unique | Default | INVENTORY_ITEM_ID, ORGANIZATION_ID, SUBINVENTORY_CODE, LOCATOR_ID, DEFAULT_TYPE, ARCHIVE_FLAG, REPLACEMENT_DETAIL_ID, ACTION |