This document describes Oracle's electronic Technical Reference Manual (eTRM) and the tables in the Oracle Inventory application. It provides an overview of eTRM and how it can be used to view technical database design information from Oracle applications. It then lists and describes key tables related to organizations, items, subinventories, locators, transactions, and other areas of the Oracle Inventory application. These tables store important data for defining organizations, items, categories, statuses, reservations, and processing transactions in Oracle Inventory.
This document describes Oracle's electronic Technical Reference Manual (eTRM) and the tables in the Oracle Inventory application. It provides an overview of eTRM and how it can be used to view technical database design information from Oracle applications. It then lists and describes key tables related to organizations, items, subinventories, locators, transactions, and other areas of the Oracle Inventory application. These tables store important data for defining organizations, items, categories, statuses, reservations, and processing transactions in Oracle Inventory.
This document describes Oracle's electronic Technical Reference Manual (eTRM) and the tables in the Oracle Inventory application. It provides an overview of eTRM and how it can be used to view technical database design information from Oracle applications. It then lists and describes key tables related to organizations, items, subinventories, locators, transactions, and other areas of the Oracle Inventory application. These tables store important data for defining organizations, items, categories, statuses, reservations, and processing transactions in Oracle Inventory.
This document describes Oracle's electronic Technical Reference Manual (eTRM) and the tables in the Oracle Inventory application. It provides an overview of eTRM and how it can be used to view technical database design information from Oracle applications. It then lists and describes key tables related to organizations, items, subinventories, locators, transactions, and other areas of the Oracle Inventory application. These tables store important data for defining organizations, items, categories, statuses, reservations, and processing transactions in Oracle Inventory.
Download as DOCX, PDF, TXT or read online from Scribd
Download as docx, pdf, or txt
You are on page 1/ 7
eTRM:
electronic Technical Reference Manual
ORGANIZATION TABLES MTL_PARAMETERS
Associated with Organization
Primary Key : Organization ID
MTL_INTERORG_PARAMETER S
Identifies Receiving organization linked to a particular org.
Define an Inter-org relationship before you perform any inter-organizational transfers. Contains: Unit of measure, Distance, Transfer charge and Accounting information. Primary Key: FROM_ORGANIZATION_ID , TO_ORGANIZATION_ID
GL_SET OF BOOKS
Stores Defined Set of books in General Ledger
Primary Key: GENERAL_LEDGER_UPDATE_CODE
GL_CODE_COMBINATIONS
Stores valid Accounting Flexfield segment value
combinations for each accounting Flexfield structure in GL. Primary Key: CODE_COMBINATION _ID
HR_ALL_ORGANIZATION_UNI TS
Stores Generic Data about organizations.
Primary Key: ORGANIZATION ID.
SUBINVENTORY & LOCATOR TABLES
MTL_SYSTEM_ITEMS_B
It is the definition table for Items.(Inventory Items,
Primary Key: INVENTORY_ITEM_ID , ORGANIZATION_ID, LANGUAGE
GL_CODE_COMBINATIONS
This table stores valid Accounting Flexfield segment value
combinations for each accounting Flexfield structure within your General Ledger. Primary Key: CODE_COMBINATION _ID
MTL_SECONDARY_INVENTORI ES
It is the definition table for subinventories assigned to an
inventory or engineering items. Primary Key: SECONDARY_INVENTORY_NAME, ORGANIZATION ID.
MTL_ITEM_SUB_INVENTORIES
This table maintains a listing of subinventories assigned to
an inventory or engineering items.
Primary Key: INVENTORY_ITEM_ID, ORGANIZATION_ID,
SECONDARY_INVENTORY. MTL_ITEM_LOCATIONS
This table is the definition table for stock locators.
The associated attributes, describe the subinventory to which this location belongs, and the locator physical capacity. Primary Key: INVENTORY_LOCATION_ID.
MTL_SECONDARY_LOCATORS
This table stores all locators within a subinventory for a
specific item. Primary key: INVENTORY_ITEM_ID, ORGANIZATION_ID, SECONDARY LOCATORS The table stores the parameters for an inventory organization with which an item is associated. Primary Key: ORGANIZATION_ID
MTL_PARAMETERS
ITEM MASTER TABLES
MTL_SYSTEM_ITEMS_B
It is the definition table for Items.(Inventory Items,
This table is the definition table for item templates.
Primary key: TEMPLATE_ID
MTL_ITEM_ATTRIBUTES
This table stores Item Attributes
Primary Key : ATTRIBUTE_NAME
MTL_ITEM_TEMPL_ATTRIBUTES
This table stores the attributes and attributes values for
a template. When the template is applied to an item, the enabled attribute values are propagated to the item. Primary Key: TEMPLATE_ID,ATTRIBUTE_NAME
MTL_ITEM_STATUS_TL
It is definition table for a Material Status Code. The
values of the Individual status attributes associated with an item status are stored in MTL_STATUS_ATTRIBUTE_VALUES. Primary Key: INVENTORY_ITEM_STATUS_CODE
MTL_STATUS_ATTRIBUTE_VALU ES
This table stores the attribute values associated with an
item status code. Primary Key: INVENTORY_ITEM_STATUS_CODE , ATTRIBUTE NAME
MTL_PARAMETERS
This table is an inventory organization with which an
item is associated.
Primary Key: ORGANIZATION_ID
ITEM STATUS TABLES
MTL_SYSTEM_ITEMS_B
It is the definition table for Items.(Inventory Items,
This table stores the attribute values associated with an
item status code. Primary Key: INVENTORY_ITEM_STATUS_CODE , ATTRIBUTE NAME
MTL_ITEM_STATUS_TL
It is the definition table for a material status code. Say
Active, pending or obsolete etc, The values of the Individual status attributes associated with an item status are stored in MTL_STATUS_ATTRIBUTE_VALUES. Primary Key: INVENTORY_ITEM_STATUS_CODE
MTL_PENDING_ITEM_STATUS
The table is used to define and store the history of the
item status that have been or will assigned to an item. This table also stores pending status information. Primary Key: INVENTORY_ITEM_ID; ORGANIZATION_ID; STATUS_CODE; EFFECTIVE DATE.
ITEM CATEGORIES TABLE
MTL_SYSTEM_ITEMS_B
It is the definition table for Items.(Inventory Items,
This table is the code combinations table for items
categories. Primary Key: CATEGORY_ID
MTL_CATEGORIES_TL
This table is a table holding translated description
column for item categories. Primary Key: CATEGORY _ID; LANGUAGE.
MTL_CATEGORIES_SETS_B
This table contains the entity definition for category
sets. A category set is a categorization scheme for a group of items. Primary Key: CATEGORY_SET_ID
MTL_CATEGORY_SETS_TL
This table holds translated Name and Description
columns for category sets. Primary Key: CATEGORY_SET_ID; LANGUAGE.
MTL_CATEGORY_SET_VALID_CA TS
This table defines the valid category list for a particular
category set. If category validation is required, the list of valid categories is stored in this table and is used to restrict category selection for the category set. Primary Key : CATEGORY_SET_ID; CATEGORY_ID
MTL_DEFAULT_CATEGORY_SET S
This table stores the identifier of the category set that
acts as the default for a particular functional area. It is also used to default category set for forms and reports that require a category set field value or parameter. Primary Key: FUNCTIONL_AREA_ID; CATEGORY_SET_ID
MTL_ITEM_CATEGORIES
This table stores the item assignments to categories
within a category set. Items can be assigned to multiple categories and category sets, but can be assigned to only one category in a given category set. Primary Key: INVENTORY_ITEM_ID; ORGANIZATION_ID; CATEGORY_SET_ID.
ITEM RESERVATION TABLES
MTL_DEMAND
This table stores demand and reservation information
used in ATP, Planning, and other manufacturing functions. Four row types are stored in this tables: Summary Demand Rows; Dependent Demand rows ; Open Demand rows; Reservation Rows; Primary Key: INVENTORY_ITEM_ID ; DEMAND_SOURCE_TYPE; DEMAND_SOURCE_HEADER_ID ; DEMAND_SOURCE_LINE(O); DEMAND_SOURCE_DELIVERY(O); COMPONENT_SEQUENCE_ID(o).
MTL_SALES_ORDER
This table stores the oracle inventory local definition of
sales orders and maps sales order between oracle
inventory and other oracle manufacturing applications. Primary Key: SALES_ORDER_ID OE_ORDER_HEADERS_ALL
This table stores header information for orders in oracle
order management. Primary Key: HEADER_ID
OE_ORDER_LINES_ALL
This table stores information for all orders lines in oracle
order management. Primary Key: LINE_ID
GL_CODE_COMBINATIONS
This table stores valid Accounting Flexfield segment value
combinations for each accounting Flexfield structure within your General Ledger. Primary Key: CODE_COMBINATION _ID
MTL_GENERIC_DEPOSITIONS
This table stores the user-defined account alias.
Available inventory can be reserved against an account alias. Primary Key: DISPOSTION_ID ; ORGANIZATION_ID
MTL_MATERIAL_TRANSACTIO NS
This table stores a record of every material transaction or
cost updated performed in inventory. Primary Key: TRANSACTION_ID
MTL_DEMAND_INTERFACE
This table in the interface point between non-inventory
applications and the oracle inventory demand module. Records inserted in this table are processed by the Demand Manager Concurrent Program.
MTL_SYSTEM_ITEMS_B
It is the definition table for Items.(Inventory Items,
application and the inventory application transaction module. Transaction Manger program concurrent polls this table. Processing contains: Data derivation, Validation and Transfer of records from MTL_TRANSACTION_INTERFACE; MTL_TRANSACTION_LOTS_INTERFACE ; & MTL_SERIAL_NUMBERS-INTERFACE.
MTL_MATERIAL_TRANSACTIONS_TE MP
This table is the gateway for all material
transactions. Records are processed from this table into inventory through transaction processor.
MTL_MATERIAL_TRANSACTIONS
This table stores a record of every material
transaction or cost update performed in inventory. Records are inserted into this table either through the transaction processor or by the standard cost program. Primary Key: TRANSACTION_ID
MTL_TRANSACTION_ACCOUNTS
This table holds the accounting information for each
material transaction in MTL_MATERIAL_TRANSACTIONS. Oracle inventory uses this information to track the financial impact of your quantity moves.
USING THE eTRM TO VIEW TECHNICAL INFORMATION:
Database design and dependency information for the oracle E-business suite Entity relationship(ER) or database schema diagrams(available as pdf files for most products) eTRM provides a web based view of Oracle Application data model, and access to schema object definitions and descriptions. eTRM is a PL/SQL utility that enables you to view design information(in an HTML format) from an oracle database. CURRENTLY eTRM is available only from MY ORACLE SUPPORT. eTRM modes: 1.
Search
Enables you to perform search engine queries against
table and column description in the FND model. 2.
FND Model
It is used to access views of the FND model. It displays
Design data for tables, views, concurrent programs, and quick codes. 3.
DBA(data dictionary) This tab provides an HTML form to query the dba_objects
view.
eTRM reports shows:
1.
traditional technical reference manual information
2.
dependency information.
The information that appears depends on the object selected.
