View: core.account_selector_view

 CREATE OR REPLACE VIEW core.account_selector_view
 AS
 SELECT accounts.account_id,
    accounts.account_number,
    accounts.account_name,
    accounts.description,
    accounts.sys_type,
    accounts.parent_account_id,
    parent_accounts.account_number AS parent_account_number,
    parent_accounts.account_name AS parent_account_name,
    account_masters.account_master_id,
    account_masters.account_master_code,
    account_masters.account_master_name
   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;