Wednesday, 6 November 2013

Inventory Tables in R12

TABLE NAME
TABLE DESCRIPTION
COST_UPGR_ERROR_TABLE
Cost error table
EDW_CST_COGS_F

EDW_CST_COGS_FSTG

EDW_MTL_UOM_CLS_CONV_F

EDW_MTL_UOM_CLS_CONV_FSTG

EDW_MTL_UOM_CONV_F

EDW_MTL_UOM_CONV_FSTG

INV_DIAG_MSN_TEMP

INV_ITEM_TEMP

MTL_ABC_ASSGN_GROUP_CLASSES
Assigns abc classes to abc groups
MTL_ABC_ASSIGNMENTS
Assigns items to abc classes in an abc group
MTL_ABC_ASSIGNMENT_GROUPS
Defines abc groups
MTL_ABC_CLASSES
Inventory ABC classes
MTL_ABC_COMPILES
ABC descending value compile data
MTL_ABC_COMPILES_EFC
Euro as a Functional Currency Archive
MTL_ABC_COMPILE_HEADERS
ABC compile header data
MTL_ABC_COMPILE_HEADERS_EFC
Euro as a Functional Currency Archive
MTL_ACTIONS_B
Action Codes
MTL_ACTIONS_TL
Action Codes Language Translation
MTL_ACTUAL_COST_SUBELEMENT
Stores the material overhead subelements
MTL_ACTUAL_COST_SUBELEMENT_EFC
Euro as a Functional Currency Archive
MTL_ATP_RULES
ATP computation rules
MTL_ATTR_APPL_DEPENDENCIES
Dependencies between item attributes and Oracle products
MTL_BIS_INV_BY_PERIOD
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
Items returned by item searches
MTL_CATEGORIES_B
Code combinations table for Item Category
MTL_CATEGORIES_TL
Categories table storing translated Description column for Item Categories
MTL_CATEGORY_ACCOUNTS
Asset and expense accounts by item category, by subinventory
MTL_CATEGORY_SETS_B
Category Sets
MTL_CATEGORY_SETS_TL
A table holding translated Name and Description columns for Category Sets
MTL_CATEGORY_SET_VALID_CATS
Valid categories for category sets
MTL_CC_ENTRIES_INTERFACE
Cycle Count Entries Interface data
MTL_CC_INTERFACE_ERRORS
Cycle Count Entries Interface process errors
MTL_CC_SCHEDULE_REQUESTS
Defines cycle count schedule requests
MTL_CC_SCHED_COUNT_XREFS
Cross references count entry requests
MTL_CC_SERIAL_NUMBERS
Serial Numbers for Cycle Count Entries.
MTL_CC_SUBINVENTORIES
Defines subinventories to be used in subinventory level cycle count
MTL_CHILD_LOT_NUMBERS
Child Lot Number Sequences
MTL_CI_INTERFACE
Customer Items Interface
MTL_CI_XREFS_INTERFACE
Customer Items Cross References Interface
MTL_COGS_RECOGNITION_TEMP

MTL_COMMODITY_CODES
Customer item commodity codes
MTL_CONSIGNED_DIAG_ERRORS
This table contains the results of the Consigned inventory diagnostics concurrent program.
MTL_CONSUMPTION_DEFINITION
This table stores set up records for  consumption rules of  consigned inventory
MTL_CONSUMPTION_TRANSACTIONS
MTL_CONSUMPTION_TRANSACTIONS contains information related to the change of ownership transactions that have occurred to your consigned inventory. The table is used by the "Create Consumption Advice" concurrent program.  Each consumption adv
MTL_CONSUMPTION_TXN_TEMP

MTL_COPY_ORG_INTERFACE
Interface Table for the Copy Inventory Organizations Concurrent Program. The GROUP_CODE column is used in Copy Inventory Organizations Standard Concurrent Request to identify a set of rows that describe the organizations to be generated by
MTL_COPY_ORG_REPORT
This private table contains temporary data to construct a Copy Inventory Organization Report. It is populated by a java session and read by Oracle Reports during a single concurrent request; it will only contain data while the request is ru
MTL_COUNTRY_ASSIGNMENTS
 stores information concerning the assignment of countries to economic zones.
