JL Brazilian Payables Consolidated Invoice Register - draft

➜ Back to Library
Description
Categories: BI Publisher
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
Run JL Brazilian Payables Consolidated Invoice Register - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
Related Blitz Reports
JL Brazilian Payables Cancelled Consolidated Invoice Register - draft XLA Entity ID Mappings JL Colombian Payables Withholding Report- Not Supported: Reserved For Future Use GL Account Analysis (Distributions) 11g GL Account Analysis (Distributions) GL Account Analysis JA India - Creditors Ledger- Not Supported: Reserved For Future Use AP Payment Schedule Report- Not Supported: Reserved For Future Use PA Expense Report Entry
Blitz Report™

Blitz Report™ provides multiple benefits: