INV_SUBINV_MASS_MAINT_ACTIONS
INV_SUBINV_MASS_MAINT_ACTIONS stores the mass maintenance action taken on any of the objects namely subinventory, locator, items associated with subinventory and locator. Actions that can be performed are CREATE, UPDATE and COPY. For COPY action, the table will have as many rows as the number of subinventories or locators being created by copying from the existing subinventory or locator. For UPDATE action this table will just have the high-level details of the action to be performed and the object name on which this action has to be performed and then the details will be available in the respective detail tables.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
INV_SUBINV_MASS_MAINT_PK |
MASS_MAINT_ACTION_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
MASS_MAINT_ACTION_ID | NUMBER | 18 | Yes | Primary key to uniquely identify the mass maintenance action. | |
ORGANIZATION_ID | NUMBER | 18 | Yes | Value that uniquely identifies the organization for which the mass maintenance action is performed. | |
GROUP_ID | NUMBER | 18 | This identifies a group of records submitted as part of a single task. | ||
ACTION_CODE | VARCHAR2 | 18 | Yes | Abbreviation that identifies the mass maintenance action to be taken. Possible values are CREATE, UPDATE and COPY. | |
OBJECT_TYPE | VARCHAR2 | 30 | Yes | Abbreviation that identifies the object type on which the action needs to be taken. Possible values are SUBINVENTORY, LOCATOR, ITEM_SUBINVENTORY, and ITEM_LOCATOR. | |
COPY_PARENT_OBJECT_NAME | VARCHAR2 | 10 | Name of the subinventory where new locators are created from an existing locator. | ||
COPY_FROM_OBJECT_NAME | VARCHAR2 | 1000 | Name of the source object used for creating new subinventories or locators from an existing subinventory or locator. | ||
COPY_TO_OBJECT_NAME | VARCHAR2 | 1000 | Name of the destination object used while creating new subinventories or locators from an existing subinventory or locator. | ||
COPY_TO_OBJECT_DESCRIPTION | VARCHAR2 | 50 | Description of the destination object used while creating new subinventories or locators from an existing subinventory or locator. | ||
INCLUDE_LOCATOR_COPY | VARCHAR2 | 1 | Indicates whether we need to copy the locators from the source object to the new object while creating subinventories. Possible values are Y or N. | ||
INCLUDE_ITEM_SUB_COPY | VARCHAR2 | 1 | Indicates whether we need to copy the items associated with the subinventory from the source object to the new object while creating subinventories. Possible values are Y or N. | ||
INCLUDE_ITEM_LOC_COPY | VARCHAR2 | 1 | Indicates whether we need to copy the items associated with the locator from the source object to the new object while creating subinventories and locators. Possible values are Y or N. | ||
PROCESSING_STATUS_CODE | VARCHAR2 | 30 | Yes | Abbreviation that indicates the status of the mass update operation submitted. Possible values are Submitted, In-Progress, Completed and Error. | |
RECORDS_SUBMITTED_COUNT | NUMBER | 18 | Count of records submitted for processing. | ||
RECORDS_SUCCESSFUL_COUNT | NUMBER | 18 | Count of records processed successfully. | ||
RECORDS_FAILED_COUNT | NUMBER | 18 | Count of records errored during processing. | ||
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. | |
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
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. | ||
ERROR_CODE | VARCHAR2 | 30 | Error message code for the failure during maintenance action for subinventories and locators. | ||
ERROR_EXPLANATION | VARCHAR2 | 240 | Error message text for the failure during maintenance action for subinventories and locators. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
INV_SUBINV_MASS_MAINT_N1 | Non Unique | FUSION_TS_TX_DATA | ORGANIZATION_ID, GROUP_ID, PROCESSING_STATUS_CODE |
INV_SUBINV_MASS_MAINT_N2 | Non Unique | FUSION_TS_TX_DATA | TRUNC("CREATION_DATE") |
INV_SUBINV_MASS_MAINT_U1 | Unique | FUSION_TS_TX_DATA | MASS_MAINT_ACTION_ID |