INV Tables (272)

INV - Inventory — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
COST_UPGR_ERROR_TABLE 5 Cost error table
INV_DIAG_MSN_TEMP 20
INV_ITEM_TEMP 279
MTL_3PL_LOCATOR_OCCUPANCY 15 This table will be used as basis for capacity calculation seeded source in 3PL Billing Solution
MTL_ABC_ASSGN_GROUP_CLASSES 30 Assigns abc classes to abc groups
MTL_ABC_ASSIGNMENTS 11 Assigns items to abc classes in an abc group
MTL_ABC_ASSIGNMENT_GROUPS 31 Defines abc groups
MTL_ABC_CLASSES 13 Inventory ABC classes
MTL_ABC_COMPILES 19 ABC descending value compile data
MTL_ABC_COMPILES_EFC 5 Euro as a Functional Currency Archive
MTL_ABC_COMPILE_HEADERS 44 ABC compile header data
MTL_ABC_COMPILE_HEADERS_EFC 3 Euro as a Functional Currency Archive
MTL_ACTIONS_B 38 Action Codes
MTL_ACTIONS_TL 9 Action Codes Language Translation
MTL_ACTUAL_COST_SUBELEMENT 17 Stores the material overhead subelements
MTL_ACTUAL_COST_SUBELEMENT_EFC 8 Euro as a Functional Currency Archive
MTL_ADJUSTMENT_SYNC_TEMP 33
MTL_ATP_RULES 64 ATP computation rules
MTL_ATTR_APPL_DEPENDENCIES 8 Dependencies between item attributes and Oracle products
MTL_AVAILABLE_INVENTORY_TEMP 29
MTL_BILLING_RULE_HEADERS_B 7 Base table for 3PL Billing Rules definitions
MTL_BILLING_RULE_HEADERS_TL 10 Translation table for 3PL billing rule header table
MTL_BILLING_RULE_LINES 12 Billing Rule Lines table for 3PL Billing Project.
MTL_BILLING_SOURCES_B 8 Base Table for Billing sources required in 3PL Billing project
MTL_BILLING_SOURCES_TL 10 MTL_BILLING_SOURCES_TL is the translation table for the billing sources
MTL_BIS_INV_BY_PERIOD 19 BIS table that stores inventory turns data by organization, accounting period and Inventory item id for open periods and closed periods
MTL_CATALOG_SEARCH_ITEMS 6 Items returned by item searches
MTL_CATEGORIES_B 56 Code combinations table for Item Category
MTL_CATEGORIES_TL 10 Categories table storing translated Description column for Item Categories
MTL_CATEGORY_ACCOUNTS 29 Asset and expense accounts by item category, by subinventory
MTL_CATEGORY_SETS_B 24 Category Sets
MTL_CATEGORY_SETS_TL 11 A table holding translated Name and Description columns for Category Sets
MTL_CATEGORY_SET_VALID_CATS 13 Valid categories for category sets
MTL_CC_ENTRIES_INTERFACE 139 Cycle Count Entries Interface data
MTL_CC_INTERFACE_ERRORS 15 Cycle Count Entries Interface process errors
MTL_CC_SCHEDULE_REQUESTS 41 Defines cycle count schedule requests
MTL_CC_SCHED_COUNT_XREFS 12 Cross references count entry requests
MTL_CC_SERIAL_NUMBERS 18 Serial Numbers for Cycle Count Entries.
MTL_CC_SUBINVENTORIES 11 Defines subinventories to be used in subinventory level cycle count
MTL_CHILD_LOT_NUMBERS 9 Child Lot Number Sequences
MTL_CI_INTERFACE 107 Customer Items Interface
MTL_CI_XREFS_INTERFACE 77 Customer Items Cross References Interface
MTL_CLIENT_PARAMETERS 40 Client Parameters table
MTL_COGS_RECOGNITION_TEMP 177
MTL_COMMODITY_CODES 29 Customer item commodity codes
MTL_CONSIGNED_DIAG_ERRORS 28 This table contains the results of the Consigned inventory diagnostics concurrent program.
MTL_CONSUMPTION_DEFINITION 35 This table stores set up records for consumption rules of consigned inventory
MTL_CONSUMPTION_TRANSACTIONS 40 MTL_CONSUMPTION_TRANSACTIONS contains information related to the change of ownership transactions that have occurred to your consigned inven
MTL_CONSUMPTION_TXN_TEMP 31
MTL_COPY_ORG_INTERFACE 12 Interface Table for the Copy Inventory Organizations Concurrent Program. The GROUP_CODE column is used in Copy Inventory Organizations Stand
MTL_COPY_ORG_REPORT 20 This private table contains temporary data to construct a Copy Inventory Organization Report. It is populated by a java session and read by
MTL_COUNTRY_ASSIGNMENTS 10 stores information concerning the assignment of countries to economic zones.
MTL_CROSS_REFERENCES_B 39 Assign cross references to items
MTL_CROSS_REFERENCES_INTERFACE 44 (not currently used)
MTL_CROSS_REFERENCES_TL 9 Cross Reference table storing translated Description column
MTL_CROSS_REFERENCE_TYPES 30 Define cross reference types
MTL_CST_ACTUAL_COST_DETAILS 25 Actual cost information by element and by level
MTL_CST_ACTUAL_COST_DETAIL_EFC 12 Euro as a Functional Currency Archive
MTL_CST_LAYER_ACT_COST_DETAILS 23 Actual cost information by element, by level
MTL_CST_TXN_COST_DETAILS 18 The cost of a transaction by element and by level
MTL_CST_TXN_COST_DETAILS_EFC 6 Euro as a Functional Currency Archive
MTL_CUSTOMER_ITEMS 43 Customer item Information
MTL_CUSTOMER_ITEM_XREFS 30 Relationships between customer items and inventory items
MTL_CYCLE_COUNT_CLASSES 20 Defines cycle count classes
MTL_CYCLE_COUNT_CLASSES_EFC 5 Euro as a Functional Currency Archive
MTL_CYCLE_COUNT_ENTRIES 92 Defines cycle count entries
MTL_CYCLE_COUNT_ENTRIES_EFC 4 Euro as a Functional Currency Archive
MTL_CYCLE_COUNT_HEADERS 64 Defines cycle count header information
MTL_CYCLE_COUNT_HEADERS_EFC 4 Euro as a Functional Currency Archive
MTL_CYCLE_COUNT_ITEMS 33 Defines items to be used in cycle count
MTL_DEFAULT_CATEGORY_SETS 12 Default category set for a particular functional area
MTL_DEMAND 87 Sales order demand and reservations
MTL_DEMAND_HISTORIES 33 Sales order demand and reservations
MTL_DEMAND_INTERFACE 224 Temporary demand storage for the transaction processor
MTL_DESCRIPTIVE_ELEMENTS 15 Descriptive element definitions for an item catalog group
MTL_DESCR_ELEMENT_VALUES 14 Stores the descriptive element values for a particular item
MTL_DESC_ELEM_VAL_INTERFACE 18 Not used currently
MTL_EAM_ASSET_ACTIVITIES 58 Table for Asset Activity Association
MTL_EAM_ASSET_ATTR_GROUPS 13 Table for asset attribute groups
MTL_EAM_ASSET_ATTR_VALUES 59 Table for asset attribute values
MTL_EAM_ASSET_NUM_INTERFACE 106 Asset Number Interface table
MTL_EAM_ASSET_SEARCH_TEMP 8 Temporary table for Asset Search
MTL_EAM_ATTR_VAL_INTERFACE 21 Asset Attribute Interface table
MTL_EAM_LOCATIONS 16 Table for EAM area
MTL_EAM_NETWORK_ASSETS 37 Table for association of assets to asset route.
MTL_ECONOMIC_ZONES_B 7 Stores information concerning all the economic zones.
MTL_ECONOMIC_ZONES_TL 11 Corresponding transalation table for MTL_ECONOMIC_ZONES_B.
MTL_ERES_TRANSACTIONS_GTMP 25
MTL_EXT_OBJECTS 30 External component information of an inventory item
MTL_FISCAL_CAT_ACCOUNTS 18 Category account definitions for legal entity
MTL_FLEX_CONTEXT 15 Context mapping table for Lot & Serial attributes Descriptive Flex Fields.
MTL_FORECAST_RULES 40 Forecast rules for forecast processes
MTL_GENERIC_DISPOSITIONS 55 Account alias definition
MTL_GEN_TEMP 8
MTL_GRADES_B 38 Grade Codes
MTL_GRADES_TL 9 Grade Codes Language Translation
MTL_GRADE_STATUS_ERES_GTMP 2
MTL_ICG_ALIASES 12 Recommended item aliases for items in an item catalog group
MTL_ICG_CATEGORIES 13 Recommended item categories for items in an item catalog group
MTL_INTERCOMPANY_PARAMETERS 36 Inter-company relationships
MTL_INTERFACE_ERRORS 19 Item open interface errors
MTL_INTERFACE_PROC_CONTROLS 19 Interface Processes Control Parameters
MTL_INTERORG_PARAMETERS 67 Inter-organization relationships
MTL_INTERORG_SHIP_METHODS 40 Relationships between shipping networks and shipment methods
MTL_INV_PACKSLIPS 3 Inventory Packing slip documents.
MTL_INV_PICKING_RULES 56 Inventory Picking rules
MTL_ITEM_ATTRIBUTES 24 Item attributes table
MTL_ITEM_ATTRIBUTES_SEED_INFO 13 MTL_ITEM_ATTRIBUTES_SEED_INFO contains the seed attributes information to be used specifically in the copy item attributes user interface m
MTL_ITEM_ATTRIBUTES_TEMP 406
MTL_ITEM_BULKLOAD_RECS 19 Item Bulkloaded Records
MTL_ITEM_CATALOG_GROUPS_B 67 Item Catalog Groups
MTL_ITEM_CATALOG_GROUPS_TL 10 Item Catalog Groups table storing translated Description column
MTL_ITEM_CATEGORIES 15 Define item assignments to categories
MTL_ITEM_CATEGORIES_INTERFACE 28 Item Category Open Interface table; used to load item assignments to category sets and categories into Oracle Inventory.
MTL_ITEM_CHILD_INFO_INTERFACE 48 Not currently used
MTL_ITEM_LOCATIONS 94 Definitions for stock locators
MTL_ITEM_LOC_DEFAULTS 14 Inventory item receiving and shipping locator default values
MTL_ITEM_REVISIONS_B 41 Item revisions
MTL_ITEM_REVISIONS_INTERFACE 53 Item Revisions interface
MTL_ITEM_REVISIONS_TL 11 Item Revisions table storing translated Description column
MTL_ITEM_STATUS_TL 32 Material status definitions
MTL_ITEM_SUB_DEFAULTS 13 Inventory item receiving and shipping subinventory default values
MTL_ITEM_SUB_INVENTORIES 43 Item-subinventory assignments
MTL_ITEM_SUB_INVS_INTERFACE 56 (currently not used)
MTL_ITEM_TEMPLATES_B 51 Item template definitions
MTL_ITEM_TEMPLATES_TL 11 MTL_ITEM_TEMPLATES_TL is a table holding translated Template and Description columns for Templates. Templates now support multilingual descr
MTL_ITEM_TEMPL_ATTRIBUTES 19 Item attributes and attribute values for a template
MTL_ITEM_VALUES_TEMP 4 Holds Item Attributes and their values. Used in the Item Attributes Copyform.
MTL_KANBAN_CARDS 52 Kanban Cards
MTL_KANBAN_CARD_ACTIVITY 50 Kanban Card Activity
MTL_KANBAN_CARD_PRINT_TEMP 3 Temporary table used to print kanban cards
MTL_KANBAN_PULL_SEQUENCES 72 Kanban Pull Sequences
MTL_KANBAN_TEMPLATES 47 Kanban Template
MTL_LE_ECONOMIC_ZONES 7 stores information concerning the assignment of legal entity to economic zones.
MTL_LOTATT_SYNC_REPORT_TEMP 69
MTL_LOT_CONV_AUDIT 14 Audit Trail for conversion changes
MTL_LOT_CONV_AUDIT_DETAILS 19 Audit Detail Record
MTL_LOT_ERES_GTMP 4
MTL_LOT_GRADE_HISTORY 34 New Table, stores the grade update history lot grade updates.
MTL_LOT_NUMBERS 150 Lot number definitions
MTL_LOT_UOM_CLASS_CONVERSIONS 22 Lot specific conversions
MTL_LPN_ATR_QTY_GT 2
MTL_LSP_ONHAND_BALANCE_TMP 21 Onhand Xml
MTL_MANUFACTURERS 28 Define manufacturers
MTL_MATERIAL_STATUSES_B 37 Base table for inventory status definitions - Used by WMS only
MTL_MATERIAL_STATUSES_TL 11 Translation table for inventory status definition - Used by WMS only
MTL_MATERIAL_STATUS_HISTORY 44 Inventory status update history - Used by WMS only
MTL_MATERIAL_TRANSACTIONS 180 Material transaction table
MTL_MATERIAL_TRANSACTIONS_EFC 11 Euro as a Functional Currency Archive
MTL_MATERIAL_TRANSACTIONS_TEMP 243 Temporary table for processing material transactions
MTL_MATERIAL_TXN_ALLOCATIONS 15 Unit allocations among repetitive schedules
MTL_MFG_PART_NUMBERS 35 Define manufacturer part numbers
MTL_MGD_INVENTORY_POSITIONS 28 Stores the data sets built for on line display or for export
MTL_MOBILE_LOGIN_HIST 8 this table will store information about user logging history
MTL_MOQD_BACKUP 37 Back up table for Inventory onhand
MTL_MOVEMENT_PARAMETERS 54 Movement parameter values
MTL_MOVEMENT_STATISTICS 146 Stores all relevant information for movement statistics transactions.
MTL_MOVEMENT_STATISTICS_EFC 3 Euro as a Functional Currency Archive
MTL_MVT_STATS_RULES 13 This table stores validation rules defined for movement statistics fields that belong to a rule set as defined in MTL_MVT_STATS_RULE_SETS_B
MTL_MVT_STATS_RULE_SETS_B 10 Movement Statistics table to store Rule Sets for validation rules.
MTL_MVT_STATS_RULE_SETS_TL 11 MTL_MVT_STATS_RULE_SET_TL is the corresponding transalation table for MTL_MVT_STATS_RULE_SET_B.This table contains one entry for every Rule
MTL_MWB_GTMP 88
MTL_OBJECT_EVENTS 30 Major events that have occurred relevant to an object
MTL_OBJECT_GENEALOGY 39 Genealogy information between an object and its parents
MTL_OBJECT_GENEALOGY_INTERFACE 53 Object Genealogy Inteface table
MTL_ONHAND_LOCK_TEMP 2
MTL_ONHAND_QUANTITIES_DETAIL 33 FIFO quantities by control level and receipt
MTL_ONHAND_QUANTITY_TEMP 31 Temporary table for on-hand quantity queries
MTL_ORG_REPORT_TEMP 3 Multi-organization inventory report temporary table
MTL_PAC_ACTUAL_COST_DETAILS 31 Stores the elemental cost for a given transaction in a period
MTL_PAC_ACTUAL_COST_DETAIL_EFC 14 Euro as a Functional Currency Archive
MTL_PAC_ACT_CST_DTL_TEMP 28 Used to temporarily hold data during the interorg iteration process
MTL_PAC_COST_SUBELEMENTS 18 Stores the material overhead sub-elements that are charged for a given transaction in a particular period.
MTL_PAC_COST_SUBELEMENTS_EFC 8 Euro as a Functional Currency Archive
MTL_PAC_TXN_COST_DETAILS 21 Transaction details for a period
MTL_PAC_TXN_COST_DETAILS_EFC 11 Euro as a Functional Currency Archive
MTL_PARAMETERS 198 Inventory control options and defaults
MTL_PENDING_ITEM_STATUS 20 History of item-status assignments
MTL_PERIOD_CG_SUMMARY 14 The table contains summarized inventory valuation details for an accounting period, organization, inventory type and cost group
MTL_PERIOD_SUMMARY 15 Period summary inventory values for subinventories
MTL_PERIOD_SUMMARY_EFC 5 Euro as a Functional Currency Archive
MTL_PER_CLOSE_DTLS 14 Inventory Period Close Details
MTL_PER_CLOSE_DTLS_EFC 5 Euro as a Functional Currency Archive
MTL_PHYSICAL_ADJUSTMENTS 35 Physical inventory adjustments
MTL_PHYSICAL_ADJUSTMENTS_EFC 3 Euro as a Functional Currency Archive
MTL_PHYSICAL_INVENTORIES 46 Physical inventory definitions
MTL_PHYSICAL_INVENTORIES_EFC 4 Euro as a Functional Currency Archive
MTL_PHYSICAL_INVENTORY_TAGS 51 Physical inventory tag definitions
MTL_PHYSICAL_SUBINVENTORIES 12 Physical inventory specific subinventories
MTL_PICKING_RULES 18 Picking Rule Definitions
MTL_PICK_SLIP_NUMBERS 6 This table is used by parallel pick release
MTL_PLANNERS 31 Planner code definitions
MTL_PO_PACKSLIPS 3 This table contains the Purchasing packing slips information. It is used by the purhjasing packing slip report
MTL_PULL_SEQ_SUPPLIERS 12
MTL_PURGE_HEADER 14 Transaction history purges
MTL_QOH_ITEM_TMP 6 (not currently used)
MTL_QOH_LOCATOR_TMP 10 (not currently used)
MTL_QOH_LOT_TMP 10 (not currently used)
MTL_QOH_REV_TMP 7 (not currently used)
MTL_QOH_SUB_TMP 8 (not currently used)
MTL_RELATED_ITEMS 49 Item Relationships
MTL_RELATED_ITEMS_CUST_REF 14 Item Relationships Customer References
MTL_RELATED_ITEMS_INTERFACE 57 Not currently used
MTL_RELATED_ITEMS_PLN_INFO 15 Item Relationships Planning Information
MTL_REPLENISH_HEADERS 23 Replenishment header information
MTL_REPLENISH_HEADERS_INT 21 Replenishment header interface information
MTL_REPLENISH_LINES 31 Replenishment line information
MTL_REPLENISH_LINES_INT 61 Replenishment line interface information
MTL_RESERVATIONS 87 Reservations
MTL_RESERVATIONS_INTERFACE 150 Reservations Interface
MTL_RMA_SERIAL_TEMP 5
MTL_RTG_ITEM_REVISIONS 34 Routing revisions
MTL_RTG_ITEM_REVS_INTERFACE 40 Routing revisions interface table
MTL_SAFETY_STOCKS 35 Safety stocks
MTL_SALES_ORDERS 36 Local definitions of sales orders
MTL_SEASONALITY_INDICES 9 Seasonality indices
MTL_SECONDARY_INVENTORIES 75 Subinventory definitions
MTL_SECONDARY_LOCATORS 17 Item-subinventory-locator assignments
MTL_SECONDARY_LOCS_INTERFACE 21 (not currently used)
MTL_SERIAL_NUMBERS 187 Serial number definitions
MTL_SERIAL_NUMBERS_GT 10
MTL_SERIAL_NUMBERS_INTERFACE 141 Temporary serial number storage for transactions processor
MTL_SERIAL_NUMBERS_TEMP 144 Temporary serial number holding table
MTL_SERIAL_TAGGING_ASSIGNMENTS 10
MTL_SHORT_CHK_PARAM 53 Shortage Parameters
MTL_SHORT_CHK_STATEMENTS 8 Shortage Check Statements
MTL_SHORT_CHK_TEMP 13 Shortage Check Temporary Table
MTL_SO_RMA_INTERFACE 35 THIS TABLE IS OBSOLETE WITH THE NEW ORDER MANAGEMENT SYSTEM. IT IS USED ONLY FOR DATA MIGRATION FROM THIS TABLE TO THE NEW ORDER MANAGEMENT
MTL_SO_RMA_RECEIPTS 21 THIS TABLE IS OBSOLETE WITH THE NEW ORDER MANAGEMENT SYSTEM. IT IS USED ONLY FOR DATA MIGRATION FROM THIS TABLE TO THE NEW ORDER MANAGEMENT
MTL_STATUS_ATTRIBUTE_VALUES 12 Item status code attribute values
MTL_STATUS_TRANSACTION_CONTROL 10 Relations between inventory status and transaction type - Used by WMS only
MTL_STAT_TYPE_USAGES 32 Stores information which determines the statistical type data for each legal entity.
MTL_SUMMARY_TEMP 15 Transaction summaries
MTL_SUM_DEMD_HIST_GT 2
MTL_SUPPLY 48 Stores incoming supply information
MTL_SUPPLY_DEMAND_TEMP 45 Temporary table containing ATP details returned from ATP user-exit
MTL_SYSTEM_ITEMS_B 401 Inventory item definitions
MTL_SYSTEM_ITEMS_B_EFC 7 Euro as a Functional Currency Archive
MTL_SYSTEM_ITEMS_INTERFACE 437 Inventory Items Open Interface table
MTL_SYSTEM_ITEMS_TL 11 Translations table table holding item descriptions in multiple languages
MTL_TRANSACTIONS_INTERFACE 305 Gateway for externally generated material transactions
MTL_TRANSACTION_ACCOUNTS 36 Material transaction distributions
MTL_TRANSACTION_ACCOUNTS_EFC 6 Euro as a Functional Currency Archive
MTL_TRANSACTION_FLOW_HEADERS 33 Intercompany Transaction Flow
MTL_TRANSACTION_FLOW_LINES 27 Inter-company Transaction flow lines
MTL_TRANSACTION_LOTS_INTERFACE 163 Temporary lot storage for transaction processor
MTL_TRANSACTION_LOTS_TEMP 165 Temporary lot numbers holding table
MTL_TRANSACTION_LOT_NUMBERS 158 Transaction lot numbers
MTL_TRANSACTION_REASONS 32 Inventory Transaction Reasons Table
MTL_TRANSACTION_TYPES 33 Inventory Transaction Types Table
MTL_TRANSFER_TEMP 18
MTL_TRANS_REASON_SECURITY 8 Table MTL_TRANS_REASON_SECURITY, includes the items details for Regulatory Items with regard to the Convergence model
MTL_TXNS_HISTORY 44
MTL_TXN_COST_DET_INTERFACE 23 Stores transaction cost by element and by level for transactions to be imported through the transaction interface
MTL_TXN_REQUEST_HEADERS 45 Move Order headers table
MTL_TXN_REQUEST_LINES 95 Move order lines table
MTL_TXN_SOURCE_TYPES 34 Valid transaction source types
MTL_UNITS_OF_MEASURE_TL 35 Unit of measure definitions
MTL_UNIT_TRANSACTIONS 149 Serial number transactions
MTL_UOM_CLASSES_TL 32 Unit of measure classes
MTL_UOM_CLASS_CONVERSIONS 18 Conversions between base units of two different classes
MTL_UOM_CONVERSIONS 20 Unit of measure conversion table for both default and item specific conversions
MTL_UOM_CONVERSIONS_ERES_GTMP 9
MTL_UPDATE_RECORDS_TEMP 3 Used exclusively for the item attribute copy form
MTL_USER_DEMAND 13 External demand information to be considered in ATP
MTL_USER_SUPPLY 13 External supply information to be considered in ATP
MTL_VMI_QUANTITIES_TEMP 15
ORG_ACCESS 14 Organization access rules table
ORG_ACCT_PERIODS 38 Organization accounting period definition table
ORG_FREIGHT_TL 51 Freight codes
ORG_GL_BATCHES 10 General Ledger transfer information for each batch
WMS_CARTONIZATION_TEMP1 237