Warehouse Code in the Query

Dear Friends,

Iam trying to pick up and incorporate  the Warehouse code into my sql query below.Can you please help me from where to pick this code up as iam struggling to find this field.

SELECT
wnd.delivery_id,
wnd.name delivery_name,
wnd.source_header_id order_header_id,
wdd.cust_po_number,
wdd.container_name,
wdd.ship_to_location_id,
nvl(wdd.deliver_to_location_id,wdd.ship_to_location_id) deliver_to_location_id,
wdd.ship_to_site_use_id c_ship_to_site_use_id,
HZPCON.party_name customer_name,
HZPCON.person_title|| ' ' || substrb(HZPCON.person_first_name,1,40) || ' ' || substrb(HZPCON.person_last_name,1,50) contact_name,