You are browsing the archive for Technical Design.

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

Oracle Inventory Forms

Oracle Inventory Forms:

FORM SHORT CODEORACLE FORM NAME
INVAAACPCompile ABC Analysis
INVADAASDefine ABC Assignments
INVADACAUpdate ABC Assignments
INVADACLDefine ABC Classes
INVADAGRDefine ABC Groups
INVADCITDefine Cycle Count Items
INVADCSCEnter Manual Schedule Requests
INVADCYCDefine Cycle Count
INVADPAPApprove Physical Inventory Adjustments
INVADPPIDefine Physical Inventory
INVADPTEEnter Physical Inventory Counts
INVADPVTVoid Physical Inventory Tags
INVAMCAPApprove Cycle Count Adjustments
INVARPGTGenerate Physical Inventory Tags
INVATCENEnter Cycle Counts
INVCCEOICycle Count Entries Open Interface
INVCCEXPExport Cycle Count Entries
INVDDARLDefine Available to Promise Rule
INVDDFRLDefine Forecast Rule
INVDDFSSEnter Item Safety Stocks
INVDRMRSReserve Available Inventory
INVDVATPView Item Available to Promise Information
INVDVDSDView Item Supply/Demand Information
INVDVFDHView Demand History Information
INVDVINTView Demand Interface
INVDVRIRView Item Reservations
INVGEZONDefine Economic Zones
INVGMSTPMovement Statistics Parameters
INVICITMCustomer Items
INVICXRFCustomer Item Cross References
INVIDCATDefine Category
INVIDCTLDefine Item Attribute Controls
INVIDICGDefine Item Catalog Group
INVIDITMItem
INVIDMPNDefine Manufacturer Part Numbers
INVIDSCSDefine Category Set
INVIDSUBDefine Item/Subinventory Information
INVIDTMPDefine Item Template
INVIDXRTDefine Cross-Reference Types
INVINLOGOracle Inventory
INVISDRIDefine Item Relationships
INVISDSTDefine Default Category Sets
INVISMPSDefine Pending Statuses
INVITSNUUpdate Serial Number Information
INVIVATTView Item Attributes
INVIVCSUSearch Items
INVIVSTIView Item Information
INVKBCRDKanban Cards
INVKBPSQPull Sequences
INVPPRDFDefine Pick/Put Away Rules
INVPPRSUView Pick/Put Away Rule/Strategy Usage
INVPPSAFAssign Pick/Put Away Strategies to Business Objects
INVPPSDFDefine Pick/Put Away Strategies
INVPPSOFDefine Pick/Put Away Strategy Search Order
INVPTRPRReplenishment Counts
INVRSVF1Reserve Available Supply
INVRSVF2View Reservations Interface
INVSAFDHDefine Stock Locator
INVSDCASDefine Category Accounts
INVSDFAADefine Account Alias
INVSDFCRAssign Carrier Distribution Accounts
INVSDICCCustomer Item Commodity Codes
INVSDICRDefine Intercompany Relations
INVSDOCLDefine Unit of Measure Classes
INVSDODLDefine Item Transaction Default Locators
INVSDODSDefine Item Transaction Default Subinventories
INVSDOIODefine Organization Parameters
INVSDOISDefine Status
INVSDOPRDefine Picking Rule
INVSDORADefine Organization Access
INVSDOSIDefine Inter-Organization Shipping Information
INVSDOUCDefine Unit of Measure Conversions
INVSDSUBDefine Subinventory
INVSDUOMUnits of Measure
INVSHDPAShortage Parameters
INVSHINQView Shortages
INVTDILTUpdate Item Lot Information
INVTDTRSDefine Transaction Reasons
INVTDTSRDefine Transaction Source Types
INVTDTTYDefine Transaction Type
INVTMLPRPurge Transaction History
INVTMSMGRequest Interface Managers
INVTOMAIMove Orders
INVTOTRXTransact Move Orders
INVTRMQTRequest Multi-Org Item Quantities Report
INVTTELTEnter Lot Numbers
INVTTESREnter Serial Numbers
INVTTGGLTransfer Transactions to General Ledger
INVTTGPMCost Periods
INVTTMTXInventory Transactions
INVTTMVPDefine Movement Parameters
INVTTMVTEnter Movement Statistics
INVTTRINInspect Customer Returns
INVTVPTXView Pending Interface Activity
INVTVQOHView Quantities On Hand
INVTVTMPView Pending Transactions
INVTVTUSView Transaction Summaries
INVTVTXNView Transactions
INV_MOB_INQUIRYMobile Item Inquiry
INV_MOB_LPN_INQUIRYMobile LPN Inquiry
INV_MOB_STATUS_INQUIRYMobile Material Status Inquiry
INVIDGRNEdit Category People
INV_JOB_MOMobile Mfg Pick
INVGMVRSMovement Statistics Validation Rules
INVMATWBMaterial Workbench
INVLSATTDefine Desc Flex Context Mapping
INVMSDEFDefine Material Status
WMS_ASN_RECEIPTMobile ASN Receipt
WMS_INSPECTMobile Inspect LPN
WMS_RETURNMobile Returns
WMS_LPN_SHIPMobile LPN Ship Confirm
INV_MOB_LOT_SPLITMobile Lot Split
INV_MOB_LOT_MERGEMobile Lot Merge
INV_MOB_UPDATE_CGMobile Cost Group Update
INV_MOB_GEN_RECEIVEMobile Gen Receive
INV_MOB_SER_SUB_XFRMobile Serial Sub Transfer
INV_MOB_SER_COUNTMobile Serial Count
INVCNSUPConsigned/VMI Consumption
INV_PRINTER_SIGNONMobile Printer Sign-On
INV_LABEL_HISTORYMobile Label History and Reprint
INVGITMTCopy Item Attributes
INVGCPOGEnter Copy Organization Information
INV_MOB_RECEIVEMobile Receive
INV_MOB_INSPECTMobile Inspect
INV_MOB_DELIVMobile Deliver
INV_MOB_MO_PICKMobile Move Order Pick
INV_MOB_EZSHIPMobile EZ Ship
INV_MOB_SHIPMobile Ship Confirm
INV_MOB_MO_REPLMobile Move Order Replenishment
INV_MOB_REPL_KANBANMobile Replenish Kanban
INV_MOB_MO_KANBANMobile Move Order Kanban
INV_MOB_CYCL_COUNTMobile Cycle Count
INV_MOB_PHYS_COUNTMobile Physical Count
INV_LABELSMobile Label Request
INV_MOB_KANBAN_INQUIRYMobile Kanban Inquity
WMS_LPN_UNLOADMobile LPN Unload
INV_MOB_LOT_TRANSLATEMobile Lot Translate
INVSICTFDefine Intercompany Transaction Flows
INVSDLUCLot Specific Conversion
INVGENLTGenerate Multiple Lots
INVMWBIVMaterial Workbench New
INVPCKRLEnhanced Inventory Picking Rule setup
INVGRADEGrades
INVACODEAction Codes
INVPCKLTSelect Available Inventory
INVMSHSTView Message History GUI
INVGIPBDInventory Position Build
INVGIPDPInventory Position Display
INV_MOB_RCPTMobile Inventory Receipts
INV_MOB_ISSMobile Inventory Issue
INV_MOB_MO_ISSMobile Move Order Issue
INV_MOB_SUB_XFERMobile Sub Transfer
INV_MOB_MO_XFERMobile Move Order Transfer
INV_MOB_ORG_XFERMobile Org Transfer
INV_MOB_MO_ALLMobile Move Order All
FORM SHORT CODEORACLE FORM NAME
INVAAACPCompile ABC Analysis
INVADAASDefine ABC Assignments
INVADACAUpdate ABC Assignments
INVADACLDefine ABC Classes
INVADAGRDefine ABC Groups
INVADCITDefine Cycle Count Items
INVADCSCEnter Manual Schedule Requests
INVADCYCDefine Cycle Count
INVADPAPApprove Physical Inventory Adjustments
INVADPPIDefine Physical Inventory
INVADPTEEnter Physical Inventory Counts
INVADPVTVoid Physical Inventory Tags
INVAMCAPApprove Cycle Count Adjustments
INVARPGTGenerate Physical Inventory Tags
INVATCENEnter Cycle Counts
INVCCEOICycle Count Entries Open Interface
INVCCEXPExport Cycle Count Entries
INVDDARLDefine Available to Promise Rule
INVDDFRLDefine Forecast Rule
INVDDFSSEnter Item Safety Stocks
INVDRMRSReserve Available Inventory
INVDVATPView Item Available to Promise Information
INVDVDSDView Item Supply/Demand Information
INVDVFDHView Demand History Information
INVDVINTView Demand Interface
INVDVRIRView Item Reservations
INVGEZONDefine Economic Zones
INVGMSTPMovement Statistics Parameters
INVICITMCustomer Items
INVICXRFCustomer Item Cross References
INVIDCATDefine Category
INVIDCTLDefine Item Attribute Controls
INVIDICGDefine Item Catalog Group
INVIDITMINVIDITM
INVIDMPNDefine Manufacturer Part Numbers
INVIDSCSDefine Category Set
INVIDSUBDefine Item/Subinventory Information
INVIDTMPDefine Item Template
INVIDXRTDefine Cross-Reference Types
INVINLOGOracle Inventory
INVISDRIDefine Item Relationships
INVISDSTDefine Default Category Sets
INVISMPSDefine Pending Statuses
INVITSNUUpdate Serial Number Information
INVIVATTView Item Attributes
INVIVCSUSearch Items
INVIVSTIView Item Information
INVKBCRDKanban Cards
INVKBPSQPull Sequences
INVPPRDFDefine Pick/Put Away Rules
INVPPRSUView Pick/Put Away Rule/Strategy Usage
INVPPSAFAssign Pick/Put Away Strategies to Business Objects
INVPPSDFDefine Pick/Put Away Strategies
INVPPSOFDefine Pick/Put Away Strategy Search Order
INVPTRPRReplenishment Counts
INVRSVF1Reserve Available Supply
INVRSVF2View Reservations Interface
INVSAFDHDefine Stock Locator
INVSDCASDefine Category Accounts
INVSDFAADefine Account Alias
INVSDFCRAssign Carrier Distribution Accounts
INVSDICCCustomer Item Commodity Codes
INVSDICRDefine Intercompany Relations
INVSDOCLDefine Unit of Measure Classes
INVSDODLDefine Item Transaction Default Locators
INVSDODSDefine Item Transaction Default Subinventories
INVSDOIODefine Organization Parameters
INVSDOISDefine Status
INVSDOPRDefine Picking Rule
INVSDORADefine Organization Access
INVSDOSIDefine Inter-Organization Shipping Information
INVSDOUCDefine Unit of Measure Conversions
INVSDSUBDefine Subinventory
INVSDUOMUnits of Measure
INVSHDPAShortage Parameters
INVSHINQView Shortages
INVTDILTUpdate Item Lot Information
INVTDTRSDefine Transaction Reasons
INVTDTSRDefine Transaction Source Types
INVTDTTYDefine Transaction Type
INVTMLPRPurge Transaction History
INVTMSMGRequest Interface Managers
INVTOMAIMove Orders
INVTOTRXTransact Move Orders
INVTRMQTRequest Multi-Org Item Quantities Report
INVTTELTEnter Lot Numbers
INVTTESREnter Serial Numbers
INVTTGGLTransfer Transactions to General Ledger
INVTTGPMCost Periods
INVTTMTXInventory Transactions
INVTTMVPDefine Movement Parameters
INVTTMVTEnter Movement Statistics
INVTTRINInspect Customer Returns
INVTVPTXView Pending Interface Activity
INVTVQOHView Quantities On Hand
INVTVTMPView Pending Transactions
INVTVTUSView Transaction Summaries
INVTVTXNView Transactions
INV_MOB_INQUIRYMobile Item Inquiry
INV_MOB_LPN_INQUIRYMobile LPN Inquiry
INV_MOB_STATUS_INQUIRYMobile Material Status Inquiry
INVIDGRNEdit Category People
INV_JOB_MOMobile Mfg Pick
INVGMVRSMovement Statistics Validation Rules
INVMATWBMaterial Workbench
INVLSATTDefine Desc Flex Context Mapping
INVMSDEFDefine Material Status
WMS_ASN_RECEIPTMobile ASN Receipt
WMS_INSPECTMobile Inspect LPN
WMS_RETURNMobile Returns
WMS_LPN_SHIPMobile LPN Ship Confirm
INV_MOB_LOT_SPLITMobile Lot Split
INV_MOB_LOT_MERGEMobile Lot Merge
INV_MOB_UPDATE_CGMobile Cost Group Update
INV_MOB_GEN_RECEIVEMobile Gen Receive
INV_MOB_SER_SUB_XFRMobile Serial Sub Transfer
INV_MOB_SER_COUNTMobile Serial Count
INVCNSUPConsigned/VMI Consumption
INV_PRINTER_SIGNONMobile Printer Sign-On
INV_LABEL_HISTORYMobile Label History and Reprint
INVGITMTCopy Item Attributes
INVGCPOGEnter Copy Organization Information
INV_MOB_RECEIVEMobile Receive
INV_MOB_INSPECTMobile Inspect
INV_MOB_DELIVMobile Deliver
INV_MOB_MO_PICKMobile Move Order Pick
INV_MOB_EZSHIPMobile EZ Ship
INV_MOB_SHIPMobile Ship Confirm
INV_MOB_MO_REPLMobile Move Order Replenishment
INV_MOB_REPL_KANBANMobile Replenish Kanban
INV_MOB_MO_KANBANMobile Move Order Kanban
INV_MOB_CYCL_COUNTMobile Cycle Count
INV_MOB_PHYS_COUNTMobile Physical Count
INV_LABELSMobile Label Request
INV_MOB_KANBAN_INQUIRYMobile Kanban Inquity
WMS_LPN_UNLOADMobile LPN Unload
INV_MOB_LOT_TRANSLATEMobile Lot Translate
INVSICTFDefine Intercompany Transaction Flows
INVSDLUCLot Specific Conversion
INVGENLTGenerate Multiple Lots
INVMWBIVMaterial Workbench New
INVPCKRLEnhanced Inventory Picking Rule setup
INVGRADEGrades
INVACODEAction Codes
INVPCKLTSelect Available Inventory
INVMSHSTView Message History GUI
INVGIPBDInventory Position Build
INVGIPDPInventory Position Display
INV_MOB_RCPTMobile Inventory Receipts
INV_MOB_ISSMobile Inventory Issue
INV_MOB_MO_ISSMobile Move Order Issue
INV_MOB_SUB_XFERMobile Sub Transfer
INV_MOB_MO_XFERMobile Move Order Transfer
INV_MOB_ORG_XFERMobile Org Transfer
INV_MOB_MO_ALLMobile Move Order All

