培訓oracle庫存數(shù)據(jù)表結(jié)構(gòu)

庫存基礎(chǔ)數(shù)據(jù)表結(jié)構(gòu)文檔版本1.0課程內(nèi)容完成本課后，您應該能夠執(zhí)行以下操作：解釋定義庫存物料確定定義物料中使用的主要表單解釋庫存事務處理活動確定庫存事務處理中使用的主要表單在SQL

*Plus中針對相應的數(shù)據(jù)庫表運行查詢，以查找 特定的庫存物料，以及它的狀態(tài)和周期盤點。庫存事務處理開放性接口課程目標理解庫存相關(guān)表之間的關(guān)聯(lián)關(guān)系，各個表的主鍵以及常 用字段的含義。Oracle庫存InventoryOrder

entryInternalshipmentReceiveDeliverInspectTransferShopfloorInventorySupplierShipmentExpense庫存數(shù)據(jù)概覽結(jié)構(gòu)圖MTL_PARAMETERSLOCATORSUBINVENTORYMTL_MATERIAL_TRANSACTIONSMTL_SYSTEM_ITEMS_BHR_ALL_ORGANIZATION_UNITSMTL_ONHAND_QUANTITIESMTL_TRANSACTION_ACCOUNTSMTL_SYSTEM_ITEMS_TL庫存組織組織結(jié)構(gòu)圖GL_CODE_COMBINATIONSGL_SETS_OF_BOOKSMTL_INTERORG_PARAMETERSHR_ALL_ORGANIZATION_UNITSHR_ORGANIZATION_INFORMATIONMTL_PARAMETERS庫存組織：HR.HR_ALL_ORGANIZATION_UNITS位置：設(shè)置->組織->組織庫存組織：HR.HR_ALL_ORGANIZATION_UNITS常用視圖（庫存組織）：ORG_ORGANIZATION_DEFINITIONSORGANIZATION_IDORGANIZATION_CODEORGANIZATION_NAMESET_OF_BOOKS_IDCHART_OF_ACCOUNTS_IDOPERATING_UNIT庫存組織ID庫存組織編碼庫存組織名稱分類賬ID會計科目結(jié)構(gòu)ID業(yè)務實體ID庫存組織：HR.HR_ALL_ORGANIZATION_UNITS常用視圖（業(yè)務實體）：HR_ORGANIZATION_UNITSORGANIZATION_IDNAME業(yè)務實體ID業(yè)務名稱庫存組織參數(shù)：MTL_PARAMETERS位置：設(shè)置->組織->參數(shù)庫存：子庫和貨位MTL_SECONDARY_LOCATORSMTL_ITEM_LOCATIONSMTL_ITEM_SUB_INVENTORIESMTL_SECONDARY_INVENTORIESGL_CODE_COMBINATIONSMTL_SYSTEM_ITEMS_BMTL_PARAMETERSMTL_SYSTEM_ITEMS_TL子庫存表：MTL_SECONDARY_INVENTORIES位置：設(shè)置->組織->子庫存子庫存表：MTL_SECONDARY_INVENTORIESSECONDARY_INVENTORY_NAMEORGANIZATION_ID子庫存名稱庫存組織ID相關(guān)連的表（子庫存物料信息表）：MTL_ITEM_SUB_INVENTORIESINVENTORY_ITEM_IDSECONDARY_INVENTORY_NAMEORGANIZATION_ID物料ID子庫存名稱庫存組織ID貨位表：MTL_ITEM_LOCATIONS位置：設(shè)置->組織->庫存貨位貨位表：MTL_ITEM_LOCATIONSINVENTORY_LOCATION_IDORGANIZATION_IDSUBINVENTORY_CODE貨位ID庫存組織ID子庫編碼相關(guān)連的表（子庫存物料信息表）：MTL_SECONDARY_LOCATORSINVENTORY_ITEM_IDSECONDARY_INVENTORY_NAMEORGANIZATION_ID物料ID子庫存名稱庫存組織ID子庫存表：MTL_SECONDARY_INVENTORIESSECONDARY_INVENTORY_NAMEORGANIZATION_ID子庫存名稱庫存組織ID相關(guān)連的表（子庫存物料信息表）：MTL_ITEM_SUB_INVENTORIESINVENTORY_ITEM_IDSECONDARY_INVENTORY_NAMEORGANIZATION_ID物料ID子庫存名稱庫存組織ID庫存：主物料MTL_ITEM_ATTRIBUTESMTL_SYSTEM_ITEMS_BMTL_ITEM_STATUSMTL_ITEM_TEMPL_ATTRIBUTESMTL_ITEM_TEMPLATESMTL_STATUS_ATTRIBUTE_VALUESMTL_PARAMETERS物料表：INV.MTL_SYSTEM_ITEMS_B位置：物料->主組織物料物料表：INV.MTL_SYSTEM_ITEMS_BORGANIZATION_ID

