View: office.cash_repository_selector_view

Schema	office
Materialized View Name	cash_repository_selector_view
Owner	postgres
Tablespace	DEFAULT
Description

 CREATE OR REPLACE VIEW office.cash_repository_selector_view
 AS
 SELECT cash_repositories.cash_repository_id,
    cash_repositories.cash_repository_code,
    cash_repositories.cash_repository_name,
    parent_cash_repositories.cash_repository_code AS parent_cr_code,
    parent_cash_repositories.cash_repository_name AS parent_cr_name,
    cash_repositories.description
   FROM office.cash_repositories
   LEFT JOIN office.cash_repositories parent_cash_repositories ON cash_repositories.parent_cash_repository_id = parent_cash_repositories.cash_repository_id;