not able to extract default location attached to Inventory organization

Summary:

Hi

We want to extract Inventory organization Location and using below SQL.

there are few location which are not tagged inventory organization in Manage locations but default location is attached to inventory organization.

These mapping are not coming in below SQL.

Please help.

SELECT DISTINCT
LOCATION_ID AS CODE,
LOCATION_NAME AS NAME,
INVENTORY_ORGANIZATION_ID,
ACTIVE_STATUS
FROM
HR_LOCATIONS_ALL_F_VL hla
where SHIP_TO_SITE_FLAG = 'Y'
order by INVENTORY_ORGANIZATION_ID

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):