APPS.PO_PDOI_DISTRIBUTIONS_SV3 dependencies on MTL_ITEM_SUB_INVENTORIES

Line 952: from mtl_item_sub_inventories mis

948: and msi.inventory_item_id = x_item_id
949: and (msi.restrict_subinventories_code = 2
950: or (msi.restrict_subinventories_code = 1
951: and exists (select null
952: from mtl_item_sub_inventories mis
953: where mis.organization_id = nvl(x_ship_to_organization_id , mis.organization_id)
954: and mis.inventory_item_id = msi.inventory_item_id
955: and mis.secondary_inventory = msub.secondary_inventory_name))))))
956: and msub.secondary_inventory_name = x_destination_subinventory;