ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF543869E053B46B63588994 SELECT avbt.trx_type type, avbt.trx_type break_type, avbt.type_meaning type_dsp, avbt.trx_date trx_date, to_date(NULL) maturity_date, to_number(NULL) bank_account_amount, avbt.trx_number trx_number, NULL payment_method, avbt.currency_code currency_code, to_number(NULL) amount, to_number(NULL) account_amount, 10 transaction_order, avbt.batch_id batch_id, avbt.batch_number batch_number, avbt.remittance_number remittance_number, to_number(null), sp.name ORG_NAME, CE_CEXAVBCH_XMLP_PKG.c_account_amountformula(avbt.trx_type, avbt.batch_id) C_ACCOUNT_AMOUNT, CE_CEXAVBCH_XMLP_PKG.c_amountformula(avbt.trx_type, avbt.batch_id) C_AMOUNT, CE_CEXAVBCH_XMLP_PKG.c_bank_account_amountformula(avbt.trx_type, avbt.batch_id) C_BANK_ACCOUNT_AMOUNT, CE_CEXAVBCH_XMLP_PKG.C_BATCH_AMOUNT_p C_BATCH_AMOUNT, CE_CEXAVBCH_XMLP_PKG.C_BATCH_BANK_ACCOUNT_AMOUNT_p C_BATCH_BANK_ACCOUNT_AMOUNT FROM CE_222_BATCHES_V avbt, ce_security_profiles_gt sp WHERE avbt.bank_account_id =:P_BANK_ACCOUNT AND avbt.trx_type = 'RECEIPT' AND :P_QUERY_RECEIPTS = 'Y' AND avbt.org_id = sp.organization_id and sp.organization_type = 'OPERATING_UNIT' and avbt.org_id = nvl(:P_ORG_ID, avbt.org_id ) and EXISTS ( SELECT null FROM ce_222_transactions_v avtr WHERE avbt.batch_id = avtr.batch_id and avbt.bank_account_id = avtr.bank_account_id ) UNION ALL SELECT avbt.trx_type type, avbt.trx_type break_type, avbt.type_meaning type_dsp, avbt.trx_date trx_date, to_date(NULL) maturity_date, to_number(NULL) bank_account_amount, avbt.trx_number trx_number, NULL payment_method, avbt.currency_code currency_code, to_number(NULL) amount, to_number(NULL) account_amount, 20 transaction_order, avbt.batch_id batch_id, avbt.batch_number batch_number, avbt.remittance_number remittance_number, to_number(null), sp.name ORG_NAME, CE_CEXAVBCH_XMLP_PKG.c_account_amountformula(avbt.trx_type, avbt.batch_id) C_ACCOUNT_AMOUNT, CE_CEXAVBCH_XMLP_PKG.c_amountformula(avbt.trx_type, avbt.batch_id) C_AMOUNT, CE_CEXAVBCH_XMLP_PKG.c_bank_account_amountformula(avbt.trx_type, avbt.batch_id) C_BANK_ACCOUNT_AMOUNT, CE_CEXAVBCH_XMLP_PKG.C_BATCH_AMOUNT_p C_BATCH_AMOUNT, CE_CEXAVBCH_XMLP_PKG.C_BATCH_BANK_ACCOUNT_AMOUNT_p C_BATCH_BANK_ACCOUNT_AMOUNT FROM CE_200_BATCHES_V avbt, ce_security_profiles_gt sp WHERE avbt.bank_account_id =:P_BANK_ACCOUNT AND avbt.trx_type = 'PAYMENT' AND :P_QUERY_PAYMENTS = 'Y' AND avbt.org_id = sp.organization_id and sp.organization_type = 'OPERATING_UNIT' and avbt.org_id = nvl(:P_ORG_ID, avbt.org_id ) and EXISTS( select null from ce_200_transactions_v avtr where avbt.bank_account_id = avtr.bank_account_id and avbt.batch_id = avtr.batch_id AND avbt.batch_number = avtr.batch_name AND NVL(avtr.status, 'NEGOTIABLE') != 'VOIDED') &C_ORDER_BY Y CE CEXAVBCH_XML AR CE المجموعات المتاحة للتسوية (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: إدارة النقدية Source: المجموعات المتاحة للتسوية (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: CEXAVBCH_XML DB package: CE_CEXAVBCH_XMLP_PKG D CE Stapel - Zur Abstimmung verfügbar- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Cash Management Source: Stapel - Zur Abstimmung verfügbar (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: CEXAVBCH_XML DB package: CE_CEXAVBCH_XMLP_PKG F CE Lots prêts pour le rapprochement- Non pris en charge : réservé pour une utilisation future Application: Cash Management Source: Lots prêts pour le rapprochement (XML) - Non pris en charge : réservé pour une utilisation future Short Name: CEXAVBCH_XML DB package: CE_CEXAVBCH_XMLP_PKG US CE Batches Available for Reconciliation - draft Application: Cash Management Source: Batches Available for Reconciliation (XML) - Not Supported: Reserved For Future Use Short Name: CEXAVBCH_XML DB package: CE_CEXAVBCH_XMLP_PKG ZHS CE 可用于调节的批- 不支持：已保留供将来使用 Application: 现金管理系统 Source: 可用于调节的批 (XML) - 不支持：已保留供将来使用 Short Name: CEXAVBCH_XML DB package: CE_CEXAVBCH_XMLP_PKG BI Publisher &c_order_by :c_amount_width :c_bank_account_name :c_bank_account_num :c_bank_account_type :c_bank_branch_name :c_bank_currency_code :c_bank_name :c_batch_amount :c_batch_bank_account_amount :c_batch_pay_sql_lex :c_batch_rec_sql_lex :c_company_name_header :c_precision :c_receipt_translation :c_the_end :c_transaction_type :p_bank_account :p_conc_request_id :p_debug_mode :p_order_by :p_org_id :p_query_payments :p_query_receipts :p_show_void_payment_flag :p_source_view :p_sql_trace :p_type 1 10 :p_type LOV Oracle CE_BATCH_TYPE Y select lookup_code id, meaning value, null description from ce_lookups where lookup_type='BATCH_TYPE' order by value,description SELECT meaning from CE_LOOKUPS where lookup_type = 'BATCH_TYPE' AND lookup_code = 'ALL' Y AR نوع المجموعة D Stapelart F Type de lot US Batch Type ZHS 批类型 2 20 :p_org_id LOV Oracle CE_OPERATING_UNITS_MO Y select org_id id, name value, null description from ce_le_bg_ou_vs_v where organization_type='OPERATING_UNIT' order by value,description AR وحدة تشغيل حساب المدفوعات/المقبوضات D KR/DE Betriebseinheit F Unité opérationnelle AP/AR US AP/AR Operating Unit ZHS AP/AR 业务实体 3 30 :p_bank_account LOV Oracle CE_BANK_ACCOUNT_NUM_NAME Y select bank_account_id id, bank_account_num_name value, null description from ce_internal_bank_accounts_v order by bank_account_num_name Y AR رقم حساب البنك D Kontonummer F Numéro de compte bancaire US Bank Account Number ZHS 银行帐号 4 40 :p_order_by LOV Oracle CE_CEXAVTRX_ORDER_BY Y select lookup_code id, meaning value, null description from ce_lookups where lookup_type='REPORT_ORDER_BY' and lookup_code in ('AMOUNT','DATE') order by value,description SELECT meaning FROM ce_lookups WHERE lookup_type = 'REPORT_ORDER_BY' AND lookup_code = 'DATE' AR ترتيب حسب D Sortieren nach F Tri par US Order By ZHS 排序依据