Thank you for your reply,In the above
suggested by Hussein Sawwan,
its mentioned that, if MTL_ITEM_LOCATIONS table's column INVENTORY_ITEM_IDis 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.