ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EE8C3869E053B46B63588994 select receipts.receipt_number Receipt_Number, receipts.currency_code Cur, (select p.party_name from hz_cust_accounts ac, hz_parties p where receipts.pay_from_customer = ac.cust_account_id and ac.party_id = p.party_id) Customer_Name, receipts.amount Receipt_Amount, (select decode(decode(receipts.pay_from_customer,null,ps.amount_due_remaining,null), null,ps.amount_due_remaining,null)*-1 from ar_payment_schedules ps where ps.cash_receipt_id = receipts.cash_receipt_id) Unapplied_Balance, (select decode(receipts.pay_from_customer,null,ps.amount_due_remaining,null)*-1 from ar_payment_schedules ps where ps.cash_receipt_id = receipts.cash_receipt_id) Unidentified_Balance, (select ruleset.automatch_set_name from ar_cash_auto_rule_sets_tl ruleset where ruleset.automatch_set_id = refs.automatch_set_id and ruleset.language = userenv('lang')) Rule_Set, (case refs.receipt_reference_status when 'AR_AA_RULE_SET_INACTIVE' then ar_aratappm_pkg.getmessage('AR_AA_RULE_SET_INACTIVE') else null end) Exe_Message, (case refs.receipt_reference_status when 'AR_AA_RULE_SET_INACTIVE' then null else refs.line_number END) line_number, (case refs.receipt_reference_status when 'AR_AA_RULE_SET_INACTIVE' then null else interim.invoice_reference END) Reference_number, (case refs.receipt_reference_status when 'AR_AA_RULE_SET_INACTIVE' then null else refs.invoice_currency_code END) Cur1, (case refs.receipt_reference_status when 'AR_AA_RULE_SET_INACTIVE' then null else refs.amount_applied END) Amount, (case refs.receipt_reference_status when 'AR_AA_RULE_SET_INACTIVE' then null else refs.resolved_matching_number END) Applied_Transaction, (case refs.receipt_reference_status when 'AR_AA_RULE_SET_INACTIVE' then null else refs.match_score_value END) Match_Score, (case refs.receipt_reference_status when 'AR_AA_RULE_SET_INACTIVE' then null else (select decode(mat.automatch_name, null, 'Knapsack', mat.automatch_name) from ar_cash_automatches_tl mat where refs.match_resolved_using = mat.automatch_id (+) and mat.language (+) = userenv('lang')) end) Automatic_Matching_Rule, (case refs.receipt_reference_status when 'AR_AA_RULE_SET_INACTIVE' then null else ar_aratappm_pkg.getmessage(refs.receipt_reference_status) end) Application_Execution_Message from ar_cash_receipts receipts, ar_cash_remit_refs_interim interim, ar_cash_remit_refs refs where receipts.cash_receipt_id = interim.cash_receipt_id and refs.cash_receipt_id = interim.cash_receipt_id and refs.remit_reference_id = interim.remit_reference_id UNION ALL select receipts.receipt_number Receipt_Number, receipts.currency_code Cur, (select p.party_name from hz_cust_accounts ac, hz_parties p where receipts.pay_from_customer = ac.cust_account_id and ac.party_id = p.party_id) Customer_Name, receipts.amount Receipt_Amount, (select decode(decode(receipts.pay_from_customer,null,ps.amount_due_remaining,null), null,ps.amount_due_remaining,null)*-1 from ar_payment_schedules ps where ps.cash_receipt_id = receipts.cash_receipt_id) Unapplied_Balance, (select decode(receipts.pay_from_customer,null,ps.amount_due_remaining,null)*-1 from ar_payment_schedules ps where ps.cash_receipt_id = receipts.cash_receipt_id) Unidentified_Balance, (select ruleset.automatch_set_name from ar_cash_auto_rule_sets_tl ruleset where ruleset.automatch_set_id = interim.automatch_set_id and ruleset.language = userenv('lang')) Rule_Set, (case interim.receipt_reference_status when 'AR_AA_RULE_SET_INACTIVE' then ar_aratappm_pkg.getmessage('AR_AA_RULE_SET_INACTIVE') else null end) Exe_Message, (case interim.receipt_reference_status when 'AR_AA_RULE_SET_INACTIVE' then null else 1 END) line_number, (case interim.receipt_reference_status when 'AR_AA_RULE_SET_INACTIVE' then null else interim.invoice_reference END) Reference_number, (case interim.receipt_reference_status when 'AR_AA_RULE_SET_INACTIVE' then null else interim.invoice_currency_code END) Cur1, (case interim.receipt_reference_status when 'AR_AA_RULE_SET_INACTIVE' then null else interim.amount_applied END) Amount, (case interim.receipt_reference_status when 'AR_AA_RULE_SET_INACTIVE' then null else NULL END) Applied_Transaction, (case interim.receipt_reference_status when 'AR_AA_RULE_SET_INACTIVE' then null else 100 END) Match_Score, (case interim.receipt_reference_status when 'AR_AA_RULE_SET_INACTIVE' then null else 'Knapsack' end) Automatic_Matching_Rule, (case interim.receipt_reference_status when 'AR_AA_RULE_SET_INACTIVE' then null else ar_aratappm_pkg.getmessage(interim.receipt_reference_status) end) Application_Execution_Message from ar_cash_receipts receipts, ar_cash_remit_refs_interim interim where receipts.cash_receipt_id = interim.cash_receipt_id and interim.remit_reference_id <0 order by receipt_number, line_number asc Y AR ARATAPPM AR AR البرنامج الرئيسي لتطبيق النقدية الآلية Application: المقبوضات Source: البرنامج الرئيسي لتطبيق النقدية الآلية Short Name: ARATAPPM DB package: AR_ARATAPPM_PKG D AR Zahlungsregelzuordnung - Hauptprogramm Application: Debitoren Source: Zahlungsregelzuordnung - Hauptprogramm Short Name: ARATAPPM DB package: AR_ARATAPPM_PKG F AR Lettrage automatique d'encaissements - Programme principal Application: Receivables Source: Lettrage automatique d'encaissements - Programme principal Short Name: ARATAPPM DB package: AR_ARATAPPM_PKG US AR Automatic Cash Application Master Program Application: Receivables Source: Automatic Cash Application Master Program Short Name: ARATAPPM DB package: AR_ARATAPPM_PKG ZHS AR 自动现金核销主程序 Application: 应收帐款 Source: 自动现金核销主程序 Short Name: ARATAPPM DB package: AR_ARATAPPM_PKG BI Publisher :l_hit_ratio :l_no_receipts_processed :l_no_remit_lines_autoapply :l_no_remit_lines_processed :l_no_remit_lines_suggested :l_org_name :operating_unit :p_batch_name_h :p_batch_name_l :p_customer_name_h :p_customer_name_l :p_customer_no_h :p_customer_no_l :p_min_unapp_amt :p_org_id :p_receipt_date_h :p_receipt_date_l :p_receipt_method_h :p_receipt_method_l :p_receipt_no_h :p_receipt_no_l :p_total_workers 1 10 :p_org_id LOV Oracle AR_AA_OPERATING_UNIT Y select organization_id id, substrb(hr.name,1,50) value, null description from hr_operating_units hr where mo_global.check_access(hr.organization_id)='Y' order by value,description Y AR وحدة التشغيل D Betriebseinheit F Unité opérationnelle US Operating Unit ZHS 业务实体 2 20 :p_receipt_no_l LOV Oracle AR_AA_RECEIPT_NUMBER Y select cr1.receipt_number id, cr1.receipt_number value, null description from ar_cash_receipts cr1 where cr1.cash_receipt_id in (select max(cr2.cash_receipt_id) from ar_cash_receipts cr2 where cr2.receipt_number=cr1.receipt_number) order by cr1.receipt_number,cr1.cash_receipt_id AR رقم إيصال من D Von Zahlungsnummer F Numéro de règlement - De US Receipt Number Low ZHS 收款编号下限 3 30 :p_receipt_no_h LOV Oracle AR_AA_RECEIPT_NUMBER Y select cr1.receipt_number id, cr1.receipt_number value, null description from ar_cash_receipts cr1 where cr1.cash_receipt_id in (select max(cr2.cash_receipt_id) from ar_cash_receipts cr2 where cr2.receipt_number=cr1.receipt_number) order by cr1.receipt_number,cr1.cash_receipt_id AR رقم إيصال إلى D Bis Zahlungsnummer F Numéro de règlement - A US Receipt Number High ZHS 接收编号上限 4 40 :p_batch_name_l LOV Oracle AR_AA_BATCH_NAME Y select bat1.name id, bat1.name value, null description from ar_batches bat1 where bat1.status='OP' and bat1.type='MANUAL' and bat1.batch_id in (select max(batch_id) from ar_batches bat2 where bat2.name=bat1.name) order by bat1.name AR اسم مجموعات الإيصالات من D Von Belegart F Nom de lot de règlements - De US Receipt Batch Name low ZHS 收款批名下限 5 50 :p_batch_name_h LOV Oracle AR_AA_BATCH_NAME Y select bat1.name id, bat1.name value, null description from ar_batches bat1 where bat1.status='OP' and bat1.type='MANUAL' and bat1.batch_id in (select max(batch_id) from ar_batches bat2 where bat2.name=bat1.name) order by bat1.name AR اسم مجموعات الإيصالات إلى D Bis Belegart F Nom de lot de règlements - A US Receipt Batch Name High ZHS 收款批名上限 6 60 :p_min_unapp_amt Number AR الحد الأدنى للمبلغ غير المطبق D Nicht zugeordneter Mindestbetrag F Montant minimum non lettré US Minimum Unapplied Amount ZHS 最小未核销额 7 70 :p_receipt_date_l Date AR تاريخ الإيصال من D Von Zahlungsdatum F Date de règlement - Du US Receipt Date From ZHS 收款起始日期 8 80 :p_receipt_date_h Date AR تاريخ الإيصال إلى D Bis Zahlungsdatum F Date de règlement - Au US Receipt Date To ZHS 收款终止日期 9 90 :p_receipt_method_l LOV Oracle AR_AA_RECEIPT_METHOD Y select name id, name value, null description from ar_receipt_methods where sysdate between start_date and nvl(end_date,sysdate+1) order by value,description AR طريقة الإيصال من D Von Kundenzahlungsart F Mode de règlement - De US Receipt Method Low ZHS 收款方法下限 10 100 :p_receipt_method_h LOV Oracle AR_AA_RECEIPT_METHOD Y select name id, name value, null description from ar_receipt_methods where sysdate between start_date and nvl(end_date,sysdate+1) order by value,description AR طريقة الإيصال إلى D Bis Kundenzahlungsart F Mode de règlement - A US Receipt Method High ZHS 收款方法上限 11 110 :p_customer_name_l LOV Oracle AR_AA_CUSTOMER_NAME Y select substrb(party.party_name,1,50) id, substrb(party.party_name,1,50) 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 Kundenname F Nom du client - De US Customer Name Low ZHS 客户名称下限 12 120 :p_customer_name_h LOV Oracle AR_AA_CUSTOMER_NAME Y select substrb(party.party_name,1,50) id, substrb(party.party_name,1,50) 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 Kundenname F Nom de client - A US Customer Name High ZHS 客户名称上限 13 130 :p_customer_no_l LOV Oracle AR_AA_CUSTOMER_NUMBER 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 客户编号下限 14 140 :p_customer_no_h LOV Oracle AR_AA_CUSTOMER_NUMBER 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 客户编号上限 15 150 :p_total_workers Number 1 Y AR عدد الطبعات D Anzahl Instanzen F Nombre d'instances US No. Of Instances ZHS 例程数