MTL_CROSS_REFERENCES
Assign cross references to items
MTL_CROSS_REFERENCES_B
Assign cross references to items
MTL_CROSS_REFERENCES_INTERFACE
(not currently used)
MTL_CROSS_REFERENCES_TL
Cross Reference table storing translated Description column
MTL_CROSS_REFERENCE_TYPES
Define cross reference types
MTL_CST_ACTUAL_COST_DETAILS
Actual cost information by element and by level
MTL_CST_ACTUAL_COST_DETAIL_EFC
Euro as a Functional Currency Archive
MTL_CST_LAYER_ACT_COST_DETAILS
Actual cost information by element, by level
MTL_CST_TXN_COST_DETAILS
The cost of a transaction by element and by level
MTL_CST_TXN_COST_DETAILS_EFC
Euro as a Functional Currency Archive
MTL_CUSTOMER_ITEMS
Customer item Information
MTL_CUSTOMER_ITEM_XREFS
Relationships between customer items and inventory items
MTL_CYCLE_COUNT_CLASSES
Defines cycle count classes
MTL_CYCLE_COUNT_CLASSES_EFC
Euro as a Functional Currency Archive
MTL_CYCLE_COUNT_ENTRIES
Defines cycle count entries
MTL_CYCLE_COUNT_ENTRIES_EFC
Euro as a Functional Currency Archive
MTL_CYCLE_COUNT_HEADERS
Defines cycle count header information
MTL_CYCLE_COUNT_HEADERS_EFC
Euro as a Functional Currency Archive
MTL_CYCLE_COUNT_ITEMS
Defines items to be used in cycle count
MTL_DEFAULT_CATEGORY_SETS
Default category set for a particular functional area
MTL_DEMAND
Sales order demand and reservations
MTL_DEMAND_HISTORIES
Sales order demand and reservations
MTL_DEMAND_INTERFACE
Temporary demand storage for the transaction processor
MTL_DESCRIPTIVE_ELEMENTS
Descriptive element definitions for an item catalog group
MTL_DESCR_ELEMENT_VALUES
Stores the descriptive element values for a particular item
MTL_DESC_ELEM_VAL_INTERFACE
Not used currently
MTL_EAM_ASSET_ACTIVITIES
Table for Asset Activity Association
MTL_EAM_ASSET_ATTR_GROUPS
Table for asset attribute groups
MTL_EAM_ASSET_ATTR_VALUES
Table for asset attribute values
MTL_EAM_ASSET_NUM_INTERFACE
Asset Number Interface table
MTL_EAM_ASSET_SEARCH_TEMP
Temporary table for Asset Search
MTL_EAM_ATTR_VAL_INTERFACE
Asset Attribute Interface table
MTL_EAM_LOCATIONS
Table for EAM area
MTL_EAM_NETWORK_ASSETS
Table for association of assets to asset route.
MTL_ECONOMIC_ZONES_B
Stores information concerning all the economic zones.
MTL_ECONOMIC_ZONES_TL
Corresponding transalation table for MTL_ECONOMIC_ZONES_B.
MTL_ERES_TRANSACTIONS_GTMP

MTL_EXT_OBJECTS
External component information of an inventory item
MTL_FISCAL_CAT_ACCOUNTS
Category account definitions for legal entity
MTL_FLEX_CONTEXT
Context mapping table for Lot & Serial attributes Descriptive Flex Fields.
MTL_FORECAST_RULES
Forecast rules for forecast processes
MTL_GENERIC_DISPOSITIONS
Account alias definition
MTL_GEN_TEMP

MTL_GRADES_B
Grade Codes
MTL_GRADES_TL
Grade Codes Language Translation
MTL_GRADE_STATUS_ERES_GTMP

MTL_ICG_ALIASES
Recommended item aliases for items in an item catalog group
MTL_ICG_CATEGORIES
Recommended item categories for items in an item catalog group
MTL_INTERCOMPANY_PARAMETERS
Inter-company relationships
MTL_INTERFACE_ERRORS
Item open interface errors
MTL_INTERFACE_PROC_CONTROLS
Interface Processes Control Parameters
MTL_INTERORG_PARAMETERS
Inter-organization relationships
MTL_INTERORG_SHIP_METHODS
Relationships between shipping networks and shipment methods
MTL_INV_PACKSLIPS
Inventory Packing slip documents.
MTL_INV_PICKING_RULES
Inventory Picking rules
MTL_ITEM_ATTRIBUTES
Item attributes table
MTL_ITEM_ATTRIBUTES_SEED_INFO
MTL_ITEM_ATTRIBUTES_SEED_INFO contains the seed attributes information to be  used specifically in the copy item attributes user interface module.
MTL_ITEM_ATTRIBUTES_TEMP

