View: office.counter_scrud_view

 CREATE OR REPLACE VIEW office.counter_scrud_view
 AS
 SELECT counters.counter_id,
    ((stores.store_code::text || '('::text) || stores.store_name::text) || ')'::text AS store,
    ((cash_repositories.cash_repository_code::text || '('::text) || cash_repositories.cash_repository_name::text) || ')'::text AS cash_repository,
    counters.counter_code,
    counters.counter_name
   FROM office.counters
   JOIN office.cash_repositories ON counters.cash_repository_id = cash_repositories.cash_repository_id
   JOIN office.stores ON counters.store_id = stores.store_id;