OKL Print Consolidated Invoices
Description
Categories: BI Publisher
Application: Lease and Finance Management
Source: Print Consolidated Invoices
Short Name: OKL_PRINT_CONS_BILL
DB package:
Source: Print Consolidated Invoices
Short Name: OKL_PRINT_CONS_BILL
DB package:
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
SELECT a.id ID, a.currency_code CURRENCY_CODE, a.ixx_id IXX_ID, a.consolidated_invoice_number CONSOLIDATED_INVOICE_NUMBER, a.date_consolidated DATE_CONSOLIDATED, okl_accounting_util.format_amount(a.amount,a.currency_code) INVOICE_TOTAL FROM okl_cnsld_ar_hdrs_v a WHERE EXISTS (SELECT 1 FROM (SELECT x.id FROM okl_cnsld_ar_hdrs_v x, okl_cnsld_ar_lines_v y, okl_cnsld_ar_strms_v z WHERE x.trx_status_code like 'PROCESSED%' AND x.id = y.cnr_id AND y.id = z.lln_id AND z.receivables_invoice_id IS NOT NULL) b WHERE b.id = a.id) ORDER BY to_number(a.consolidated_invoice_number) |