Ship to location at PO Headers/Shipments not respecting the MOAC associated into the Responsibility
In the field SHIP TO LOCATION it's appearing LOCATIONS without any Inventory Organization associated.
Those Locations were created in the GL as "LEGAL ADDRESS" and it has the flag "SHIP TO SITE FLAG" = 'Y'.
But the field SHIP TO LOCATION in the PURCHASING should respect the Locations with INVENTORY ORGANIZATION associated and assignated in the MOAC (Organization Hierarchy).
select *
from hr_locations
where legal_address_flag = 'Y'
and ship_to_site_flag = 'Y'