MTL_ITEM_BULKLOAD_RECS
Item Bulkloaded Records
MTL_ITEM_CATALOG_GROUPS_B
Item Catalog Groups
MTL_ITEM_CATALOG_GROUPS_TL
Item Catalog Groups table storing translated Description column
MTL_ITEM_CATEGORIES
Define item assignments to categories
MTL_ITEM_CATEGORIES_INTERFACE
Item Category Open Interface table; used to load item assignments to category sets and categories into Oracle Inventory.
MTL_ITEM_CHILD_INFO_INTERFACE
Not currently used
MTL_ITEM_LOCATIONS
Definitions for stock locators
MTL_ITEM_LOC_DEFAULTS
Inventory item receiving and shipping locator default values
MTL_ITEM_REVISIONS_B
Item revisions
MTL_ITEM_REVISIONS_INTERFACE
Item Revisions interface
MTL_ITEM_REVISIONS_TL
Item Revisions table storing translated Description column
MTL_ITEM_STATUS
Material status definitions
MTL_ITEM_STATUS_TL
Material status definitions
MTL_ITEM_SUB_DEFAULTS
Inventory item receiving and shipping subinventory default values
MTL_ITEM_SUB_INVENTORIES
Item-subinventory assignments
MTL_ITEM_SUB_INVS_INTERFACE
(currently not used)
MTL_ITEM_TEMPLATES
Item template definitions
MTL_ITEM_TEMPLATES_B
Item template definitions
MTL_ITEM_TEMPLATES_TL
MTL_ITEM_TEMPLATES_TL is a table holding translated Template and Description columns for Templates. Templates now support multilingual description. MLS is implemented with a pair of tables: MTL_ITEM_TEMPLATES_B and MTL_ITEM_TEMPLATES_TL. Tr
MTL_ITEM_TEMPL_ATTRIBUTES
Item attributes and attribute values for a template
MTL_ITEM_VALUES_TEMP
Holds Item Attributes and their values. Used in the Item Attributes Copyform.
MTL_KANBAN_CARDS
Kanban Cards
MTL_KANBAN_CARD_ACTIVITY
Kanban Card Activity
MTL_KANBAN_CARD_PRINT_TEMP
Temporary table used to print kanban cards
MTL_KANBAN_PULL_SEQUENCES
Kanban Pull Sequences
MTL_KANBAN_TEMPLATES
Kanban Template
MTL_LE_ECONOMIC_ZONES
stores information concerning the assignment of legal entity to economic zones.
MTL_LOT_CONV_AUDIT
Audit Trail for conversion changes
MTL_LOT_CONV_AUDIT_DETAILS
Audit Detail Record
MTL_LOT_ERES_GTMP

MTL_LOT_GRADE_HISTORY
New Table, stores the grade update history lot grade updates.
MTL_LOT_NUMBERS
Lot number definitions
MTL_LOT_UOM_CLASS_CONVERSIONS
Lot specific conversions
MTL_LPN_ATR_QTY_GT

MTL_MANUFACTURERS
Define manufacturers
MTL_MATERIAL_STATUSES
Inventory status definition   - Used by WMS only
MTL_MATERIAL_STATUSES_B
Base table for inventory status definitions - Used by WMS only
MTL_MATERIAL_STATUSES_TL
Translation table for inventory status definition - Used by WMS only
MTL_MATERIAL_STATUS_HISTORY
Inventory status update history - Used by WMS only
MTL_MATERIAL_TRANSACTIONS
Material transaction table
MTL_MATERIAL_TRANSACTIONS_EFC
Euro as a Functional Currency Archive
MTL_MATERIAL_TRANSACTIONS_TEMP
Temporary table for processing material transactions
MTL_MATERIAL_TXN_ALLOCATIONS
Unit allocations among repetitive schedules
MTL_MFG_PART_NUMBERS
Define manufacturer part numbers
MTL_MGD_INVENTORY_POSITIONS
Stores the data sets built for on line display or for export
MTL_MOBILE_LOGIN_HIST
this table will store information about user logging  history
MTL_MOQD_BACKUP
Back up table for Inventory onhand
MTL_MOVEMENT_PARAMETERS
Movement parameter values
MTL_MOVEMENT_STATISTICS
Stores all relevant information  for movement statistics transactions.
MTL_MOVEMENT_STATISTICS_EFC
Euro as a Functional Currency Archive
MTL_MVT_STATS_RULES
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 table.Each row stores a rule that can determine a  valid set of values for a field or an alternate u
MTL_MVT_STATS_RULE_SETS_B
Movement Statistics table to store Rule Sets for validation rules.
MTL_MVT_STATS_RULE_SETS_TL
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 Set Code and Language.Rule Set Code and  Language uniquely identify a row.Rule Set Display Name iden
MTL_MWB_GTMP

