View: core.recurring_invoice_scrud_view

 CREATE OR REPLACE VIEW core.recurring_invoice_scrud_view
 AS
 SELECT recurring_invoices.recurring_invoice_id,
    recurring_invoices.recurring_invoice_code,
    recurring_invoices.recurring_invoice_name,
    ((items.item_code::text || '('::text) || items.item_name::text) || ')'::text AS item,
    ((compound_items.compound_item_code::text || ' ('::text) || compound_items.compound_item_name::text) || ')'::text AS compound_item,
    ((frequencies.frequency_code::text || '('::text) || frequencies.frequency_name::text) || ')'::text AS recurring_frequency,
    recurring_invoices.recurring_amount,
    recurring_invoices.auto_trigger_on_sales
   FROM core.recurring_invoices
   LEFT JOIN core.items ON recurring_invoices.item_id = items.item_id
   JOIN core.frequencies ON recurring_invoices.recurring_frequency_id = frequencies.frequency_id
   LEFT JOIN core.compound_items ON recurring_invoices.compound_item_id = compound_items.compound_item_id;