APPS.PO_PDOI_DISTRIBUTIONS_SV3 dependencies on MTL_ITEM_SUB_INVENTORIES

Line 956: from mtl_item_sub_inventories mis

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