MTL_OBJECT_EVENTS
Major events that have occurred relevant to an object
MTL_OBJECT_GENEALOGY
Genealogy information between an object and its parents
MTL_OBJECT_GENEALOGY_INTERFACE
Object Genealogy Inteface table
MTL_ONHAND_LOCK_TEMP

MTL_ONHAND_QUANTITIES
FIFO quantities by control level and receipt
MTL_ONHAND_QUANTITIES_DETAIL
FIFO quantities by control level and receipt
MTL_ONHAND_QUANTITY_TEMP
Temporary table for on-hand quantity queries
MTL_ORG_REPORT_TEMP
Multi-organization inventory report temporary table
MTL_PAC_ACTUAL_COST_DETAILS
Stores the elemental cost for a given transaction in a period
MTL_PAC_ACTUAL_COST_DETAIL_EFC
Euro as a Functional Currency Archive
MTL_PAC_ACT_CST_DTL_TEMP
Used to temporarily hold data during the interorg iteration process
MTL_PAC_COST_SUBELEMENTS
Stores the material overhead sub-elements that are charged for a given transaction in a particular period.
MTL_PAC_COST_SUBELEMENTS_EFC
Euro as a Functional Currency Archive
MTL_PAC_TXN_COST_DETAILS
Transaction details for a period
MTL_PAC_TXN_COST_DETAILS_EFC
Euro as a Functional Currency Archive
MTL_PARAMETERS
Inventory control options and defaults
MTL_PENDING_ITEM_STATUS
History of item-status assignments
MTL_PERIOD_CG_SUMMARY
The table contains summarized inventory valuation details for an accounting period, organization, inventory type and cost group
MTL_PERIOD_SUMMARY
Period summary inventory values for subinventories
MTL_PERIOD_SUMMARY_EFC
Euro as a Functional Currency Archive
MTL_PER_CLOSE_DTLS
Inventory Period Close Details
MTL_PER_CLOSE_DTLS_EFC
Euro as a Functional Currency Archive
MTL_PHYSICAL_ADJUSTMENTS
Physical inventory adjustments
MTL_PHYSICAL_ADJUSTMENTS_EFC
Euro as a Functional Currency Archive
MTL_PHYSICAL_INVENTORIES
Physical inventory definitions
MTL_PHYSICAL_INVENTORIES_EFC
Euro as a Functional Currency Archive
MTL_PHYSICAL_INVENTORY_TAGS
Physical inventory tag definitions
MTL_PHYSICAL_SUBINVENTORIES
Physical inventory specific subinventories
MTL_PICKING_RULES
Picking Rule Definitions
MTL_PICK_SLIP_NUMBERS
This table is used by parallel pick release
MTL_PLANNERS
Planner code definitions
MTL_PO_PACKSLIPS
This table contains the Purchasing packing slips information. It is used by  the purhjasing packing slip report
MTL_PURGE_HEADER
Transaction history purges
MTL_QOH_ITEM_TMP
(not currently used)
MTL_QOH_LOCATOR_TMP
(not currently used)
MTL_QOH_LOT_TMP
(not currently used)
MTL_QOH_REV_TMP
(not currently used)
MTL_QOH_SUB_TMP
(not currently used)
MTL_RELATED_ITEMS
Item Relationships
MTL_RELATED_ITEMS_CUST_REF
Item Relationships Customer References
MTL_RELATED_ITEMS_INTERFACE
Not currently used
MTL_RELATED_ITEMS_PLN_INFO
Item Relationships Planning Information
MTL_REPLENISH_HEADERS
Replenishment header information
MTL_REPLENISH_HEADERS_INT
Replenishment header interface information
MTL_REPLENISH_LINES
Replenishment line information
MTL_REPLENISH_LINES_INT
Replenishment line interface information
MTL_RESERVATIONS
Reservations
MTL_RESERVATIONS_INTERFACE
Reservations Interface
MTL_RMA_SERIAL_TEMP

