This content has been marked as final. Show 3 replies
Gurujothi wrote:TABLE: INV.MTL_ITEM_LOCATIONS
Can anyone explain what is the difference between the following tables and usage,
mtl_item_locations vs mtl_secondary_locators
Thank you for your reply,In the above
suggested by Hussein Sawwan,
its mentioned that, if MTL_ITEM_LOCATIONS table's column INVENTORY_ITEM_ID is not null, the only item that can be in locator
and you mentioned that,
mtl_secondary_locators = stores items that are restricted to a particular locator.
here in my case as mentioned above for my inventory_item_id 14567 and org_id 333 some locators are restricted because some records
are there in mtl_secondary_locators for inventory_item_id 14567 and org_id 333 ,
and in MTL_ITEM_LOCATIONS table totally 4 records( locators) are there for org_id 333 and all 4 records
INVENTORY_ITEM_ID is not null,this means that only the mentioned INVENTORY_ITEM_ID can be stored in that locators and there is no locator mentioned for inventory_item_id 14567 and org_id 333.
can you tell me where can I check the assigned locator for inventory_item_id 14567 and org_id 333.