You are browsing the archive for database.

Oracle Inventory Key Tables

  • 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