ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4783869E053B46B63588994 select decode (:P_ORDER_BY, 'NUMBER',abb1.bank_number, 'NAME', decode (:H_SORT_BY_PHONETIC, 'N', nvl(abb1.bank_name,nvl(abc.transferring_bank_name,abc.transferring_bank)), 'Y', abb1.bank_name_alt,nvl(abc.transferring_bank_name,abc.transferring_bank))) C_ORDER, abb1.bank_number C_TRANSFER_BANK_NUMBER, abb1.bank_name C_TRANSFER_BANK_NAME, abb1.branch_number C_TRANSFER_BANK_NUM, abb1.bank_branch_name C_TRANSFER_BANK_BRANCH_NAME, abb2.bank_number C_RECEIVE_BANK_NUMBER, abb2.bank_name C_RECEIVE_BANK_NAME, abb2.branch_number C_RECEIVE_BANK_NUM, abb2.bank_branch_name C_RECEIVE_BANK_BRANCH_NAME, abc.transferring_bank C_TRANSFERRING_BANK, abc.transferring_bank_name C_TRANSFERRING_BANK_NAME, abc.transferring_branch C_TRANSFERRING_BRANCH, abc.receiving_bank C_RECEIVING_BANK, abc.receiving_bank_name C_RECEIVING_BANK_NAME, abc.receiving_branch C_RECEIVING_BRANCH, abcl.trans_amount_from C_TRANS_AMOUNT_FROM, abcl.trans_amount_to C_TRANS_AMOUNT_TO, abcl.bank_charge_standard C_BANK_CHARGE_STANDARD, abcl.bank_charge_negotiated C_BANK_CHARGE_NEGOTIATED, abcl.tolerance_limit C_TOLERANCE_LIMIT, abcl.start_date C_START_DATE, abcl.end_date C_END_DATE, abc.transfer_priority C_TRANSFER_PRIORITY, AP_APXBCRPT_XMLP_PKG.c_line_transfer_priorityformul(abc.transfer_priority) C_LINE_TRANSFER_PRIORITY from ap_bank_charges abc, ce_bank_branches_v abb1, ce_bank_branches_v abb2, ap_bank_charge_lines abcl &lp_ap_ar_tab where abc.transferring_bank_branch_id = abb1.branch_party_id(+) and abc.receiving_bank_branch_id = abb2.branch_party_id(+) and abc.bank_charge_id = abcl.bank_charge_id and abc.currency_code = :P_CURRENCY_CODE and ( abb1.bank_name = :P_TRANSFERRING_BANK_NAME or ( abc.transferring_bank = 'ONE' and transferring_bank_name = :P_TRANSFERRING_BANK_NAME ) or :P_TRANSFERRING_BANK_NAME is null or ( abc.transferring_bank = 'ALL' and abc.transferring_bank_name is NULL )) and ( abc.transfer_priority = :P_TRANSFER_PRIORITY or :P_TRANSFER_PRIORITY is null )and (abc.transfer_priority = :P_TRANSFER_PRIORITY or :P_TRANSFER_PRIORITY is null) &lp_ap_ar_where and ((:H_APPLICATION_ID = 200 and abc.transfer_priority<>'AR') or (:H_APPLICATION_ID = 222 and abc.transfer_priority='AR')) ORDER BY 1 ASC,4 ASC,6 ASC,8 ASC,5 ASC,7 ASC,9 ASC,15 ASC,10 ASC,12 ASC,13 ASC,14 ASC,2 ASC,3 ASC,11 ASC SQLAP APXBCRPT_XML AR AP تقرير المصروفات البنكية (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: المدفوعات Source: تقرير المصروفات البنكية (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: APXBCRPT_XML DB package: AP_APXBCRPT_XMLP_PKG D AP Bankgebühren- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Kreditoren Source: Bankgebühren (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: APXBCRPT_XML DB package: AP_APXBCRPT_XMLP_PKG F AP Etat des frais bancaires- Non pris en charge : réservé pour une utilisation future Application: Payables Source: Etat des frais bancaires (XML) - Non pris en charge : réservé pour une utilisation future Short Name: APXBCRPT_XML DB package: AP_APXBCRPT_XMLP_PKG US AP Bank Charges - draft Application: Payables Source: Bank Charges Report (XML) - Not Supported: Reserved For Future Use Short Name: APXBCRPT_XML DB package: AP_APXBCRPT_XMLP_PKG ZHS AP 银行手续费报表- 不支持：已保留供将来使用 Application: 应付帐款 Source: 银行手续费报表 (XML) - 不支持：已保留供将来使用 Short Name: APXBCRPT_XML DB package: AP_APXBCRPT_XMLP_PKG BI Publisher &lp_ap_ar_tab &lp_ap_ar_where :h_application_id :h_company_name :h_currency_code :h_sort_by_phonetic :lp_ap_ar_tab :lp_ap_ar_where :operating_unit :p_conc_request_id :p_currency_code :p_order_by :p_transfer_priority :p_transferring_bank_name 1 10 :p_currency_code LOV Oracle AP_SRS_CURRENCY Y select currency_code id, currency_code value, description description from fnd_currencies_vl where currency_flag='Y' and enabled_flag in ('Y','N') order by currency_code select base_currency_code from ap_system_parameters Y AR العملة D Währung F Devise US Currency ZHS 币种 2 20 :p_transferring_bank_name LOV Oracle AP_SRS_TRANSFERRING_BANK Y select nvl(transferring_bank_name,'ALL') id, nvl(transferring_bank_name,'ALL') value, null description from ap_bank_charges abc1 where bank_charge_id= (select max(bank_charge_id) from ap_bank_charges abc2 where nvl(abc1.transferring_bank_name,'All')= nvl(abc2.transferring_bank_name,'All')) order by transferring_bank_name AR اسم بنك التحويل D Überweisungsbank F Nom de la banque émettrice US Transferring Bank Name ZHS 转帐银行名称 3 30 :p_transfer_priority LOV Oracle AP_SRS_TRANSFER_PRIORITY Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where lookup_type='TRANSFER_PRIORITY' and nvl(inactive_date,sysdate+1)>sysdate order by value,description AR أولوية التحويل D Transferpriorität F Priorité de transfert US Transfer Priority ZHS 转帐优先级 4 40 :p_order_by LOV Oracle AP_SRS_BANK_CHARGE_ORDER Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where lookup_type='BANK_CHARGE_SORT_OPTION' and nvl(inactive_date,sysdate+1)>sysdate order by value,description Y AR ترتيب بواسطة D Sortieren nach F Tri par US Order By ZHS 排序依据