Oracle EBS 12R INV (Inventory) Tables

SL NoTableDescription
1COST_UPGR_ERROR_TABLECost error table
2EDW_CST_COGS_F
3EDW_CST_COGS_FSTG
4EDW_MTL_UOM_CLS_CONV_F
5EDW_MTL_UOM_CLS_CONV_FSTG
6EDW_MTL_UOM_CONV_F
7EDW_MTL_UOM_CONV_FSTG
8INV_DIAG_MSN_TEMP
9INV_EID_LOCATORS_MAP
10INV_EID_MIL_DATE_TMP
11INV_EID_MMT_DATE_TMP
12INV_EID_MOQD_DATE_TMP
13INV_EID_ONHAND_DETAILS_MAP
14INV_EID_PF_DATE_TMP
15INV_EID_PICKED_DETAILS_MAP
16INV_EID_RESERVATIONS_MAP
17INV_EID_RSV_DATE_TMP
18INV_EID_TASKS_MAP
19INV_EID_TASK_DATE_TMP
20INV_EID_TF_DATE_TMP
21INV_EID_UNPICKED_DETAILS_MAP
22INV_ITEM_TEMP
23MTL_3PL_LOCATOR_OCCUPANCYThis table will be used as basis for capacity calculation seeded source in 3PL Billing Solution
24MTL_ABC_ASSGN_GROUP_CLASSESAssigns abc classes to abc groups
25MTL_ABC_ASSIGNMENTSAssigns items to abc classes in an abc group
26MTL_ABC_ASSIGNMENT_GROUPSDefines abc groups
27MTL_ABC_CLASSESInventory ABC classes
28MTL_ABC_COMPILESABC descending value compile data
29MTL_ABC_COMPILES_EFCEuro as a Functional Currency Archive
30MTL_ABC_COMPILE_HEADERSABC compile header data
31MTL_ABC_COMPILE_HEADERS_EFCEuro as a Functional Currency Archive
32MTL_ACTIONS_BAction Codes
33MTL_ACTIONS_TLAction Codes Language Translation
34MTL_ACTUAL_COST_SUBELEMENTStores the material overhead subelements
35MTL_ACTUAL_COST_SUBELEMENT_EFCEuro as a Functional Currency Archive
36MTL_ADJUSTMENT_SYNC_TEMP
37MTL_ATP_RULESATP computation rules
38MTL_ATTR_APPL_DEPENDENCIESDependencies between item attributes and Oracle products
39MTL_AVAILABLE_INVENTORY_TEMP
40MTL_BILLING_RULE_HEADERS_BBase table for 3PL Billing Rules definitions
41MTL_BILLING_RULE_HEADERS_TLTranslation table for 3PL billing rule header table
42MTL_BILLING_RULE_LINESBilling Rule Lines table for 3PL Billing Project.
43MTL_BILLING_SOURCES_BBase Table for Billing sources required in 3PL Billing project
44MTL_BILLING_SOURCES_TLMTL_BILLING_SOURCES_TL is the translation table for the billing sources
45MTL_BIS_INV_BY_PERIODBIS table that stores inventory turns data by organization, accounting period and Inventory item id for open periods and closed periods
46MTL_CATALOG_SEARCH_ITEMSItems returned by item searches
47MTL_CATEGORIES_BCode combinations table for Item Category
48MTL_CATEGORIES_TLCategories table storing translated Description column for Item Categories
49MTL_CATEGORY_ACCOUNTSAsset and expense accounts by item category, by subinventory
50MTL_CATEGORY_SETS_BCategory Sets
51MTL_CATEGORY_SETS_TLA table holding translated Name and Description columns for Category Sets
52MTL_CATEGORY_SET_VALID_CATSValid categories for category sets
53MTL_CC_ENTRIES_INTERFACECycle Count Entries Interface data
54MTL_CC_INTERFACE_ERRORSCycle Count Entries Interface process errors
55MTL_CC_SCHEDULE_REQUESTSDefines cycle count schedule requests
56MTL_CC_SCHED_COUNT_XREFSCross references count entry requests
57MTL_CC_SERIAL_NUMBERSSerial Numbers for Cycle Count Entries.
58MTL_CC_SUBINVENTORIESDefines subinventories to be used in subinventory level cycle count
59MTL_CHILD_LOT_NUMBERSChild Lot Number Sequences
60MTL_CI_INTERFACECustomer Items Interface
61MTL_CI_XREFS_INTERFACECustomer Items Cross References Interface
62MTL_CLIENT_PARAMETERSClient Parameters table
63MTL_COGS_RECOGNITION_TEMP
64MTL_COMMODITY_CODESCustomer item commodity codes
65MTL_CONSIGNED_DIAG_ERRORSThis table contains the results of the Consigned inventory diagnostics concurrent program.
66MTL_CONSUMPTION_DEFINITIONThis table stores set up records for consumption rules of consigned inventory
67MTL_CONSUMPTION_TRANSACTIONSMTL_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
68MTL_CONSUMPTION_TXN_TEMP
69MTL_COPY_ORG_INTERFACEInterface 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
70MTL_COPY_ORG_REPORTThis 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
71MTL_COUNTRY_ASSIGNMENTSstores information concerning the assignment of countries to economic zones.
72MTL_CROSS_REFERENCESAssign cross references to items
73MTL_CROSS_REFERENCES_BAssign cross references to items
74MTL_CROSS_REFERENCES_INTERFACE(not currently used)
75MTL_CROSS_REFERENCES_TLCross Reference table storing translated Description column
76MTL_CROSS_REFERENCE_TYPESDefine cross reference types
77MTL_CST_ACTUAL_COST_DETAILSActual cost information by element and by level
78MTL_CST_ACTUAL_COST_DETAIL_EFCEuro as a Functional Currency Archive
79MTL_CST_LAYER_ACT_COST_DETAILSActual cost information by element, by level
80MTL_CST_TXN_COST_DETAILSThe cost of a transaction by element and by level
81MTL_CST_TXN_COST_DETAILS_EFCEuro as a Functional Currency Archive
82MTL_CUSTOMER_ITEMSCustomer item Information
83MTL_CUSTOMER_ITEM_XREFSRelationships between customer items and inventory items
84MTL_CYCLE_COUNT_CLASSESDefines cycle count classes
85MTL_CYCLE_COUNT_CLASSES_EFCEuro as a Functional Currency Archive
86MTL_CYCLE_COUNT_ENTRIESDefines cycle count entries
87MTL_CYCLE_COUNT_ENTRIES_EFCEuro as a Functional Currency Archive
88MTL_CYCLE_COUNT_HEADERSDefines cycle count header information
89MTL_CYCLE_COUNT_HEADERS_EFCEuro as a Functional Currency Archive
90MTL_CYCLE_COUNT_ITEMSDefines items to be used in cycle count
91MTL_DEFAULT_CATEGORY_SETSDefault category set for a particular functional area
92MTL_DEMANDSales order demand and reservations
93MTL_DEMAND_HISTORIESSales order demand and reservations
94MTL_DEMAND_INTERFACETemporary demand storage for the transaction processor
95MTL_DESCRIPTIVE_ELEMENTSDescriptive element definitions for an item catalog group
96MTL_DESCR_ELEMENT_VALUESStores the descriptive element values for a particular item
97MTL_DESC_ELEM_VAL_INTERFACENot used currently
98MTL_EAM_ASSET_ACTIVITIESTable for Asset Activity Association
99MTL_EAM_ASSET_ATTR_GROUPSTable for asset attribute groups
100MTL_EAM_ASSET_ATTR_VALUESTable for asset attribute values
101MTL_EAM_ASSET_NUM_INTERFACEAsset Number Interface table
102MTL_EAM_ASSET_SEARCH_TEMPTemporary table for Asset Search
103MTL_EAM_ATTR_VAL_INTERFACEAsset Attribute Interface table
104MTL_EAM_LOCATIONSTable for EAM area
105MTL_EAM_NETWORK_ASSETSTable for association of assets to asset route.
106MTL_ECONOMIC_ZONES_BStores information concerning all the economic zones.
107MTL_ECONOMIC_ZONES_TLCorresponding transalation table for MTL_ECONOMIC_ZONES_B.
108MTL_ERES_TRANSACTIONS_GTMP
109MTL_EXT_OBJECTSExternal component information of an inventory item
110MTL_FISCAL_CAT_ACCOUNTSCategory account definitions for legal entity
111MTL_FLEX_CONTEXTContext mapping table for Lot & Serial attributes Descriptive Flex Fields.
112MTL_FORECAST_RULESForecast rules for forecast processes
113MTL_GENERIC_DISPOSITIONSAccount alias definition
114MTL_GEN_TEMP
115MTL_GRADES_BGrade Codes
116MTL_GRADES_TLGrade Codes Language Translation
117MTL_GRADE_STATUS_ERES_GTMP
118MTL_ICG_ALIASESRecommended item aliases for items in an item catalog group
119MTL_ICG_CATEGORIESRecommended item categories for items in an item catalog group
120MTL_INTERCOMPANY_PARAMETERSInter-company relationships
121MTL_INTERFACE_ERRORSItem open interface errors
122MTL_INTERFACE_PROC_CONTROLSInterface Processes Control Parameters
123MTL_INTERORG_PARAMETERSInter-organization relationships
124MTL_INTERORG_SHIP_METHODSRelationships between shipping networks and shipment methods
125MTL_INV_PACKSLIPSInventory Packing slip documents.
126MTL_INV_PICKING_RULESInventory Picking rules
127MTL_ITEM_ATTRIBUTESItem attributes table
128MTL_ITEM_ATTRIBUTES_SEED_INFOMTL_ITEM_ATTRIBUTES_SEED_INFO contains the seed attributes information to be used specifically in the copy item attributes user interface module.
129MTL_ITEM_ATTRIBUTES_TEMP
130MTL_ITEM_BULKLOAD_RECSItem Bulkloaded Records
131MTL_ITEM_CATALOG_GROUPS_BItem Catalog Groups
132MTL_ITEM_CATALOG_GROUPS_TLItem Catalog Groups table storing translated Description column
133MTL_ITEM_CATEGORIESDefine item assignments to categories
134MTL_ITEM_CATEGORIES_INTERFACEItem Category Open Interface table; used to load item assignments to category sets and categories into Oracle Inventory.
135MTL_ITEM_CHILD_INFO_INTERFACENot currently used
136MTL_ITEM_ENDECA_TEMP
137MTL_ITEM_LOCATIONSDefinitions for stock locators
138MTL_ITEM_LOC_DEFAULTSInventory item receiving and shipping locator default values
139MTL_ITEM_REVISIONS_BItem revisions
140MTL_ITEM_REVISIONS_INTERFACEItem Revisions interface
141MTL_ITEM_REVISIONS_TLItem Revisions table storing translated Description column
142MTL_ITEM_STATUSMaterial status definitions
143MTL_ITEM_STATUS_TLMaterial status definitions
144MTL_ITEM_SUB_DEFAULTSInventory item receiving and shipping subinventory default values
145MTL_ITEM_SUB_INVENTORIESItem-subinventory assignments
146MTL_ITEM_SUB_INVS_INTERFACE(currently not used)
147MTL_ITEM_TEMPLATESItem template definitions
148MTL_ITEM_TEMPLATES_BItem template definitions
149MTL_ITEM_TEMPLATES_TLMTL_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
150MTL_ITEM_TEMPL_ATTRIBUTESItem attributes and attribute values for a template
151MTL_ITEM_VALUES_TEMPHolds Item Attributes and their values. Used in the Item Attributes Copyform.
152MTL_KANBAN_CARDSKanban Cards
153MTL_KANBAN_CARD_ACTIVITYKanban Card Activity
154MTL_KANBAN_CARD_PRINT_TEMPTemporary table used to print kanban cards
155MTL_KANBAN_PULL_SEQUENCESKanban Pull Sequences
156MTL_KANBAN_TEMPLATESKanban Template
157MTL_LE_ECONOMIC_ZONESstores information concerning the assignment of legal entity to economic zones.
158MTL_LOTATT_SYNC_REPORT_TEMP
159MTL_LOT_CONV_AUDITAudit Trail for conversion changes
160MTL_LOT_CONV_AUDIT_DETAILSAudit Detail Record
161MTL_LOT_ERES_GTMP
162MTL_LOT_GRADE_HISTORYNew Table, stores the grade update history lot grade updates.
163MTL_LOT_NUMBERSLot number definitions
164MTL_LOT_UOM_CLASS_CONVERSIONSLot specific conversions
165MTL_LPN_ATR_QTY_GT
166MTL_LSP_ONHAND_BALANCE_TMPOnhand Xml
167MTL_MANUFACTURERSDefine manufacturers
168MTL_MATERIAL_STATUSESInventory status definition - Used by WMS only
169MTL_MATERIAL_STATUSES_BBase table for inventory status definitions - Used by WMS only
170MTL_MATERIAL_STATUSES_TLTranslation table for inventory status definition - Used by WMS only
171MTL_MATERIAL_STATUS_HISTORYInventory status update history - Used by WMS only
172MTL_MATERIAL_TRANSACTIONSMaterial transaction table
173MTL_MATERIAL_TRANSACTIONS_EFCEuro as a Functional Currency Archive
174MTL_MATERIAL_TRANSACTIONS_TEMPTemporary table for processing material transactions
175MTL_MATERIAL_TXN_ALLOCATIONSUnit allocations among repetitive schedules
176MTL_MFG_PART_NUMBERSDefine manufacturer part numbers
177MTL_MGD_INVENTORY_POSITIONSStores the data sets built for on line display or for export
178MTL_MOBILE_LOGIN_HISTthis table will store information about user logging history
179MTL_MOQD_BACKUPBack up table for Inventory onhand
180MTL_MOVEMENT_PARAMETERSMovement parameter values
181MTL_MOVEMENT_STATISTICSStores all relevant information for movement statistics transactions.
182MTL_MOVEMENT_STATISTICS_EFCEuro as a Functional Currency Archive
183MTL_MVT_STATS_RULESThis 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
184MTL_MVT_STATS_RULE_SETS_BMovement Statistics table to store Rule Sets for validation rules.
185MTL_MVT_STATS_RULE_SETS_TLMTL_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
186MTL_MWB_GTMP
187MTL_MWB_GTMP2
188MTL_OBJECT_EVENTSMajor events that have occurred relevant to an object
189MTL_OBJECT_GENEALOGYGenealogy information between an object and its parents
190MTL_OBJECT_GENEALOGY_INTERFACEObject Genealogy Inteface table
191MTL_ONHAND_LOCK_TEMP
192MTL_ONHAND_QUANTITIESFIFO quantities by control level and receipt
193MTL_ONHAND_QUANTITIES_DETAILFIFO quantities by control level and receipt
194MTL_ONHAND_QUANTITY_TEMPTemporary table for on-hand quantity queries
195MTL_ORG_REPORT_TEMPMulti-organization inventory report temporary table
196MTL_PAC_ACTUAL_COST_DETAILSStores the elemental cost for a given transaction in a period
197MTL_PAC_ACTUAL_COST_DETAIL_EFCEuro as a Functional Currency Archive
198MTL_PAC_ACT_CST_DTL_TEMPUsed to temporarily hold data during the interorg iteration process
199MTL_PAC_COST_SUBELEMENTSStores the material overhead sub-elements that are charged for a given transaction in a particular period.
200MTL_PAC_COST_SUBELEMENTS_EFCEuro as a Functional Currency Archive
201MTL_PAC_TXN_COST_DETAILSTransaction details for a period
202MTL_PAC_TXN_COST_DETAILS_EFCEuro as a Functional Currency Archive
203MTL_PARAMETERSInventory control options and defaults
204MTL_PENDING_ITEM_STATUSHistory of item-status assignments
205MTL_PERIOD_CG_SUMMARYThe table contains summarized inventory valuation details for an accounting period, organization, inventory type and cost group
206MTL_PERIOD_SUMMARYPeriod summary inventory values for subinventories
207MTL_PERIOD_SUMMARY_EFCEuro as a Functional Currency Archive
208MTL_PER_CLOSE_DTLSInventory Period Close Details
209MTL_PER_CLOSE_DTLS_EFCEuro as a Functional Currency Archive
210MTL_PHYSICAL_ADJUSTMENTSPhysical inventory adjustments
211MTL_PHYSICAL_ADJUSTMENTS_EFCEuro as a Functional Currency Archive
212MTL_PHYSICAL_INVENTORIESPhysical inventory definitions
213MTL_PHYSICAL_INVENTORIES_EFCEuro as a Functional Currency Archive
214MTL_PHYSICAL_INVENTORY_TAGSPhysical inventory tag definitions
215MTL_PHYSICAL_SUBINVENTORIESPhysical inventory specific subinventories
216MTL_PICKING_RULESPicking Rule Definitions
217MTL_PICK_SLIP_NUMBERSThis table is used by parallel pick release
218MTL_PLANNERSPlanner code definitions
219MTL_PO_PACKSLIPSThis table contains the Purchasing packing slips information. It is used by the purhjasing packing slip report
220MTL_PULL_SEQ_SUPPLIERS
221MTL_PURGE_HEADERTransaction history purges
222MTL_QOH_ITEM_TMP(not currently used)
223MTL_QOH_LOCATOR_TMP(not currently used)
224MTL_QOH_LOT_TMP(not currently used)
225MTL_QOH_REV_TMP(not currently used)
226MTL_QOH_SUB_TMP(not currently used)
227MTL_RELATED_ITEMSItem Relationships
228MTL_RELATED_ITEMS_CUST_REFItem Relationships Customer References
229MTL_RELATED_ITEMS_INTERFACENot currently used
230MTL_RELATED_ITEMS_PLN_INFOItem Relationships Planning Information
231MTL_REPLENISH_HEADERSReplenishment header information
232MTL_REPLENISH_HEADERS_INTReplenishment header interface information
233MTL_REPLENISH_LINESReplenishment line information
234MTL_REPLENISH_LINES_INTReplenishment line interface information
235MTL_RESERVATIONSReservations
236MTL_RESERVATIONS_INTERFACEReservations Interface
237MTL_RMA_SERIAL_TEMP
238MTL_RTG_ITEM_REVISIONSRouting revisions
239MTL_RTG_ITEM_REVS_INTERFACERouting revisions interface table
240MTL_SAFETY_STOCKSSafety stocks
241MTL_SALES_ORDERSLocal definitions of sales orders
242MTL_SEASONALITY_INDICESSeasonality indices
243MTL_SECONDARY_INVENTORIESSubinventory definitions
244MTL_SECONDARY_LOCATORSItem-subinventory-locator assignments
245MTL_SECONDARY_LOCS_INTERFACE(not currently used)
246MTL_SERIAL_NUMBERSSerial number definitions
247MTL_SERIAL_NUMBERS_GT
248MTL_SERIAL_NUMBERS_INTERFACETemporary serial number storage for transactions processor
249MTL_SERIAL_NUMBERS_TEMPTemporary serial number holding table
250MTL_SERIAL_TAGGING_ASSIGNMENTS
251MTL_SHORT_CHK_PARAMShortage Parameters
252MTL_SHORT_CHK_STATEMENTSShortage Check Statements
253MTL_SHORT_CHK_TEMPShortage Check Temporary Table
254MTL_SO_RMA_INTERFACETHIS 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
255MTL_SO_RMA_RECEIPTSTHIS 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
256MTL_STATUS_ATTRIBUTE_VALUESItem status code attribute values
257MTL_STATUS_TRANSACTION_CONTROLRelations between inventory status and transaction type - Used by WMS only
258MTL_STAT_TYPE_USAGESStores information which determines the statistical type data for each legal entity.
259MTL_SUMMARY_TEMPTransaction summaries
260MTL_SUM_DEMD_HIST_GT
261MTL_SUPPLYStores incoming supply information
262MTL_SUPPLY_DEMAND_TEMPTemporary table containing ATP details returned from ATP user-exit
263MTL_SYSTEM_ITEMS_BInventory item definitions
264MTL_SYSTEM_ITEMS_B_EFCEuro as a Functional Currency Archive
265MTL_SYSTEM_ITEMS_INTERFACEInventory Items Open Interface table
266MTL_SYSTEM_ITEMS_TLTranslations table table holding item descriptions in multiple languages
267MTL_TRANSACTIONS_INTERFACEGateway for externally generated material transactions
268MTL_TRANSACTION_ACCOUNTSMaterial transaction distributions
269MTL_TRANSACTION_ACCOUNTS_EFCEuro as a Functional Currency Archive
270MTL_TRANSACTION_FLOW_HEADERSIntercompany Transaction Flow
271MTL_TRANSACTION_FLOW_LINESInter-company Transaction flow lines
272MTL_TRANSACTION_LOTS_INTERFACETemporary lot storage for transaction processor
273MTL_TRANSACTION_LOTS_TEMPTemporary lot numbers holding table
274MTL_TRANSACTION_LOT_NUMBERSTransaction lot numbers
275MTL_TRANSACTION_REASONSInventory Transaction Reasons Table
276MTL_TRANSACTION_TYPESInventory Transaction Types Table
277MTL_TRANSFER_TEMP
278MTL_TRANS_REASON_SECURITYTable MTL_TRANS_REASON_SECURITY, includes the items details for Regulatory Items with regard to the Convergence model
279MTL_TXNS_HISTORY
280MTL_TXN_COST_DET_INTERFACEStores transaction cost by element and by level for transactions to be imported through the transaction interface
281MTL_TXN_REQUEST_HEADERSMove Order headers table
282MTL_TXN_REQUEST_LINESMove order lines table
283MTL_TXN_SOURCE_TYPESValid transaction source types
284MTL_UNITS_OF_MEASURE_TLUnit of measure definitions
285MTL_UNIT_TRANSACTIONSSerial number transactions
286MTL_UOM_CLASSES_TLUnit of measure classes
287MTL_UOM_CLASS_CONVERSIONSConversions between base units of two different classes
288MTL_UOM_CONVERSIONSUnit of measure conversion table for both default and item specific conversions
289MTL_UOM_CONVERSIONS_ERES_GTMP
290MTL_UPDATE_RECORDS_TEMPUsed exclusively for the item attribute copy form
291MTL_USER_DEMANDExternal demand information to be considered in ATP
292MTL_USER_SUPPLYExternal supply information to be considered in ATP
293MTL_VMI_QUANTITIES_TEMP
294ORG_ACCESSOrganization access rules table
295ORG_ACCT_PERIODSOrganization accounting period definition table
296ORG_FREIGHT_TLFreight codes
297ORG_GL_BATCHESGeneral Ledger transfer information for each batch
298WMS_CARTONIZATION_TEMP
299WMS_CARTONIZATION_TEMP1

Comments

Popular posts from this blog

Oracle EBS 12R INV (Inventory) Views

Oracle EBS Suffixes