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:

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)