ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EEC33869E053B46B63588994 select substr(nvl(cba.bank_account_name, 'None'),1,30) Bank_Account_A , substr(PARTY.PARTY_NAME,1,10) Name, substr(cust.ACCOUNT_NUMBER,1,10) Number_A, substr(su.location,1,8) Location, substr(branch.bank_name,1,60) Bank_Name, substr(cba.bank_account_num,1,15) Bank_Account, substr(cr.receipt_number,1,7) Receipt_Number, substr(l1.meaning,1,8) Type , ps.due_date Maturity_Date, substr(l2.meaning,1,8) Reason, substr(cr.currency_code,1,15) Currency_A, l1.lookup_code Reversal_Category, crh1.gl_date Original_GL_Date, crh2.gl_date Reversal_GL_Date, substr(l3.meaning,1,4) R_Type, crh1.amount + nvl(crh1.factor_discount_amount,0) Amount, crh1.acctd_amount + nvl(crh1.acctd_factor_discount_amount,0) Functional_Amount, AR_ARXREV_XMLP_PKG.c_summary_label_bankformula(substr ( branch.bank_name , 1 , 60 )) C_SUMMARY_LABEL_BANK, AR_ARXREV_XMLP_PKG.c_calc_amountformula(substr ( l3.meaning , 1 , 4 ), crh1.amount + nvl ( crh1.factor_discount_amount , 0 ), crh1.acctd_amount + nvl ( crh1.acctd_factor_discount_amount , 0 ), l1.lookup_code) C_CALC_AMOUNT, AR_ARXREV_XMLP_PKG.c_cash_amt_func_p c_cash_amt_func, AR_ARXREV_XMLP_PKG.c_cash_amt_p c_cash_amt, AR_ARXREV_XMLP_PKG.c_misc_amt_func_p c_misc_amt_func, AR_ARXREV_XMLP_PKG.c_misc_amt_p c_misc_amt, AR_ARXREV_XMLP_PKG.c_nsf_amt_func_p c_nsf_amt_func, AR_ARXREV_XMLP_PKG.c_nsf_amt_p c_nsf_amt, AR_ARXREV_XMLP_PKG.c_rev_amt_func_p c_rev_amt_func, AR_ARXREV_XMLP_PKG.c_rev_amt_p c_rev_amt, AR_ARXREV_XMLP_PKG.c_stop_amt_func_p c_stop_amt_func, AR_ARXREV_XMLP_PKG.c_stop_amt_p c_stop_amt from HZ_CUST_ACCOUNTS cust, HZ_PARTIES PARTY, ar_cash_receipts cr, ar_payment_schedules ps, ar_lookups l1, ar_lookups l2, ar_lookups l3, ar_cash_receipt_history crh1, ar_cash_receipt_history crh2, ce_bank_accounts cba, ce_bank_branches_v branch, ce_bank_acct_uses bank, HZ_CUST_site_uses su where cr.pay_from_customer = cust.CUST_ACCOUNT_ID(+) AND CUST.PARTY_ID = PARTY.PARTY_ID(+) and cr.status = cr.reversal_category &lp_reason and cr.reversal_category = l1.lookup_code and l1.lookup_type = 'REVERSAL_CATEGORY_TYPE' and cr.reversal_reason_code = l2.lookup_code and l2.lookup_type = 'CKAJST_REASON' and cr.type = l3.lookup_code and l3.lookup_type = 'PAYMENT_CATEGORY_TYPE' and cr.cash_receipt_id = crh1.cash_receipt_id and ps.cash_receipt_id(+) = cr.cash_receipt_id and crh1.first_posted_record_flag = 'Y' and cr.cash_receipt_id = crh2.cash_receipt_id and crh2.status = 'REVERSED' &lp_rev_gl_start_date &lp_rev_gl_end_date and cr.remit_bank_acct_use_id = bank.bank_acct_use_id (+) and bank.bank_account_id = cba.bank_account_id (+) and cba.bank_branch_id = branch.branch_party_id &lp_bank_account_low &lp_bank_account_high &lp_customer_low &lp_customer_high &lp_curr_low &lp_curr_high and cr.customer_site_use_id = su.site_use_id (+) and :l_order_rpt_by = 'BANK' order by PARTY.PARTY_NAME, BANK_NAME,BANK_ACCOUNT,CURRENCY_A,NAME,NUMBER_A,LOCATION,RECEIPT_NUMBER,MATURITY_DATE Y AR ARXREV_XML AR AR تقرير الإيصالات المعكوسة (بتنسيق XML) Application: المقبوضات Source: تقرير الإيصالات المعكوسة (بتنسيق XML) Short Name: ARXREV_XML DB package: AR_ARXREV_XMLP_PKG D AR Zahlungseingänge - storniert Application: Debitoren Source: Zahlungseingänge - storniert (XML) Short Name: ARXREV_XML DB package: AR_ARXREV_XMLP_PKG F AR Etat Règlements annulés Application: Receivables Source: Etat Règlements annulés (XML) Short Name: ARXREV_XML DB package: AR_ARXREV_XMLP_PKG US AR Reversed Receipts Application: Receivables Source: Reversed Receipts Report (XML) Short Name: ARXREV_XML DB package: AR_ARXREV_XMLP_PKG ZHS AR 已冲销收款报表 Application: 应收帐款 Source: 已冲销收款报表 (XML) Short Name: ARXREV_XML DB package: AR_ARXREV_XMLP_PKG BI Publisher &lp_bank_account_high &lp_bank_account_low &lp_curr_high &lp_curr_low &lp_customer_high &lp_customer_low &lp_reason &lp_rev_gl_end_date &lp_rev_gl_start_date :c_cash_amt :c_cash_amt_func :c_cash_dm_amt :c_cash_dm_amt_func :c_misc_amt :c_misc_amt_func :c_misc_dm_amt :c_misc_dm_amt_func :c_nsf_amt :c_nsf_amt_func :c_nsf_dm_amt :c_nsf_dm_amt_func :c_rev_amt :c_rev_amt_func :c_rev_dm_amt :c_rev_dm_amt_func :c_stop_amt :c_stop_amt_func :c_stop_dm_amt :c_stop_dm_amt_func :currency1 :currency2 :l_order_rpt_by :lp_bank_account_high :lp_bank_account_low :lp_curr_high :lp_curr_low :lp_customer_high :lp_customer_low :lp_reason :lp_rev_gl_end_date :lp_rev_gl_end_date_dm :lp_rev_gl_start_date :lp_rev_gl_start_date_dm :operating_unit :p_bank_account_high :p_bank_account_low :p_conc_request_id :p_curr_high :p_curr_low :p_cust_high :p_cust_low :p_order_by :p_reason :p_rev_gl_end_date :p_rev_gl_end_date1 :p_rev_gl_start_date :p_rev_gl_start_date1 :rp_company_name :rp_cust_data_found :rp_cust_data_found_dm :rp_data_found :rp_data_found_dm :rp_date_range :rp_none :rp_report_name :rp_sub_title :rp_sum_for :rpd_cash_amt_func :rpd_cash_dm_amt_func :rpd_cust_func :rpd_dm_cust_func :rpd_func_amt :rpd_func_dm_amt :rpd_misc_amt_func :rpd_misc_dm_amt_func :rpd_nsf_amt_func :rpd_nsf_dm_amt_func :rpd_rev_amt_func :rpd_rev_dm_amt_func :rpd_stop_amt_func :rpd_stop_dm_amt_func 1 10 :l_order_rpt_by LOV Oracle AR_ARXREV_SORT_BY Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='SORT_BY_ARXREV' and nvl(enabled_flag,'Y')='Y' order by value,description Y AR ترتيب حسب D Sortieren nach F Tri par US Order By ZHS 排序依据 2 20 :p_curr_low LOV Oracle AR_SRS_CURRENCY Y select currency_code id, currency_code value, name description from fnd_currencies_vl where currency_flag='Y' and enabled_flag in ('Y','N') order by currency_code AR عملة من D Von Währung F Devise - De US Currency Low ZHS 币种下限 3 30 :p_curr_high LOV Oracle AR_SRS_CURRENCY Y select currency_code id, currency_code value, name description from fnd_currencies_vl where currency_flag='Y' and enabled_flag in ('Y','N') order by currency_code AR عملة إلى D Bis Währung F Devise - A US Currency High ZHS 币种上限 4 40 :p_bank_account_low LOV Oracle AR_BANK_ACCOUNT_NAME Y select cba.bank_account_name id, cba.bank_account_name value, null description from ce_bank_accounts cba,ce_bank_branches_v bb where cba.bank_branch_id=bb.branch_party_id and cba.account_classification='INTERNAL' and exists (select 'x' from ce_bank_acct_uses bau where bau.bank_account_id=cba.bank_account_id and nvl(bau.ar_use_enable_flag,'N')='Y' and nvl(end_date,to_date('12/31/4712','MM/DD/YYYY'))>=trunc(sysdate) ) order by 1 AR حساب البنك من D Von Bankkonto F Compte bancaire - De US Bank Account Low ZHS 银行帐户下限 5 50 :p_bank_account_high LOV Oracle AR_BANK_ACCOUNT_NAME Y select cba.bank_account_name id, cba.bank_account_name value, null description from ce_bank_accounts cba,ce_bank_branches_v bb where cba.bank_branch_id=bb.branch_party_id and cba.account_classification='INTERNAL' and exists (select 'x' from ce_bank_acct_uses bau where bau.bank_account_id=cba.bank_account_id and nvl(bau.ar_use_enable_flag,'N')='Y' and nvl(end_date,to_date('12/31/4712','MM/DD/YYYY'))>=trunc(sysdate) ) order by 1 AR حساب البنك إلى D Bis Bankkonto F Compte bancaire - A US Bank Account High ZHS 银行帐户上限 6 60 :p_rev_gl_start_date Date AR تاريخ الأستاذ العام العكسي من D Von Korrektur-Buchungsdatum F Date GL contrepassation - Du US Reversal GL Date Low ZHS 冲销 GL 日期下限 7 70 :p_rev_gl_end_date Date AR تاريخ الأستاذ العام العكسي إلى D Bis Korrektur-Buchungsdatum F Date GL contrepassation - Au US Reversal GL Date High ZHS 冲销 GL 日期上限 8 80 :p_cust_low LOV Oracle AR_CUSTOMER_NUMBER Y Y select cust.account_number id, cust.account_number value, null description from hz_cust_accounts cust,hz_parties party where cust.party_id=party.party_id order by cust.account_number AR رقم العميل من D Von Kundennummer F Numéro de client - De US Customer Number Low ZHS 客户编号下限 9 90 :p_cust_high LOV Oracle AR_CUSTOMER_NUMBER Y Y select cust.account_number id, cust.account_number value, null description from hz_cust_accounts cust,hz_parties party where cust.party_id=party.party_id order by cust.account_number AR رقم العميل إلى D Bis Kundennummer F Numéro de client - A US Customer Number High ZHS 客户编号上限 10 100 :p_reason LOV Oracle AR_ARXREV_REASONS Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='CKAJST_REASON' order by meaning AR سبب الإيصال المعكوس D Grund stornierte Zahlungen F Motif annulation règlement US Reversed Receipt Reason ZHS 已冲销收款原因