SubInventory & Locator Tables
发布日期:2021-07-18 15:07:59 浏览次数:0 分类:技术文章

本文共 3325 字,大约阅读时间需要 11 分钟。

Relationship


MTL_SECONDARY_INVENTORIES

MTL_SECONDARY_INVENTORIES is the definition table for the subinventory. A subinventory is a section of inventory,

i.e., raw material, finished goods, etc. Subinventories areassigned to items (in a many to one relationship), indicating a list of valid places where this item will physically exist in inventory.
Other attributes include general ledger accounts, demand picking order, locator type, availability type, and reservabletype.
You can also specify whether this subinventory is anexpense or asset subinventory (ASSET_INVENTORY), or whether quantities are tracked (QUANTITY_TRACKED).

Locator Control Code

LOOKUP_TYPE LOOKUP_CODE MEANING
MTL_LOCATION_CONTROL 3 Dynamic entry locator control
MTL_LOCATION_CONTROL 5 Locator control determined at item level
MTL_LOCATION_CONTROL 4 Locator control determined at subinventory level
MTL_LOCATION_CONTROL 1 No locator control
MTL_LOCATION_CONTROL 2 Prespecified locator control


MTL_ITEM_SUB_INVENTORIES

MTL_ITEM_SUB_INVENTORIES maintains a listing of subinventories assigned to an inventory or engineering item.

These subinventories make up the list of valid subinventories when transacting this specific item and the user has specified (in the master window) that the item must use subinventories restricted to a pre-defined list.



MTL_ITEM_LOCATIONS

MTL_ITEM_LOCATIONS is the definition table for stock locators. The associated attributes describe which subinventory this locator belongs to, what the locator physical capacity is, etc.
.
The locator is a key flexfield. The Flexfield Code is MTLL.

This Table is use to record the definition of Locator(Though this table name is defined so confusing)


MTL_SECONDARY_LOCATORS

MTL_SECONDARY_LOCATORS stores all locators within a subinventory for a specific item.
These locators make up the valid list of locators when transacting that specific item to/from the subinventory, and theuser has specified (in the Master Item window) that the item must use locators restricted to a pre-defined list.

This Table is use to record the relation of Item, Subinventory and Locator,U can refer below picture

1.Define a subinv,andset locator control to ‘pre-defined’

2.Define a locator at locatorform

You will find there will generate a newrecord in Table: MTL_ITEM_LOCATIONS

But in table: MTL_SECONDARY_LOCATORS,there still not record about this new locator.


Define a plain Subinventory,Then check mtl_second_inventory,foundrelated record created.

SELECT * FROM MTL_SECONDARY_INVENTORIES WHERE secondary_inventory_name = 'ptsub_01';

--One record returned

SELECT * FROM MTL_ITEM_SUB_INVENTORIES WHERE secondary_inventory = 'ptsub_01';

--No record returned.


SELECT * FROM MTL_SECONDARY_INVENTORIESWHERE secondary_inventory_name = 'ptsub_01';

--One record returned

SELECT * FROM MTL_ITEM_SUB_INVENTORIESWHERE secondary_inventory = 'ptsub_01';

--One record returned


SELECT * FROM MTL_ITEM_LOCATIONS WHERE subinventory_code = 'ptsub_01'

--two records returned(inventory_item_id = null)

SELECT * FROM MTL_SECONDARY_LOCATORS WHERE subinventory_code = 'ptsub_01'

--no rows return



SELECT inventory_item_id FROM MTL_ITEM_LOCATIONS WHERE subinventory_code ='ptsub_01'

--two records returned (inventory_item_id = null)

SELECT * FROM MTL_SECONDARY_LOCATORS WHERE subinventory_code = 'ptsub_01'

--two records returned


转载地址:https://blog.csdn.net/iteye_21199/article/details/82479101 如侵犯您的版权,请留言回复原文章的地址,我们会给您删除此文章,给您带来不便请您谅解!

上一篇:硬盘分区的划分原则
下一篇:Getting Started as an E-Business Suite DBA

发表评论

最新留言

很好
[***.172.111.71]2022年05月22日 09时08分18秒

关于作者

    喝酒易醉,品茶养心,人生如梦,品茶悟道,何以解忧?唯有杜康!
-- 愿君每日到此一游!

最新文章