View: core.party_user_control_view

 CREATE OR REPLACE VIEW core.party_user_control_view
 AS
 SELECT party_types.party_type_code,
    party_types.party_type_name,
    parties.email,
    parties.url,
    parties.pan_number,
    parties.sst_number,
    parties.cst_number,
    parties.allow_credit,
    parties.maximum_credit_period,
    parties.maximum_credit_amount,
    accounts.account_number,
    accounts.account_name,
    parties.zip_code,
    parties.address_line_1,
    parties.address_line_2,
    parties.street,
    core.get_state_name_by_state_id(parties.state_id) AS state,
    core.get_country_name_by_country_id(parties.country_id) AS country
   FROM core.parties
   JOIN core.party_types ON parties.party_type_id = party_types.party_type_id
   JOIN core.accounts ON parties.account_id = accounts.account_id;