1. Tables and Views for SCM
  2. INV_SUBINV_MASS_MAINT_ACTIONS

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