View: office.cash_repository_scrud_view

 CREATE OR REPLACE VIEW office.cash_repository_scrud_view
 AS
 SELECT cash_repositories.cash_repository_id,
    ((offices.office_code::text || ' ('::text) || offices.office_name::text) || ') '::text AS office,
    cash_repositories.cash_repository_code,
    cash_repositories.cash_repository_name,
    ((parent_cash_repository.cash_repository_code::text || ' ('::text) || parent_cash_repository.cash_repository_name::text) || ') '::text AS parent_cash_repository,
    cash_repositories.description
   FROM office.cash_repositories
   JOIN office.offices ON cash_repositories.office_id = offices.office_id
   LEFT JOIN office.cash_repositories parent_cash_repository ON cash_repositories.parent_cash_repository_id = parent_cash_repository.parent_cash_repository_id;