JL Brazilian Payables Consolidated Invoice Register - draft

SELECT  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.invoice_amount c_cons_invoice_amount,
               cons.invoice_date c_cons_invoice_date,
               cons.description c_cons_description,
               inv.invoice_id c_invoice_id,
               inv.vendor_id c_inv_vendor_id,
               inv.invoice_num c_invoice_num,
               inv.invoice_date c_invoice_date,
               nvl(inv.invoice_amount,0) -  nvl(inv.amount_paid,0) - 
               nvl(inv.discount_amount_taken,0)  c_amount_rem,
               inv.description c_description,
               inv.invoice_type_lookup_code c_invoice_type,       
              substr(inv.invoice_currency_code,1,4) c_currency_code
FROM    jl_br_ap_consolid_invoices cons, 
              ap_invoices inv,
              po_vendors pv
WHERE   cons.vendor_id = pv.vendor_id
AND       cons.consolidated_invoice_id =  inv.global_attribute10
AND       cons.cancelled_date IS NULL
&LP_start_date_predicate
&LP_end_date_predicate
&C_created_by_predicate  
ORDER BY  inv.invoice_currency_code,
                   upper(pv.vendor_name),
                   cons.invoice_num asc