NUMBER組織代碼INVENTORY_ITEM_ID

NUMBER物料IDSEGMENT1

VARCHAR2(40)物料編碼PRIMARY_UNIT_OF_MEASURE基本度量單位

ITEM_TYPE項目類型物料模版：MTL_ITEM_TEMPLATES物料現(xiàn)有量：MTL_ONHAND_QUANTITIES庫存：物料控制MTL_LOT_NUMBERSMTL_SERIAL_NUMBERSMTL_ITEM_REVISIONSMTL_SYSTEM_ITEMS_B序列號庫存：物料狀態(tài)MTL_ITEM_ATTRIBUTESMTL_STATUS_ATTRIBUTE_VALUESMTL_ITEM_STATUSMTL_SYSTEM_ITEMS_BMTL_PENDING_ITEM_STATUS庫存：物料狀態(tài)庫存：物料狀態(tài)庫存：物料類別MTL_ITEM_CATEGORIESMTL_SYSTEM_ITEMS_BMTL_CATEGORIES_BMTL_CATEGORY_SET_VALID_CATSFND_ID_FLEX_STRUCTURESMTL_CATEGORY_SETS_BMTL_DEFAULT_CATEGORY_SETSMTL_CATEGORIES_TLMTL_CATEGORY_SETS_TL庫存：物料類別庫存：物料類別庫存：物料類別庫存：目錄MTL_DESCRIPTIVE_ELEMENTSMTL_DESCR_ELEMENT_VALUESMTL_ITEM_CATALOG_GROUPSMTL_SYSTEM_ITEMS_B庫存：目錄庫存：目錄Oracle庫存事務處理流程RCV_TRANSACTIONS_INTERFACEMTL_TRANSACTIONS_INTERFACEMTL_MATERIAL_TRANSACTIONS_TEMPMTL_MATERIAL_TRANSACTIONSMTL_TRANSACTION_ACCOUNTSOrder

entryInventory,WIPReceivingOracle庫存事務處理流程RCV_TRANSACTIONS_INTERFACEMTL_TRANSACTIONS_INTERFACEMTL_MATERIAL_TRANSACTIONS_TEMPMTL_MATERIAL_TRANSACTIONSMTL_TRANSACTION_ACCOUNTSOrder

entryInventory,WIPReceiving庫存：物料事務處理和物料控制MTL_UNIT_TRANSACTIONSMTL_MATERIAL_TRANSACTIONSMTL_SYSTEM_ITEMS_BMTL_TRANSACTION_LOT_NUMBERSMTL_ITEM_REVISIONSMTL_SERIAL_NUMBERSMTL_LOT_NUMBERS物料事務處理庫存：實際盤存MTL_MATERIAL_TRANSACTIONSMTL_PHYSICAL_ADJUSTMENTSMTL_SECONDARY_INVENTORIESMTL_PHYSICAL_SUBINVENTORIESMTL_PHYSICAL_INVENTORIESMTL_SYSTEM_ITEMS_BMTL_PHYSICAL_INVENTORY_TAGS庫存：ABC分析MTL_ABC_ASSIGNMENTSMTL_ABC_COMPILE_HEADERSMTL_SYSTEM_ITEMS_BMTL_SECONDARY

INVENTORIESMTL_ABC_COMPILESMTL_ABC_CLASSESMTL_ABC_ASSGN_GROUP_CLASSESMTL_ABC_ASSIGNMENT_GROUPSOracle庫存：周期盤點MTL_CC_SCHED_COUNTXREFSMTL_CYCLE_COUNT_ENTRIESMTL_MATERIAL_TRANSACTIONSMTL_CC_SCHEDULE_REQUESTSMTL_SYSTEM_ITEMS_BMTL_CYCLE_COUNT_ITEMSMTL_CYCLE_COUNT_CLASSESMTL_CYCLE_COUNT_HEADERS庫存：需求和預訂信息MTL_DEMANDMTL_MATERIAL_TRANSACTIONSGL_CODE_COMBINATIONSMTL_GENERIC_DISPOSITIONSMTL_SYSTEM_ITEMS_BOE_ORDER_HEADERS_ALLOE_ORDER_LINES_ALLMTL_SALES_ORDERSMTL_DEMAND_INTERFACE庫存事務處理開放式接口表InterfaceNameTransactionsDataFlowDirectionInboundTable,View,

orProcessTableTable,

View,

or

Module

nameMTL_TRANSACTIONS_INTERFACEMTL_SERIAL_NUMBERS_INTERFACEMTL_TRANSACION_LOTS_INTERFACEDemandInterfaceInboundTableMTL_DEMAND_INTERFACEReplenishmentInboundTableMTL_REPLENISH_HEADERS_INTMTL_REPLENISH_LINES_INT物料事務處理接口供應與需求接口庫存設(shè)置開放式接口表InterfaceNameData

FlowDirectionTable,

View,or

ProcessTable,

View,

or

Module

Nam