JL Brazilian Payables Consolidated Invoice Register - draft

Description
Categories: BI Publisher
Columns: C Vendor Name, C Upper Vendor Name, C Consolidated Invoice Id, C Cons Vendor Id, C Cons Invoice Num, C Cons Invoice Amount, C Cons Invoice Date, C Cons Description, C Invoice Id, C Inv Vendor Id ...
Application: Latin America Localizations
Source: Brazilian Payables Consolidated Invoice Register (XML) - Not Supported: Reserved For Future Use
Short Name: JLBRPCIR_XML
DB package: JL_JLBRPCIR_XMLP_PKG
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
Parameter Name SQL text Validation
Entered By (Skip for All)
 
LOV Oracle
First Entered Date
 
Date
Last Entered Date
 
Date
Accounting Period
 
LOV Oracle