ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F23B3869E053B46B63588994 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) Y OKL OKL_PRINT_CONS_BILL AR OKL طباعة الفواتير المجمعة Application: إدارة الإيجار Source: طباعة الفواتير المجمعة Short Name: OKL_PRINT_CONS_BILL DB package: D OKL Sammelrechnungen drucken Application: Lease and Finance Management Source: Sammelrechnungen drucken Short Name: OKL_PRINT_CONS_BILL DB package: F OKL Imprimer les factures consolidées Application: Lease and Finance Management Source: Imprimer les factures consolidées Short Name: OKL_PRINT_CONS_BILL DB package: US OKL Print Consolidated Invoices Application: Lease and Finance Management Source: Print Consolidated Invoices Short Name: OKL_PRINT_CONS_BILL DB package: ZHS OKL 打印合并发票 Application: Oracle Lease and Finance Management Source: 打印合并发票 Short Name: OKL_PRINT_CONS_BILL DB package: BI Publisher :operating_unit