CREATE OR REPLACE VIEW core.shipping_address_view
AS
SELECT shipping_addresses.shipping_address_id,
shipping_addresses.shipping_address_code,
shipping_addresses.party_id,
((parties.party_code::text || ' ('::text) || parties.party_name) || ')'::text AS party,
shipping_addresses.zip_code,
shipping_addresses.address_line_1,
shipping_addresses.address_line_2,
shipping_addresses.street,
shipping_addresses.city,
core.get_state_name_by_state_id(shipping_addresses.state_id) AS state,
core.get_country_name_by_country_id(shipping_addresses.country_id) AS country
FROM core.shipping_addresses
JOIN core.parties ON shipping_addresses.party_id = parties.party_id;