View: core.sales_tax_exempt_scrud_view

 CREATE OR REPLACE VIEW core.sales_tax_exempt_scrud_view
 AS
 SELECT sales_tax_exempts.sales_tax_exempt_id,
    ((tax_master.tax_master_code::text || '('::text) || tax_master.tax_master_name::text) || ')'::text AS tax_master,
    sales_tax_exempts.sales_tax_exempt_code,
    sales_tax_exempts.sales_tax_exempt_name,
    ((tax_exempt_types.tax_exempt_type_code::text || '('::text) || tax_exempt_types.tax_exempt_type_name::text) || ')'::text AS tax_exempt_type,
    ((stores.store_code::text || '('::text) || stores.store_name::text) || ')'::text AS store,
    ((sales_taxes.sales_tax_code::text || '('::text) || sales_taxes.sales_tax_name::text) || ')'::text AS sales_tax,
    sales_tax_exempts.valid_from,
    sales_tax_exempts.valid_till,
    sales_tax_exempts.price_from,
    sales_tax_exempts.price_to
   FROM core.sales_tax_exempts
   JOIN core.tax_master ON sales_tax_exempts.tax_master_id = tax_master.tax_master_id
   JOIN core.tax_exempt_types ON sales_tax_exempts.tax_exempt_type_id = tax_exempt_types.tax_exempt_type_id
   JOIN office.stores ON sales_tax_exempts.store_id = stores.store_id
   JOIN core.sales_taxes ON sales_tax_exempts.sales_tax_id = sales_taxes.sales_tax_id;