ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F23A3869E053B46B63588994 SELECT NVL(count(*),0) AR_INVS_CNT, SUM(NVL(line.EXTENDED_AMOUNT,0)) NUM_AR_INVS_AMT, hdr.invoice_currency_code AR_INVS_CURR_CODE, hdr.INTERFACE_HEADER_ATTRIBUTE6 AR_INVS_CONTRACT_NUM, (CASE WHEN :INV_CURR_PRECISION = 0 THEN TO_CHAR(SUM(NVL(line.EXTENDED_AMOUNT,0)),'99,999,999,999') WHEN :INV_CURR_PRECISION > 2 THEN TO_CHAR(SUM(NVL(line.EXTENDED_AMOUNT,0)),'999,999,999,990.999') ELSE TO_CHAR(SUM(NVL(line.EXTENDED_AMOUNT,0)),'99,999,999,990.99') END) AR_INVS_AMT FROM ra_customer_trx_all hdr, ra_customer_trx_lines_all line, ra_batch_sources_all batch, RA_CUST_TRX_TYPES_ALL trx_type WHERE line.customer_trx_id = hdr.customer_trx_id AND hdr.batch_source_id = batch.batch_source_id AND batch.name = 'OKL_CONTRACTS' AND line.line_type = 'LINE' AND hdr.CUST_TRX_TYPE_ID = trx_type.CUST_TRX_TYPE_ID AND hdr.INTERFACE_HEADER_ATTRIBUTE6 = NVL(rtrim(ltrim( :KHR_CONTRACT_NUMBER)),hdr.INTERFACE_HEADER_ATTRIBUTE6) AND hdr.trx_date > = NVL( :P_FROM_BILL_DATE , hdr.trx_date ) AND hdr.trx_date < = NVL( :P_TO_BILL_DATE , hdr.trx_date) AND hdr.invoice_currency_code = :INV_CURRENCY_CODE AND batch.org_id = :ORG_ID AND trx_type.org_id = :ORG_ID GROUP BY hdr.invoice_currency_code, hdr.INTERFACE_HEADER_ATTRIBUTE6 UNION SELECT nvl(max(AR_INVS_CNT),0) AR_INVS_CNT, nvl(max(NUM_AR_INVS_AMT),0) NUM_AR_INVS_AMT, nvl(max(AR_INVS_CURR_CODE),'') AR_INVS_CURR_CODE, nvl(max(AR_INVS_CONTRACT_NUM),'') AR_INVS_CONTRACT_NUM, nvl(max(AR_INVS_AMT),'') AR_INVS_AMT from (SELECT NVL(count(*),0) AR_INVS_CNT, SUM(NVL(line.EXTENDED_AMOUNT,0)) NUM_AR_INVS_AMT, hdr.invoice_currency_code AR_INVS_CURR_CODE, hdr.INTERFACE_HEADER_ATTRIBUTE6 AR_INVS_CONTRACT_NUM, (CASE WHEN :INV_CURR_PRECISION = 0 THEN TO_CHAR(SUM(NVL(line.EXTENDED_AMOUNT,0)),'99,999,999,999') WHEN :INV_CURR_PRECISION > 2 THEN TO_CHAR(SUM(NVL(line.EXTENDED_AMOUNT,0)),'999,999,999,990.999') ELSE TO_CHAR(SUM(NVL(line.EXTENDED_AMOUNT,0)),'99,999,999,990.99') END) AR_INVS_AMT FROM ra_customer_trx_all hdr, ra_customer_trx_lines_all line, ra_batch_sources_all batch, RA_CUST_TRX_TYPES_ALL trx_type WHERE line.customer_trx_id = hdr.customer_trx_id AND hdr.batch_source_id = batch.batch_source_id AND batch.name = 'OKL_CONTRACTS' AND line.line_type = 'LINE' AND hdr.CUST_TRX_TYPE_ID = trx_type.CUST_TRX_TYPE_ID AND hdr.INTERFACE_HEADER_ATTRIBUTE6 = NVL(rtrim(ltrim( :KHR_CONTRACT_NUMBER)),hdr.INTERFACE_HEADER_ATTRIBUTE6) AND hdr.trx_date > = NVL( :P_FROM_BILL_DATE , hdr.trx_date ) AND hdr.trx_date < = NVL( :P_TO_BILL_DATE , hdr.trx_date) AND hdr.invoice_currency_code = :INV_CURRENCY_CODE AND batch.org_id = :ORG_ID AND trx_type.org_id = :ORG_ID GROUP BY hdr.invoice_currency_code, hdr.INTERFACE_HEADER_ATTRIBUTE6) ORDER BY 3 Y OKL OKL_BILLING_RECON_RPT Y AR OKL تقرير تسوية تحرير الفواتير Application: إدارة الإيجار Source: تقرير تسوية تحرير الفواتير Short Name: OKL_BILLING_RECON_RPT DB package: D OKL Fakturierung - Abstimmung Application: Lease and Finance Management Source: Fakturierung - Abstimmung Short Name: OKL_BILLING_RECON_RPT DB package: F OKL Etat Rapprochement de la facturation Application: Lease and Finance Management Source: Etat Rapprochement de la facturation Short Name: OKL_BILLING_RECON_RPT DB package: US OKL Billing Reconciliation Application: Lease and Finance Management Source: Billing Reconciliation Report Short Name: OKL_BILLING_RECON_RPT DB package: ZHS OKL 开单调节报表 Application: Oracle Lease and Finance Management Source: 开单调节报表 Short Name: OKL_BILLING_RECON_RPT DB package: BI Publisher :inv_curr_precision :inv_currency_code :khr_contract_number :operating_unit :org_id :p_from_bill_date :p_to_bill_date 1 10 :p_from_bill_date Date AR من تاريخ D Von Datum F Date - Du US From Date ZHS 自日期 2 20 :p_to_bill_date Date AR إلى تاريخ D Bis Datum F Date - Au US To Date ZHS 至日期 3 30 :p_contract_number LOV Oracle Lease Contracts Y select contract_number id, contract_number value, null description from okl_k_headers_full_v where scs_code in ('LEASE','LOAN') order by contract_number desc AR رقم العقد D Vertragsnummer F Numéro de contrat US Contract Number ZHS 合同编号