How to join Locations with Order to get Internal Locations

Hi,

I am running the below query to get order details including items and Locations. With Ship_to_Location, I have to pick up internal location but I can't understand how to create a join with internal locations rather in which table, we have Internal Location field.   

SELECT party.party_name,
                   hcsu.location Ship_to_Location,
                   hrl.attribute15,
                   wdd.source_header_number,
                   wdd.date_requested,
                   wdd.item_description,
                   wdd.inventory_item_id,
                   wdd.src_requested_quantity_uom,
                   wdd.requested_quantity_uom
                   uom.unit_of_measure
              FROM org_organization_definitions ood,
                   wsh_delivery_details wdd,
                   mtl_system_items_vl msi,
                   hz_parties party,