INV_ATTR_UPDATE_LINES
This table stores the details needed to execute the inventory attribute update requests in Oracle Fusion Inventory. Oracle Fusion Supply Chain Planning provides the REQUESTED_QUANTITY, PROJECT_ID, TASK_ID, TRANSFER_PROJECT_ID, and TRANSFER_TASK_ID. The requests are created in an Open status and processed in an Online processing mode when invoked from Supply Chain Planning. The requests can be created to process in Online, Concurrent, or Background processing modes using an Inventory Attribute Transaction Requests REST resource. Inventory determines the material to use to execute the project transfer and updates the TRANSFER_QUANTITY when the project transfer is executed. Inventory also determines the subinventory, locator, revision, lot numbers, and serial numbers based on the FIFO (First in, First Out) logic to execute the project transfer requests and populates the INV_TRANSACTIONS_INTERFACE, INV_TRANSACTION_LOTS_INTERFACE, and INV_SERIAL_NUMBERS_INTERFACE tables. The request moves to a Closed status when the project transfer is executed or when material to execute the project transfer isn't available.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
INV_ATTR_UPDATE_LINES_PK |
LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LINE_ID | NUMBER | 18 | Yes | Inventory Attribute Update Request line unique identifier. | |
| LINE_NUMBER | NUMBER | 9 | Yes | Sequence generated Inventory Attribute Update Request line number. | |
| HEADER_ID | NUMBER | 18 | Yes | Inventory Attribute Uptadate Header. Unique Identifier. Primary key. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | This identifies the inventory organization. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | This identifies the inventory item. | |
| PROJECT_ID | NUMBER | 18 | Source Project Identifier of the project transfer request. | ||
| TASK_ID | NUMBER | 18 | Source Task Identifier of the project transfer request. | ||
| TRANSFER_PROJECT_ID | NUMBER | 18 | Destination Project Identifier of the project transfer request. | ||
| TRANSFER_TASK_ID | NUMBER | 18 | Destination Task Identifier of the project transfer request. | ||
| REQUESTED_QUANTITY | NUMBER | Yes | This is the quantity requested for update of the attribute. | ||
| REQUESTED_UOM_CODE | VARCHAR2 | 3 | Yes | The working unit of measure for this transaction. | |
| TRANSFER_QUANTITY | NUMBER | This is the quantity transfered. | |||
| SECONDARY_REQUESTED_QUANTITY | NUMBER | Requested Quantity in the Secondary Unit Of Measure. | |||
| SECONDARY_UOM_CODE | VARCHAR2 | 3 | Secondary Unit Of Measure Code used to do the project transfer request. | ||
| SECONDARY_TRANSFER_QUANTITY | NUMBER | Transferred Quantity in the Secondary Unit Of Measure. | |||
| STATUS_LOOKUP | VARCHAR2 | 30 | Yes | Indicates whether the line is OPEN/CLOSED/CANCELLED/IN PROGRESS/ERROR. | |
| SOURCE_LINE_ID | NUMBER | 18 | Source line identifier (Supply Order Line Id for project transfer initiated by Fusion SCO). | ||
| 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. | ||
| 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. | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | 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_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. | |||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| INV_ATTR_UPDATE_LINES | inv_attr_update_headers | HEADER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| INV_ATTR_UPDATE_LINES_U3 | Unique | FUSION_TS_TX_IDX | LINE_ID | |
| INV_ATTR_UPDATE_LINES_U4 | Unique | FUSION_TS_TX_IDX | HEADER_ID, LINE_NUMBER | |
| inv_attr_update_lines_U1 | Unique | Default | LINE_ID | Obsolete |
| inv_attr_update_lines_U2 | Unique | Default | HEADER_ID, LINE_NUMBER | Obsolete |