1. Tables and Views for SCM
  2. INV_TXN_REQUEST_LINES

INV_TXN_REQUEST_LINES

The table INV_TXN_REQUEST_LINES stores all of the move order lines. The lines are requests to move some quantity of an item from a source location to a destination location or account. Each move order line must be tied to a specific move order header. When a line is detailed or pick released, the quantity detailed is updated appropriately and transaction lines are created in INV_MATERIAL_TXNS_TEMP. When the transaction lines are transacted, the quantity delivered is updated.

Details

  • Schema: FUSION

  • Object owner: INV

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

INV_TXN_REQUEST_LINES_PK

LINE_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping Status
HEADER_ID NUMBER 18 Yes This identifies the movement request. Active
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. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active
LINE_NUMBER NUMBER 18 Yes This is the movement request line number. Active
ORGANIZATION_ID NUMBER 18 Yes This identifies the inventory organization. Active
INVENTORY_ITEM_ID NUMBER 18 Yes This identifies the inventory item. Active
REVISION VARCHAR2 18 Revision of item if under revision control. Active
FROM_SUBINVENTORY_ID NUMBER 18 This column is not currently used. Active
FROM_SUBINVENTORY_CODE VARCHAR2 10 This indicates the subinventory to transact from. Active
FROM_LOCATOR_ID NUMBER 18 This indicates the original locator. Active
TO_SUBINVENTORY_CODE VARCHAR2 10 Name of the subinventory to transact to. Active
TO_SUBINVENTORY_ID NUMBER 18 Identifier of the subinventory. Not currently used. Active
TO_LOCATOR_ID NUMBER 18 Identifies the locator to transact to. Active
TO_ACCOUNT_ID NUMBER 18 Identifies the account to transact to. Active
LOT_NUMBER VARCHAR2 80 This number identifies an inventory lot. Active
SERIAL_NUMBER_START VARCHAR2 80 This is the first unit number in range. Active
SERIAL_NUMBER_END VARCHAR2 80 This is the last unit number in range. Active
UOM_CODE VARCHAR2 3 Yes Indicates the unit of measure for quantities. Active
QUANTITY NUMBER Yes This is the quantity requested. Active
QUANTITY_DELIVERED NUMBER Quantity which has been delivered Active
QUANTITY_DETAILED NUMBER Quantity which has a detailed sourcing location Active
DATE_REQUIRED DATE Yes This is the date when this is required. Active
REQUESTER_ID NUMBER 18 Reference to unique identifier of the requester.
REASON_ID NUMBER 18 This identifies the transaction reason. Active
REFERENCE_NAME VARCHAR2 240 Move order creator reference name Active
REFERENCE_TYPE_CODE NUMBER 18 This code indicates the movement request creator. Active
REFERENCE_ID NUMBER 18 This identifies the movement request creator. Active
TRANSACTION_HEADER_ID NUMBER 18 This identifies the transaction group and workers. Active
LINE_STATUS NUMBER 18 Yes This is the status of the movement request line. Active
STATUS_DATE DATE Yes The date when the status was last changed. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transfer Order Lines (INV_TXN_REQUEST_LINES) Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transfer Order Lines (INV_TXN_REQUEST_LINES) Active
LINE_ID NUMBER 18 Yes Primary key of the movement request line. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transfer Order Lines (INV_TXN_REQUEST_LINES) Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transfer Order Lines (INV_TXN_REQUEST_LINES) Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transfer Order Lines (INV_TXN_REQUEST_LINES) Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transfer Order Lines (INV_TXN_REQUEST_LINES) Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transfer Order Lines (INV_TXN_REQUEST_LINES) Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transfer Order Lines (INV_TXN_REQUEST_LINES) Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transfer Order Lines (INV_TXN_REQUEST_LINES) Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transfer Order Lines (INV_TXN_REQUEST_LINES) Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transfer Order Lines (INV_TXN_REQUEST_LINES) Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transfer Order Lines (INV_TXN_REQUEST_LINES) Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transfer Order Lines (INV_TXN_REQUEST_LINES) Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transfer Order Lines (INV_TXN_REQUEST_LINES) Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transfer Order Lines (INV_TXN_REQUEST_LINES) Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Transfer Order Lines (INV_TXN_REQUEST_LINES) Active
TXN_SOURCE_ID NUMBER 18 This identifies the transaction source. Active
TXN_SOURCE_LINE_ID NUMBER 18 Transaction source line identifier Active
TXN_SOURCE_LINE_DETAIL_ID NUMBER 18 Transaction source line detail identifier Active
TRANSACTION_TYPE_ID NUMBER 18 Yes Identifies the transaction type. Active
TRANSACTION_SOURCE_TYPE_ID NUMBER 18 Transaction source type identifier Active
PRIMARY_QUANTITY NUMBER Quantity requested, in primary unit of measure Active
TO_ORGANIZATION_ID NUMBER 18 Identifies the destination organization. Active
PUT_AWAY_STRATEGY_ID NUMBER 18 Put Away strategy identifier - used by WMS only Active
PICK_STRATEGY_ID NUMBER 18 Picking strategy identifier - used by WMS only Active
SHIP_TO_LOCATION_ID NUMBER 18 This identifies the ship-to location. Active
REFERENCE_DETAIL_ID NUMBER 18 This identifies the reference detail. Active
ASSIGNMENT_ID NUMBER 18 This identifies the assignment. Active
UNIT_NUMBER VARCHAR2 30 This column is the unit number. Active
FROM_COST_GROUP_ID NUMBER 18 From Cost Group Identifier - used by WMS only Active
TO_COST_GROUP_ID NUMBER 18 To Cost Group Identifier - used by WMS only Active
LPN_ID NUMBER 18 License Plate Number Identifier - used by WMS only Active
TO_LPN_ID NUMBER 18 Transfer License Plate Number Identifier - used by WMS only Active
INSPECTION_STATUS NUMBER 18 Status after inspection of the movement request line. Active
PICK_METHODOLOGY_ID NUMBER 18 This identifies the pick methodology. Active
CONTAINER_ITEM_ID NUMBER 18 Container Item Id - used by WMS only Active
CARTON_GROUPING_ID NUMBER 18 Carton Grouping Id - used by WMS only Active
BACKORDER_DELIVERY_DETAIL_ID NUMBER 18 The delivery detail Id for the backorder lines Active
WMS_PROCESS_FLAG NUMBER 18 Flag to indicate processing status for putaways. 1 means Ok to process,2 means Do not Allocate, 3 means Allocate but do not process. To be used by Receiving and WIP Active
PICK_SLIP_NUMBER NUMBER 18 Pick slip number for this movement request line. Active
PICK_SLIP_DATE DATE This column is the date of pick slip. Active
SHIP_SET_ID NUMBER 18 This column identifies the ship set. Active
SHIP_MODEL_ID NUMBER 18 This identifies the ship model. Active
MODEL_QUANTITY NUMBER Quantity of the Top Model for Ship Model Complete items Active
CROSSDOCK_TYPE NUMBER 18 This indicates the cross dock type. Active
REQUIRED_QUANTITY NUMBER Required quantity for the sales order Active
GRADE_CODE VARCHAR2 150 This is the grade code for movement request line. Active
SECONDARY_QUANTITY NUMBER Secondary Quantity for Move Order Line Active
SECONDARY_QUANTITY_DELIVERED NUMBER Secondary Quantity Delivered for Move Order Line Active
SECONDARY_QUANTITY_DETAILED NUMBER Secondary Quantity Detailed for Move Order Line Active
SECONDARY_REQUIRED_QUANTITY NUMBER Secondary Required Quantity for Move Order Line Active
SECONDARY_UOM_CODE VARCHAR2 3 Secondary Unit of Measure for Move Order Line Active
WIP_ENTITY_ID NUMBER 18 Identifies the WIP entity in WIP_ENTITIES table. Active
REPETITIVE_SCHEDULE_ID NUMBER 18 This identifies the repetitive schedule. Active
OPERATION_SEQ_NUM NUMBER 18 Operation sequence number within a routing. Active
WIP_SUPPLY_TYPE NUMBER 18 WIP supply type describes the consumption method. Active
PJC_CONTEXT_CATEGORY VARCHAR2 40 DFF Context Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_PROJECT_ID NUMBER 18 DFF Column used by Standardized Project Cost Collection Widget - This was renamed from PROJECT_ID Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_TASK_ID NUMBER 18 DFF Column used by Standardized Project Cost Collection Widget - This was renamed from TASK_ID Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_EXPENDITURE_TYPE_ID NUMBER 18 DFF Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_EXPENDITURE_ITEM_DATE DATE DFF Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_EXPENDITURE_ORG_ID NUMBER 18 DFF Column used by Standardized Project Cost Collection Widget Active
PJC_BILLABLE_FLAG VARCHAR2 1 DFF Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_CAPITALIZABLE_FLAG VARCHAR2 1 DFF Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_WORK_TYPE_ID NUMBER 18 DFF Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_CONTRACT_ID NUMBER 18 DFF Column used by Standardized Project Cost Collection Widget Active
PJC_CONTRACT_LINE_ID NUMBER 18 DFF Column used by Standardized Project Cost Collection Widget Active
PJC_FUNDING_ALLOCATION_ID NUMBER 18 DFF Column used by Standardized Project Cost Collection Widget Active
PJC_RESERVED_ATTRIBUTE1 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_RESERVED_ATTRIBUTE2 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_RESERVED_ATTRIBUTE3 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_RESERVED_ATTRIBUTE4 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_RESERVED_ATTRIBUTE5 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_RESERVED_ATTRIBUTE6 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_RESERVED_ATTRIBUTE7 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_RESERVED_ATTRIBUTE8 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_RESERVED_ATTRIBUTE9 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_RESERVED_ATTRIBUTE10 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_USER_DEF_ATTRIBUTE1 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_USER_DEF_ATTRIBUTE2 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_USER_DEF_ATTRIBUTE3 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_USER_DEF_ATTRIBUTE4 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_USER_DEF_ATTRIBUTE5 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_USER_DEF_ATTRIBUTE6 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_USER_DEF_ATTRIBUTE7 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_USER_DEF_ATTRIBUTE8 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_USER_DEF_ATTRIBUTE9 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_USER_DEF_ATTRIBUTE10 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
SHIP_SET_NAME VARCHAR2 150 This is the name of the ship set. Active
PJC_ORGANIZATION_ID NUMBER 18 DFF Context Column used by Standardized Project Cost Collection Widget Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE20 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.
INV_STRIPING_CATEGORY VARCHAR2 40 Segment used to identify the descriptive flexfield application context for Inventory striping attributes
PROJECT_ID NUMBER 18 Identifier of the project used to stripe Inventory transactions
TASK_ID NUMBER 18 Identifier of the task used to stripe Inventory transactions
COUNTRY_OF_ORIGIN_CODE VARCHAR2 2 Code for the country of manufacture used to stripe Inventory transactions
INV_RESERVED_ATTRIBUTE1 VARCHAR2 150 Reserved for future Inventory striping related functionality
INV_RESERVED_ATTRIBUTE2 VARCHAR2 150 Reserved for future Inventory striping related functionality
INV_USER_DEF_ATTRIBUTE1 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE2 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE3 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE4 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE5 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE6 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE7 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE8 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE9 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE10 VARCHAR2 150 Reserved for user-definable Inventory striping information
BACKORDER_SHORTPICK_QTY NUMBER Quantity back ordered or short picked for a pick wave type of movement request line.
BACKORDER_SHORTPICK_SEC_QTY NUMBER Secondary quantity back ordered or short picked for a pick wave type of movement request line.
ALLOW_ITEM_SUBSTITUTION_FLAG VARCHAR2 1 Indicates whether shipping substitute items is allowed
ORIGINAL_ITEM_ID NUMBER 18 Ordered item from the source system
EXT_SYS_GROUP_ID NUMBER 18 A unique identifier to mark movement request lines that need to be interfaced to an external warehouse management system.
EXT_SYSTEM_REQUESTED_QTY NUMBER This column will be updated with the requested quantity interfaced to the external system. The quantity is in the UOM for the movement request line. For now used for only shop floor type of movement request.
EXT_SYSTEM_REQ_QTY_IN_PUOM NUMBER This column will be updated with the requested quantity interfaced to the external system in the primary UOM. For now used for only shop floor type of movement request.
EXT_SYSTEM_ALLOCATED_QTY NUMBER This column will be updated with the quantity allocated by the external system for the movement request interfaced to them. The quantity is in the UOM for the movement request line. For now used for only shop floor type of movement request.
EXT_SYSTEM_CANCELLED_QTY NUMBER This column will be updated with the quantity cancelled by the external system for the movement request interfaced to them. The quantity is in the UOM for the movement request line. For now used for only shop floor type of movement request.

