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;