View: core.account_view

 CREATE OR REPLACE VIEW core.account_view
 AS
 SELECT accounts.account_id,
    ((accounts.account_number::text || ' ('::text) || accounts.account_name::text) || ')'::text AS account,
    accounts.account_number,
    accounts.account_name,
    accounts.description,
    accounts.external_code,
    accounts.currency_code,
    accounts.confidential,
    account_masters.normally_debit,
    accounts.is_transaction_node,
    accounts.sys_type,
    accounts.parent_account_id,
    parent_accounts.account_number AS parent_account_number,
    parent_accounts.account_name AS parent_account_name,
    ((parent_accounts.account_number::text || ' ('::text) || parent_accounts.account_name::text) || ')'::text AS parent_account,
    account_masters.account_master_id,
    account_masters.account_master_code,
    account_masters.account_master_name,
    core.has_child_accounts(accounts.account_id) AS has_child
   FROM core.account_masters
   JOIN core.accounts ON account_masters.account_master_id = accounts.account_master_id
   LEFT JOIN core.accounts parent_accounts ON accounts.parent_account_id = parent_accounts.account_id;