Oracle Inventory Key Tables
September 19, 2010 in Technical Design
- INV_DIAG_MSN_TEMP
- Temporary table for diagnostic temporary table.
- INV_ITEM_TEMP
- Temporary table used when mass deleting items.
- MTL_ABC_ASSGN_GROUP_CLASSES
- Stores ABC groups and ABC classes assignment information
- MTL_ABC_ASSIGNMENTS
- Stores the relationship between items, ABC Classes & ABC groups.
- MTL_ABC_ASSIGNMENT_GROUPS
- Maintains the information related to ABC groups created
- MTL_ABC_CLASSES
- Maintains the information related to ABC Classes.
- MTL_ABC_COMPILES
- Maintains the ABC complie information. When Compile program runs it generates quantity, value for each item and based on given criteria it sorts information for ABC classs assignments.
- MTL_ABC_COMPILES_EFC
- Supports EURO conversion, copies the MTL_ABC_COMPLIES data and converts into EURO value.
- MTL_ABC_COMPILE_HEADERS
- MTL_ABC_COMPILE_HEADERS_EFC
- MTL_ACTIONS_B
- MTL_ACTIONS_TL
- MTL_ACTUAL_COST_SUBELEMENT
- MTL_ACTUAL_COST_SUBELEMENT_EFC
- MTL_ATP_RULES
- MTL_ATTR_APPL_DEPENDENCIES
- MTL_BIS_INV_BY_PERIOD
- MTL_CATALOG_SEARCH_ITEMS
- MTL_CATEGORIES_B
- MTL_CATEGORIES_TL
- MTL_CATEGORY_ACCOUNTS
- MTL_CATEGORY_SETS_B
- MTL_CATEGORY_SETS_TL
- MTL_CATEGORY_SET_VALID_CATS
- MTL_CC_ENTRIES_INTERFACE
- MTL_CC_INTERFACE_ERRORS
- MTL_CC_SCHEDULE_REQUESTS
- MTL_CC_SCHED_COUNT_XREFS
- MTL_CC_SERIAL_NUMBERS
- MTL_CC_SUBINVENTORIES
- MTL_CHILD_LOT_NUMBERS
- MTL_CI_INTERFACE
- MTL_CI_XREFS_INTERFACE
- MTL_COGS_RECOGNITION_TEMP
- MTL_COMMODITY_CODES
- MTL_CONSIGNED_DIAG_ERRORS
- MTL_CONSUMPTION_DEFINITION
- MTL_CONSUMPTION_TRANSACTIONS
- MTL_CONSUMPTION_TXN_TEMP
- MTL_COPY_ORG_INTERFACE
- MTL_COPY_ORG_REPORT
- MTL_COUNTRY_ASSIGNMENTS
- MTL_CROSS_REFERENCES
- MTL_CROSS_REFERENCES_B
- MTL_CROSS_REFERENCES_INTERFACE
- MTL_CROSS_REFERENCES_TL
- MTL_CROSS_REFERENCE_TYPES
- MTL_CST_ACTUAL_COST_DETAILS
- MTL_CST_ACTUAL_COST_DETAIL_EFC
- MTL_CST_LAYER_ACT_COST_DETAILS
- MTL_CST_TXN_COST_DETAILS
- MTL_CST_TXN_COST_DETAILS_EFC
- MTL_CUSTOMER_ITEMS
- MTL_CUSTOMER_ITEM_XREFS
- MTL_CYCLE_COUNT_CLASSES
- MTL_CYCLE_COUNT_CLASSES_EFC
- MTL_CYCLE_COUNT_ENTRIES
- MTL_CYCLE_COUNT_ENTRIES_EFC
- MTL_CYCLE_COUNT_HEADERS
- MTL_CYCLE_COUNT_HEADERS_EFC
- MTL_CYCLE_COUNT_ITEMS
- MTL_DEFAULT_CATEGORY_SETS
- MTL_DEMAND
- MTL_DEMAND_HISTORIES
- MTL_DEMAND_INTERFACE
- MTL_DESCRIPTIVE_ELEMENTS
- MTL_DESCR_ELEMENT_VALUES
- MTL_DESC_ELEM_VAL_INTERFACE
- MTL_EAM_ASSET_ACTIVITIES
- MTL_EAM_ASSET_ATTR_GROUPS
- MTL_EAM_ASSET_ATTR_VALUES
- MTL_EAM_ASSET_NUM_INTERFACE
- MTL_EAM_ASSET_SEARCH_TEMP
- MTL_EAM_ATTR_VAL_INTERFACE
- MTL_EAM_LOCATIONS
- MTL_EAM_NETWORK_ASSETS
- MTL_ECONOMIC_ZONES_B
- MTL_ECONOMIC_ZONES_TL
- MTL_ERES_TRANSACTIONS_GTMP
- MTL_EXT_OBJECTS
- MTL_FISCAL_CAT_ACCOUNTS
- MTL_FLEX_CONTEXT
- MTL_FORECAST_RULES
- MTL_GENERIC_DISPOSITIONS
- MTL_GEN_TEMP
- MTL_GRADES_B
- MTL_GRADES_TL
- MTL_GRADE_STATUS_ERES_GTMP
- MTL_ICG_ALIASES
- MTL_ICG_CATEGORIES
- MTL_INTERCOMPANY_PARAMETERS
- MTL_INTERFACE_ERRORS
- MTL_INTERFACE_PROC_CONTROLS
- MTL_INTERORG_PARAMETERS
- MTL_INTERORG_SHIP_METHODS
- MTL_INV_PACKSLIPS
- MTL_INV_PICKING_RULES
- MTL_ITEM_ATTRIBUTES
- MTL_ITEM_ATTRIBUTES_SEED_INFO
- MTL_ITEM_ATTRIBUTES_TEMP
- MTL_ITEM_BULKLOAD_RECS
- MTL_ITEM_CATALOG_GROUPS_B
- MTL_ITEM_CATALOG_GROUPS_TL
- MTL_ITEM_CATEGORIES
- MTL_ITEM_CATEGORIES_INTERFACE
- MTL_ITEM_CHILD_INFO_INTERFACE
- MTL_ITEM_LOCATIONS
- MTL_ITEM_LOC_DEFAULTS
- MTL_ITEM_REVISIONS_B
- MTL_ITEM_REVISIONS_INTERFACE
- MTL_ITEM_REVISIONS_TL
- MTL_ITEM_STATUS
- MTL_ITEM_STATUS_TL
- MTL_ITEM_SUB_DEFAULTS
- MTL_ITEM_SUB_INVENTORIES
- MTL_ITEM_SUB_INVS_INTERFACE
- MTL_ITEM_TEMPLATES
- MTL_ITEM_TEMPLATES_B
- MTL_ITEM_TEMPLATES_TL
- MTL_ITEM_TEMPL_ATTRIBUTES
- MTL_ITEM_VALUES_TEMP
- MTL_KANBAN_CARDS
- MTL_KANBAN_CARD_ACTIVITY
- MTL_KANBAN_CARD_PRINT_TEMP
- MTL_KANBAN_PULL_SEQUENCES
- MTL_KANBAN_TEMPLATES
- MTL_LE_ECONOMIC_ZONES
- MTL_LOT_CONV_AUDIT
- MTL_LOT_CONV_AUDIT_DETAILS
- MTL_LOT_ERES_GTMP
- MTL_LOT_GRADE_HISTORY
- MTL_LOT_NUMBERS
- MTL_LOT_UOM_CLASS_CONVERSIONS
- MTL_LPN_ATR_QTY_GT
- MTL_MANUFACTURERS
- MTL_MATERIAL_STATUSES
- MTL_MATERIAL_STATUSES_B
- MTL_MATERIAL_STATUSES_TL
- MTL_MATERIAL_STATUS_HISTORY
- MTL_MATERIAL_TRANSACTIONS
- MTL_MATERIAL_TRANSACTIONS_EFC
- MTL_MATERIAL_TRANSACTIONS_TEMP
- MTL_MATERIAL_TXN_ALLOCATIONS
- MTL_MFG_PART_NUMBERS
- MTL_MGD_INVENTORY_POSITIONS
- MTL_MOBILE_LOGIN_HIST
- MTL_MOQD_BACKUP
- MTL_MOVEMENT_PARAMETERS
- MTL_MOVEMENT_STATISTICS
- MTL_MOVEMENT_STATISTICS_EFC
- MTL_MVT_STATS_RULES
- MTL_MVT_STATS_RULE_SETS_B
- MTL_MVT_STATS_RULE_SETS_TL
- MTL_MWB_GTMP
- MTL_OBJECT_EVENTS
- MTL_OBJECT_GENEALOGY
- MTL_OBJECT_GENEALOGY_INTERFACE
- MTL_ONHAND_LOCK_TEMP
- MTL_ONHAND_QUANTITIES
- MTL_ONHAND_QUANTITIES_DETAIL
- MTL_ONHAND_QUANTITY_TEMP
- MTL_ORG_REPORT_TEMP
- MTL_PAC_ACTUAL_COST_DETAILS
- MTL_PAC_ACTUAL_COST_DETAIL_EFC
- MTL_PAC_ACT_CST_DTL_TEMP
- MTL_PAC_COST_SUBELEMENTS
- MTL_PAC_COST_SUBELEMENTS_EFC
- MTL_PAC_TXN_COST_DETAILS
- MTL_PAC_TXN_COST_DETAILS_EFC
- MTL_PARAMETERS
- MTL_PENDING_ITEM_STATUS
- MTL_PERIOD_CG_SUMMARY
- MTL_PERIOD_SUMMARY
- MTL_PERIOD_SUMMARY_EFC
- MTL_PER_CLOSE_DTLS
- MTL_PER_CLOSE_DTLS_EFC
- MTL_PHYSICAL_ADJUSTMENTS
- MTL_PHYSICAL_ADJUSTMENTS_EFC
- MTL_PHYSICAL_INVENTORIES
- MTL_PHYSICAL_INVENTORIES_EFC
- MTL_PHYSICAL_INVENTORY_TAGS
- MTL_PHYSICAL_SUBINVENTORIES
- MTL_PICKING_RULES
- MTL_PICK_SLIP_NUMBERS
- MTL_PLANNERS
- MTL_PO_PACKSLIPS
- MTL_PURGE_HEADER
- MTL_QOH_ITEM_TMP
- MTL_QOH_LOCATOR_TMP
- MTL_QOH_LOT_TMP
- MTL_QOH_REV_TMP
- MTL_QOH_SUB_TMP
- MTL_RELATED_ITEMS
- MTL_RELATED_ITEMS_CUST_REF
- MTL_RELATED_ITEMS_INTERFACE
- MTL_RELATED_ITEMS_PLN_INFO
- MTL_REPLENISH_HEADERS
- MTL_REPLENISH_HEADERS_INT
- MTL_REPLENISH_LINES
- MTL_REPLENISH_LINES_INT
- MTL_RESERVATIONS
- MTL_RESERVATIONS_INTERFACE
- MTL_RMA_SERIAL_TEMP
- MTL_RTG_ITEM_REVISIONS
- MTL_RTG_ITEM_REVS_INTERFACE
- MTL_SAFETY_STOCKS
- MTL_SALES_ORDERS
- MTL_SEASONALITY_INDICES
- MTL_SECONDARY_INVENTORIES
- MTL_SECONDARY_LOCATORS
- MTL_SECONDARY_LOCS_INTERFACE
- MTL_SERIAL_NUMBERS
- MTL_SERIAL_NUMBERS_GT
- MTL_SERIAL_NUMBERS_INTERFACE
- MTL_SERIAL_NUMBERS_TEMP
- MTL_SHORT_CHK_PARAM
- MTL_SHORT_CHK_STATEMENTS
- MTL_SHORT_CHK_TEMP
- MTL_SO_RMA_INTERFACE
- MTL_SO_RMA_RECEIPTS
- MTL_STATUS_ATTRIBUTE_VALUES
- MTL_STATUS_TRANSACTION_CONTROL
- MTL_STAT_TYPE_USAGES
- MTL_SUMMARY_TEMP
- MTL_SUM_DEMD_HIST_GT
- MTL_SUPPLY
- MTL_SUPPLY_DEMAND_TEMP
- MTL_SYSTEM_ITEMS_B
- MTL_SYSTEM_ITEMS_B_EFC
- MTL_SYSTEM_ITEMS_INTERFACE
- MTL_SYSTEM_ITEMS_TL
- MTL_TRANSACTIONS_INTERFACE
- MTL_TRANSACTION_ACCOUNTS
- MTL_TRANSACTION_ACCOUNTS_EFC
- MTL_TRANSACTION_FLOW_HEADERS
- MTL_TRANSACTION_FLOW_LINES
- MTL_TRANSACTION_LOTS_INTERFACE
- MTL_TRANSACTION_LOTS_TEMP
- MTL_TRANSACTION_LOT_NUMBERS
- MTL_TRANSACTION_REASONS
- MTL_TRANSACTION_TYPES
- MTL_TRANSFER_TEMP
- MTL_TRANS_REASON_SECURITY
- MTL_TXN_COST_DET_INTERFACE
- MTL_TXN_REQUEST_HEADERS
- MTL_TXN_REQUEST_LINES
- MTL_TXN_SOURCE_TYPES
- MTL_UNITS_OF_MEASURE_TL
- MTL_UNIT_TRANSACTIONS
- MTL_UOM_CLASSES_TL
- MTL_UOM_CLASS_CONVERSIONS
- MTL_UOM_CONVERSIONS
- MTL_UOM_CONVERSIONS_ERES_GTMP
- MTL_UPDATE_RECORDS_TEMP
- MTL_USER_DEMAND
- MTL_USER_SUPPLY
- MTL_VMI_QUANTITIES_TEMP