JL Brazilian Payables Consolidated Invoice Register - draft
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
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 |