Print the Inventory org Address

select * from hr_locations_v hlv, hr_all_organization_units hou
WHERE hlv.inventory_organization_id = hou.organization_id
AND hlv.location_id = hou.location_id
AND hou.organization_id = :p_mfg_org;

************************************************

select hla.description,
hla.address_line_1||hla.address_line_2 address1,
hla.town_or_city||hla.region_2||' '||hla.postal_code address2,
ft.ISO_territory_code address3,
'(Tel) + '||hla.telephone_number_1 Tel,
' (Fax) + '|| hla.telephone_number_2 Fax
from hr_locations_all hla, fnd_territories ft
where hla.inventory_organization_id=:P_MFG_ORG
and ft.territory_code=hla.country
and hla.inactive_date is null;