Foreign Keys

Table Foreign Table Foreign Key Column
INV_TXN_REQUEST_LINES inv_txn_request_headers HEADER_ID
INV_TXN_REQUEST_LINES inv_serial_numbers ORGANIZATION_ID, SERIAL_NUMBER_START, INVENTORY_ITEM_ID
INV_TXN_REQUEST_LINES inv_serial_numbers ORGANIZATION_ID, SERIAL_NUMBER_END, INVENTORY_ITEM_ID
INV_TXN_REQUEST_LINES inv_transaction_reasons_b REASON_ID
INV_TXN_REQUEST_LINES gl_code_combinations TO_ACCOUNT_ID
INV_TXN_REQUEST_LINES inv_org_parameters TO_ORGANIZATION_ID
INV_TXN_REQUEST_LINES inv_transaction_types_b TRANSACTION_TYPE_ID
INV_TXN_REQUEST_LINES inv_txn_source_types_b TRANSACTION_SOURCE_TYPE_ID
INV_TXN_REQUEST_LINES inv_org_parameters ORGANIZATION_ID
INV_TXN_REQUEST_LINES egp_item_org_associations INVENTORY_ITEM_ID, ORGANIZATION_ID
INV_TXN_REQUEST_LINES inv_secondary_inventories FROM_SUBINVENTORY_CODE, ORGANIZATION_ID
INV_TXN_REQUEST_LINES inv_secondary_inventories TO_SUBINVENTORY_CODE, ORGANIZATION_ID
INV_TXN_REQUEST_LINES inv_lot_numbers INVENTORY_ITEM_ID, ORGANIZATION_ID, LOT_NUMBER
inv_material_txns_temp inv_txn_request_lines MOVE_ORDER_LINE_ID