Inventory Concurrent Programs

Oracle Inventory Concurrent Programs

CONCURRENT PROGRAM SHORT CODECONCURRENT PROGRAM NAME
INCRPRProcess replenishment counts
INCACSGenerate automatic schedule requests
INCACGGenerate cycle count requests
INCACIInitialize cycle count items
INVTRREGTransaction register
INCAPFFreeze physical inventory
INCAAADefine ABC assignments
INCAACCompile ABC analysis
INCAAPPurge ABC information
INCAPTGenerate physical inventory tags
INCTPGPurge transaction history
INCIPSUpdate item statuses with pending statuses
INCFDHSummarize demand histories
INCFIFCompile item forecast
INCAPAPerform physical inventory adjustments
INCACPPurge cycle count information
INCTCCMaterial cost transaction processor
INCRVLValidate replenishment interface
INCRPGPurge replenishment counts
INCAPPPurge physical inventory information
INVTRDSTMaterial account distribution detail
INVTRACSMaterial account distribution summary
INVTRSTSTransaction source type summary
INVTRHANTransaction historical summary
INVARPSLPhysical inventory counts report
INVARPTSPhysical inventory trend and summary analysis
INVARPIAPhysical inventory accuracy analysis
INVIRCATItem categories report
INVIRITSItem definition summary
INVPRFRLForecast rule listing
INVIRILCLocator quantities report
INVTRELTExpired lots report
INVTRVLTVendor lot trace report
INVARPARPhysical inventory adjustments report
INVARPMTPhysical inventory missing tag listing
INVARCTACycle count entries and adjustments report
INVIRTMPItem template listing
INVARCPACycle counts pending approval
INVARADVABC descending value report
INVARAASABC assignments report
INVIRXRFItem cross-references listing
INVIRRITItem relationships listing
INVIRDISItem statuses report
INCDCMProcess demand interface
INCTCMProcess transaction interface
INCTCWInventory transaction worker
INVAOPRInventory Option Report
INVSRLOCLocator listing
INVSROPTOrganization parameters listing
INVSRSUBSubinventory listing
INVDRRSVItem reservations report
INVTRCLSPeriod close value summary
INVARPTGPhysical inventory tag listing
INVIRSNOSerial number detail
INCIDVCreate item flexfield view
INVIRDSTStatus attributes listing
INVPRFDHItem demand history report
INVSRIOSInter-organization shipping information listing
INVSRAALAccount alias listing
INVSRFRTFreight carrier listing
INVSRSHMShip Method Report
INVIRMOQMultiple organization item quantities summary
INVSRPLNPlanner listing
INVIRSIQSubinventory quantities report
INVIRROPReorder point planning report
INVARCLICycle count listing
INVARORECycle count open requests listing
INVARRTACycle count schedule requests report
INVARUIRCycle count unscheduled items report
INVARHMACycle count hit/miss analysis
INVIRISQItem quantities summary
INVTRSNTSerial number transaction register
INVTRLNTLot transaction register
INVIRSLOInactive items report
INVSRUOMUnit of measure listing
INVIRITDItem definition detail
INVIRRCRItem replenishment count report
BOMRDDELDelete items report
INVSRISAItem-subinventory report
INCOINItem Open Interface
INCIAPCreate Intercompany AP Invoices
INCIARCreate Intercompany AR Invoices
INCTSN_SRSSerial Generation
INVTMLPRTransaction Purge
INVSTMVTMovement Statistics Report (INTRASTAT Report)
BOMRDDELGDelete Items Report
INCDSSReload safety stocks
INXATPRemote ATP
INXDSDRemote Supply Demand
INXTPURemote Transaction Processor
INVARPTPPhysical Inventory Tags
INVIRCOCCustomer Item Commodity Codes Listing
INVIRCXRCustomer Item Cross References Report
INVIRCITCustomer Items Report
INVIRMMXMin-max planning report – superceded
INVISMMXMin-max planning report
INVCIINTImport Customer Items – Open Interface
INVCIINTXImport Customer Item Cross References – Open Interface
INVMRMQTView Multiple  Organization  Quantity Report
INVM2MQTView Multiple Organization Quantity Report (180 col format)
INVKBCGNGenerate Kanban Cards
INVKBCPRPrint Kanban Cards
MRPATPRSCalculate Resource Supply for ATP
INVTURNSSummarize Balances
INVSRSPTShortage Parameter report
INVSHPRCMaterial Shortage Check Processor
INVTRSHSShortages Summary report
INVTOPKLMove Order Pick List
INVCMVTMovement Statistics Processor
INVCMVTSTMovement Statistics Reset Status
INVIOICRERequest Set IOI CREATE Parallel Processing
IOICREATE5Request Set Stage IOICREATE5 -  Request Set IOI CREATE Parallel Processing
INVIOIUPDRequest Set IOI UPDATE Parallel Processing
IOIUPDATE5Request Set Stage IOIUPDATE5 -  Request Set IOI UPDATE Parallel Processing
MTL_CCEOI_EXPORTExports cycle count entries into the cycle count entries open interface in batch mode
MTL_CCEOI_IMPORTImports cycle count entries interface data into apps cycle count entry table in batch mode
MTL_CCEOI_WORKERCycle Count Entries Open Interface Worker
MTL_CCEOI_PURGEPurge cycle count entries open interface in batch mode
INVCCIERPrint cycle count entries interface data in batch mode
INXTCWRemote Transaction Processor
INVTURNITMSSummarize Balances at Item Level for Open Periods
INVRSVINReservations Interface Manager
INXGRPRemote group demand processor
INVGIAUPConcurrent Program To Call Item Update API Offline
INVGIDEPMovement Statistics Data Export
INVCPRGMovement Statistics Transaction Purging
INVCHGPUInventory Charges and Product Usage Report
INVCCTCATransaction by CC and Account
SERIAL_NUMBER_GENERATIONSerial Generation
INVLSUPGUpgrade Lot and Serial Attributes
INVGCORPReport – Copy Inventory Organization
INVMSWHUMaterial Status Where-Used Report
INVMSCHRMaterial Status Change History Report
INV_ITEM_CAT_GRP_ELE_OIItem Catalog Group Element Open Interface
INVONHSPReport to show VMI Onhand Quantity
INVCPCLOSLarge Organization  – Run Close Period Control
INVCPOPENLarge Organization – Run Open Period Control
INVGTPGGlobal Transaction Purge
INV_ITEM_CAT_ASSIGN_OIImport item category assignments from the Open Interface table
INVISCORMass-generate new organizations from a model organization
INVLOTAGAge Update For Lot Attributes
INVMBTRXINV Transaction Worker
INVGIPPRInventory positions processor
INVGIPPGInventory positions purge by data set, user, creation date
INVGIPPAInventory positions purge all
INCTPKPick Release Server
INVCGUGBConcurrent Program for Costgroup upgrade for closed periods
AZAPITESTERiSetup API  testing concurrent program – For Internal Developer use only. Not for generic use. The program must be DISABLED
INVMOPGProgram of Move Order Purge
INVCTXNMCreate Consumption Advice
INVCTXCWConsumption worker
INVITEMORG_ASSIGNItem Organization Assignment
INVORGESOrganization Hierarchy Exceptions Report
INVISCORPCopy Inventory Organization Interface Data Purge
INVCORPPCopy Inventory Organization Report Data Purge
INVTPGWBTransaction Purge Worker
INVRCWSRPAR Replenishment Count Worksheet
INV_CREATE_DEF_TXNSCreate Deferred Logical Transactions
INVMVTEXMovement Statistics Exception Report
INVCCIDPConsigned Inventory Diagnostics
INVLOCGenerate Stock Locator Flexfield definition for Mobile Transactions
INVLTGENGenealogy Reports
INVGRACHGGrade Change History Report
INVMATSTAMaterial Status Definition Report
INVLOTMASLot Master Report
INVLOTINVLot Inventory Report
INVLSDATLot And Serial Date Notification
INVPOPSRPurchasing Packing Slip
INVINPSRInventory Packing Slip
INV_CONSOLIDATE_ONHANDConsolidate Onhand Quantites for Inventory Organizations
INV_RSV_UPGRADEThis program upgrades the reservations from 11.5.10 and earlier to R12
INVARCPA_XMLCycle counts pending approval
INVARCTA_XMLCycle count entries and adjustments report
INVARHMA_XMLCycle count hit/miss analysis
INVARPAR_XMLPhysical inventory adjustments report
INVARPMT_XMLPhysical inventory missing tag listing
INVARPSL_XMLPhysical inventory counts report
INVARPTG_XMLPhysical inventory tag listing
INVARPTP_XMLPhysical Inventory Tags
INVARPTS_XMLPhysical inventory trend and summary analysis
INVARRTA_XMLCycle count schedule requests report
INVARUIR_XMLCycle count unscheduled items report
INVCCIER_XMLPrint cycle count entries interface data in batch mode
INVDRRSV_XMLItem reservations report
INVINPSR_XMLInventory Packing Slip
INVIRCAT_XMLItem categories report
INVIRCIT_XMLCustomer Items Report
INVIRCOC_XMLCustomer Item Commodity Codes Listing
INVIRCXR_XMLCustomer Item Cross References Report
INVIRDIS_XMLItem statuses report
INVIRDST_XMLStatus attributes listing
INVIRISQ_XMLItem quantities summary
INVIRITD_XMLItem definition detail
INVTRELT_XMLExpired lots report
INVTRHAN_XMLTransaction historical summary
INVTRLNT_XMLLot transaction register
INVTRREG_XMLTransaction register
INVTRSHS_XMLShortages Summary report
INVTRSNT_XMLSerial number transaction register
INVTRSTS_XMLTransaction source type summary
INVTRVLT_XMLVendor lot trace report
BOMRDDELG_XMLDelete Items Report
BOMRDDEL_XMLDelete items report
INVSRSUB_XMLSubinventory listing
INVSRUOM_XMLUnit of measure listing
INVSTMVT_XMLMovement Statistics Report (INTRASTAT Report)
INVTOPKL_XMLMove Order Pick List
INVUPMSTActivate Onhand Level Material Status Tracking
INV_EBI_PUBLISH_ECOPublish Engineering Change Order Updates
INV_EBI_PUBLISH_ITEM_ATTRPublish Item Attributes Updates
INV_EBI_PUBLISH_ITEM_BALPublish Item Balance Updates
INVARAAS_XMLABC assignments report
INVARORE_XMLCycle count open requests listing
INVARPIA_XMLPhysical inventory accuracy analysis
INVIRILC_XMLLocator quantities report
INVIRITS_XMLItem definition summary
INVIRRCR_XMLItem replenishment count report
INVIRRIT_XMLItem relationships listing
INVIRSIQ_XMLSubinventory quantities report
INVIRSLO_XMLInactive items report
INVIRSNO_XMLSerial number detail
INVIRTMP_XMLItem template listing Report
INVIRXRF_XMLItem cross-references listing
INVISMMX_XMLMin-max planning report
INVKBCPR_XMLPrint Kanban Cards
INVMSCHR_XMLMaterial Status Change History Report
INVMSWHU_XMLMaterial Status Where-Used Report
INVMVTEX_XMLMovement Statistics Exception Report
INVORGES_XMLOrganization Hierarchy Exceptions Report
INVPOPSR_XMLPurchasing Packing Slip
INVPRFDH_XMLItem demand history report
INVPRFRL_XMLForecast rule listing
INVRCWSR_XMLPAR Replenishment Count Worksheet
INVSRAAL_XMLAccount alias listing
INVSRFRT_XMLFreight carrier listing
INVSRIOS_XMLInter-organization shipping information listing
INVSRISA_XMLItem-subinventory report
INVSRLOC_XMLLocator listing
INVSROPT_XMLOrganization parameters listing
INVSRPLN_XMLPlanner listing
INVSRSPT_XMLShortage Parameter report
INVTRACS_XMLMaterial account distribution summary
INVTRCLS_XMLPeriod close value summary
INVTRDST_XMLMaterial account distribution detail
INVARADV_XMLABC descending value report
INVARCLI_XMLCycle count listing