MTL_RTG_ITEM_REVISIONS
Routing revisions
MTL_RTG_ITEM_REVS_INTERFACE
Routing revisions interface table
MTL_SAFETY_STOCKS
Safety stocks
MTL_SALES_ORDERS
Local definitions of sales orders
MTL_SEASONALITY_INDICES
Seasonality indices
MTL_SECONDARY_INVENTORIES
Subinventory definitions
MTL_SECONDARY_LOCATORS
Item-subinventory-locator assignments
MTL_SECONDARY_LOCS_INTERFACE
(not currently used)
MTL_SERIAL_NUMBERS
Serial number definitions
MTL_SERIAL_NUMBERS_GT

MTL_SERIAL_NUMBERS_INTERFACE
Temporary serial number storage for transactions processor
MTL_SERIAL_NUMBERS_TEMP
Temporary serial number holding table
MTL_SHORT_CHK_PARAM
Shortage Parameters
MTL_SHORT_CHK_STATEMENTS
Shortage Check Statements
MTL_SHORT_CHK_TEMP
Shortage Check Temporary Table
MTL_SO_RMA_INTERFACE
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 SYSTEM. .RMA headers and lines for OE interface
MTL_SO_RMA_RECEIPTS
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 SYSTEM. RMA receipt transactions
MTL_STATUS_ATTRIBUTE_VALUES
Item status code attribute values
MTL_STATUS_TRANSACTION_CONTROL
Relations between inventory status and transaction type  - Used by WMS only
MTL_STAT_TYPE_USAGES
Stores information which determines the statistical type data  for each legal entity.
MTL_SUMMARY_TEMP
Transaction summaries
MTL_SUM_DEMD_HIST_GT

MTL_SUPPLY
Stores incoming supply information
MTL_SUPPLY_DEMAND_TEMP
Temporary table containing ATP details returned from ATP user-exit
MTL_SYSTEM_ITEMS_B
Inventory item definitions
MTL_SYSTEM_ITEMS_B_EFC
Euro as a Functional Currency Archive
MTL_SYSTEM_ITEMS_INTERFACE
Inventory Items Open Interface table
MTL_SYSTEM_ITEMS_TL
Translations table table holding item descriptions in multiple languages
MTL_TRANSACTIONS_INTERFACE
Gateway for externally generated material transactions
MTL_TRANSACTION_ACCOUNTS
Material transaction distributions
MTL_TRANSACTION_ACCOUNTS_EFC
Euro as a Functional Currency Archive
MTL_TRANSACTION_FLOW_HEADERS
Intercompany Transaction Flow
MTL_TRANSACTION_FLOW_LINES
Inter-company Transaction flow lines
MTL_TRANSACTION_LOTS_INTERFACE
Temporary lot storage for transaction processor
MTL_TRANSACTION_LOTS_TEMP
Temporary lot numbers holding table
MTL_TRANSACTION_LOT_NUMBERS
Transaction lot numbers
MTL_TRANSACTION_REASONS
Inventory Transaction Reasons Table
MTL_TRANSACTION_TYPES
Inventory Transaction Types Table
MTL_TRANSFER_TEMP

MTL_TRANS_REASON_SECURITY
Table MTL_TRANS_REASON_SECURITY, includes the items details for Regulatory Items with regard to the Convergence model
MTL_TXN_COST_DET_INTERFACE
Stores transaction cost by element and by level for transactions to be imported through the transaction  interface
MTL_TXN_REQUEST_HEADERS
Move Order headers table
MTL_TXN_REQUEST_LINES
Move order lines table
MTL_TXN_SOURCE_TYPES
Valid transaction source types
MTL_UNITS_OF_MEASURE_TL
Unit of measure definitions
MTL_UNIT_TRANSACTIONS
Serial number transactions
MTL_UOM_CLASSES_TL
Unit of measure classes
MTL_UOM_CLASS_CONVERSIONS
Conversions between base units of two different classes
MTL_UOM_CONVERSIONS
Unit of measure conversion table for both default and item specific conversions
MTL_UOM_CONVERSIONS_ERES_GTMP

MTL_UPDATE_RECORDS_TEMP
Used exclusively for the item attribute copy form
MTL_USER_DEMAND
External demand information to be considered in ATP
MTL_USER_SUPPLY
External supply information to be considered in ATP
MTL_VMI_QUANTITIES_TEMP

ORG_ACCESS
Organization access rules table
ORG_ACCT_PERIODS
Organization accounting period definition table
ORG_FREIGHT_TL
Freight codes
ORG_GL_BATCHES
General Ledger transfer information for each batch
WMS_CARTONIZATION_TEMP