View: core.cash_flow_setup_scrud_view

Schema core
Materialized View Name cash_flow_setup_scrud_view
Owner postgres
Tablespace DEFAULT
Description
 CREATE OR REPLACE VIEW core.cash_flow_setup_scrud_view
 AS
 SELECT cash_flow_setup.cash_flow_setup_id,
    ((cash_flow_headings.cash_flow_heading_code::text || '('::text) || cash_flow_headings.cash_flow_heading_name::text) || ')'::text AS cash_flow_heading,
    ((account_masters.account_master_code::text || '('::text) || account_masters.account_master_name::text) || ')'::text AS account_master
   FROM core.cash_flow_setup
   JOIN core.cash_flow_headings ON cash_flow_setup.cash_flow_heading_id = cash_flow_headings.cash_flow_heading_id
   JOIN core.account_masters ON cash_flow_setup.account_master_id = account_masters.account_master_id;