JL Brazilian Payables Cancelled Consolidated Invoice Register - draft

SELECT  distinct pv.vendor_name c_vendor_name,
               upper(pv.vendor_name) c_upper_vendor_name,
               cons.consolidated_invoice_id c_consolidated_invoice_id,
               cons.vendor_id c_cons_vendor_id,
               cons.invoice_num c_cons_invoice_num,
               cons.cancelled_date c_cons_cancelled_date,
               cons.cancelled_by c_cons_cancelled_by,
               cons.cancelled_amount c_cons_cancelled_amount,
               cons.invoice_date c_cons_invoice_date,
               cons.description c_cons_description,
               cons.invoice_currency_code c_currency_code
FROM    jl_br_ap_consolid_invoices cons, 
              po_vendors pv,
              gl_code_combinations gcc
WHERE  cons.vendor_id = pv.vendor_id
AND       gcc.chart_of_accounts_id = &C_CHART_OF_ACCOUNTS_ID
AND       cons.cancelled_date IS NOT NULL  
&LP_start_date_predicate
&LP_end_date_predicate
&C_created_by_predicate
ORDER BY  cons.invoice_currency_code,
                   upper(pv.vendor_name),
                   cons.invoice_num asc