How to ship from two locations which attatched to same Org.

Oracle said, it is not possible to ship from two different locations which active for same Org.

The base is - Release rule only pickup ship from location which default to Organization.

Our business scenario required both the locations to be active and available for transactions.

We have different sales order type for both the ship from locations.

Below query shows only one location which is defaulted from Organization.

Select w.wsh_location_id location_id, ui_location_code, address2,address3, address4, postal_code,country, 'Site' location_type, v.organization_code, v.organization_id inventory_organization_id From wsh_ship_from_orgs_v v, wsh_locations w Where trunc(sysdate) < trunc(nvl(v.disable_date, sysdate+1)) and v.organization_id IS NOT NULL AND v.location_id = w.source_location_id AND w.location_source_code='HR'