View: core.state_sales_tax_scrud_view

 CREATE OR REPLACE VIEW core.state_sales_tax_scrud_view
 AS
 SELECT state_sales_taxes.state_sales_tax_id,
    state_sales_taxes.state_sales_tax_code,
    state_sales_taxes.state_sales_tax_name,
    ((states.state_code::text || ' ('::text) || states.state_name::text) || ')'::text AS state,
    entities.entity_name,
    industries.industry_name,
    ((item_groups.item_group_code::text || ' ('::text) || item_groups.item_group_name::text) || ')'::text AS item_group,
    state_sales_taxes.rate
   FROM core.state_sales_taxes
   JOIN core.states ON state_sales_taxes.state_id = states.state_id
   LEFT JOIN core.entities ON state_sales_taxes.entity_id = entities.entity_id
   LEFT JOIN core.industries ON state_sales_taxes.industry_id = industries.industry_id
   LEFT JOIN core.item_groups ON state_sales_taxes.item_group_id = item_groups.item_group_id;