OKL Print Consolidated Invoices

Description
Categories: BI Publisher, Financials
Columns: Id, Currency Code, Ixx Id, Consolidated Invoice Number, Date Consolidated, Invoice Total ...
Application: Lease and Finance Management
Source: Print Consolidated Invoices
Short Name: OKL_PRINT_CONS_BILL
DB package:
			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)
Download
 
Blitz Report In Action
Blitz Report™
Business users become frustrated waiting for IT resources to create or modify reports. Often having to combine multiple spreadsheets using convoluted methods. We provide business users with operational reports for core process areas. A Blitz Report™ user can quickly modify their own r