Indexes

Index Uniqueness Tablespace Columns
INV_TXN_REQUEST_LINES_N10 Non Unique FUSION_TS_TX_IDX INVENTORY_ITEM_ID, ORGANIZATION_ID, LINE_STATUS
INV_TXN_REQUEST_LINES_N11 Non Unique FUSION_TS_TX_IDX EXT_SYS_GROUP_ID
INV_TXN_REQUEST_LINES_N2 Non Unique FUSION_TS_TX_IDX ORGANIZATION_ID, LINE_STATUS, FROM_SUBINVENTORY_CODE, TO_SUBINVENTORY_CODE
INV_TXN_REQUEST_LINES_N4 Non Unique FUSION_TS_TX_IDX TRANSACTION_TYPE_ID, TRANSACTION_SOURCE_TYPE_ID, TXN_SOURCE_ID
INV_TXN_REQUEST_LINES_N5 Non Unique FUSION_TS_TX_IDX PICK_SLIP_NUMBER
INV_TXN_REQUEST_LINES_N6 Non Unique FUSION_TS_TX_IDX BACKORDER_DELIVERY_DETAIL_ID
INV_TXN_REQUEST_LINES_N7 Non Unique FUSION_TS_TX_IDX LPN_ID
INV_TXN_REQUEST_LINES_N9 Non Unique FUSION_TS_TX_IDX WIP_ENTITY_ID, REPETITIVE_SCHEDULE_ID
INV_TXN_REQUEST_LINES_U1 Unique FUSION_TS_TX_IDX LINE_ID
INV_TXN_REQUEST_LINES_U2 Unique FUSION_TS_TX_IDX HEADER_ID, LINE_NUMBER
INV_TXN_REQUEST_LINES_U3 Unique FUSION_TS_TX_DATA LINE_ID, HEADER_ID, DATE_REQUIRED