View: core.sales_tax_exempt_detail_scrud_view

 CREATE OR REPLACE VIEW core.sales_tax_exempt_detail_scrud_view
 AS
 SELECT sales_tax_exempt_details.sales_tax_exempt_detail_id,
    ((sales_tax_exempts.sales_tax_exempt_code::text || '('::text) || sales_tax_exempts.sales_tax_exempt_name::text) || ')'::text AS sales_tax_exempt,
    entities.entity_name,
    industries.industry_name,
    ((parties.party_code::text || '('::text) || parties.party_name) || ')'::text AS party,
    ((party_types.party_type_code::text || '('::text) || party_types.party_type_name::text) || ')'::text AS party_type,
    ((items.item_code::text || '('::text) || items.item_name::text) || ')'::text AS item,
    ((item_groups.item_group_code::text || '('::text) || item_groups.item_group_name::text) || ')'::text AS item_group
   FROM core.sales_tax_exempt_details
   LEFT JOIN core.sales_tax_exempts ON sales_tax_exempt_details.sales_tax_exempt_id = sales_tax_exempts.sales_tax_exempt_id
   LEFT JOIN core.entities ON sales_tax_exempt_details.entity_id = entities.entity_id
   LEFT JOIN core.industries ON sales_tax_exempt_details.industry_id = industries.industry_id
   LEFT JOIN core.parties ON sales_tax_exempt_details.party_id = parties.party_id
   LEFT JOIN core.party_types ON sales_tax_exempt_details.party_type_id = party_types.party_type_id
   LEFT JOIN core.items ON sales_tax_exempt_details.item_id = items.item_id
   LEFT JOIN core.item_groups ON sales_tax_exempt_details.item_group_id = item_groups.item_group_id;