View: core.sales_tax_scrud_view

 CREATE OR REPLACE VIEW core.sales_tax_scrud_view
 AS
 SELECT sales_taxes.sales_tax_id,
    ((tax_master.tax_master_code::text || ' ('::text) || tax_master.tax_master_name::text) || ')'::text AS tax_master,
    ((offices.office_code::text || ' ('::text) || offices.office_name::text) || ')'::text AS office,
    sales_taxes.sales_tax_code,
    sales_taxes.sales_tax_name,
    sales_taxes.is_exemption,
    ((tax_base_amount_types.tax_base_amount_type_code::text || '('::text) || tax_base_amount_types.tax_base_amount_type_name::text) || ')'::text AS tax_base_amount,
    sales_taxes.rate
   FROM core.sales_taxes
   JOIN core.tax_master ON sales_taxes.tax_master_id = tax_master.tax_master_id
   JOIN office.offices ON sales_taxes.office_id = offices.office_id
   JOIN core.tax_base_amount_types ON sales_taxes.tax_base_amount_type_code::text = tax_base_amount_types.tax_base_amount_type_code::text;