View: core.shipping_address_scrud_view

 CREATE OR REPLACE VIEW core.shipping_address_scrud_view
 AS
 SELECT shipping_addresses.shipping_address_id,
    shipping_addresses.shipping_address_code,
    ((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;