APPS.RCV_CORE_S dependencies on MTL_ITEM_SUB_INVENTORIES

Line 160: FROM mtl_item_sub_inventories mis

156: AND msi.inventory_item_id = x_item_id
157: AND ( msi.restrict_subinventories_code = 2
158: OR ( msi.restrict_subinventories_code = 1
159: AND EXISTS(SELECT 'valid subinventory'
160: FROM mtl_item_sub_inventories mis
161: WHERE mis.organization_id = x_org_id
162: AND mis.inventory_item_id = x_item_id
163: AND mis.secondary_inventory = secondary_inventory_name))))
164: )