ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 B00957FD23E6426EE0530100007F2406Y select x.company_name ,x.currency_main currency ,x.cons_number billing_number ,x.type ,x.due_date ,x.customer_name ,x.customer_number ,x.collector ,x.invoice_amount ,x.balance_due ,x.dispute_amount ,x.notes from ( select sob.company_name, ar_payment_schedules.invoice_currency_code currency_main, decode(upper(:p_order_by),'CUSTOMER',cust.account_number,null) dummy_customer_number, decode(upper(:p_order_by),'CUSTOMER',substrb(party.party_name,1,50),null) dummy_customer_name, ar_payment_schedules.trx_number number_, ra_cust_trx_types.name type, ar_payment_schedules.due_date due_date, substrb(party.party_name,1,50) customer_name, cust.account_number customer_number, cust.cust_account_id customer_id, ar_collectors.name collector, ar_payment_schedules.amount_due_original invoice_amount, ar_payment_schedules.amount_due_remaining balance_due, ar_payment_schedules.amount_in_dispute dispute_amount, ar_payment_schedules.customer_trx_id customer_trx_id, decode(sob.functional_acct_unit, null, round( ar_payment_schedules.amount_due_original * nvl(ar_payment_schedules.exchange_rate, 1), sob.functional_currency_precision), round( ( ar_payment_schedules.amount_due_original * nvl(ar_payment_schedules.exchange_rate, 1))/ sob.functional_acct_unit ) * sob.functional_acct_unit ) func_amount_due, ar_payment_schedules.acctd_amount_due_remaining func_amount_rem, decode(sob.functional_acct_unit, null, round( ar_payment_schedules.amount_in_dispute * nvl(ar_payment_schedules.exchange_rate, 1), sob.functional_currency_precision), round( ( ar_payment_schedules.amount_in_dispute * nvl(ar_payment_schedules.exchange_rate, 1))/ sob.functional_acct_unit ) * sob.functional_acct_unit ) func_amount_dis, &lp_query_show_bill_mo cons_bill_number, ar_arxdir_xmlp_pkg.c_data_not_foundformula(ar_payment_schedules.invoice_currency_code) c_data_not_found, ar_arxdir_xmlp_pkg.c_currency_summary_labelformul(ar_payment_schedules.invoice_currency_code) c_currency_summary_label, ar_arxdir_xmlp_pkg.c_cust_summary_labelformula(decode ( upper ( :p_order_by ) , 'CUSTOMER' , substrb ( party.party_name , 1 , 50 ) , null )) c_cust_summary_label, ar_arxdir_xmlp_pkg.cons_numberformula(ar_payment_schedules.trx_number, &lp_query_show_bill_mo) cons_number, notes.text notes from (select sob.name company_name, sob.set_of_books_id, sob.chart_of_accounts_id coa_id, sob.currency_code functional_currency, cur.precision functional_currency_precision, cur.minimum_accountable_unit functional_acct_unit from gl_sets_of_books sob, fnd_currencies cur where sob.currency_code = cur.currency_code ) sob, hr_operating_units hou, ar_payment_schedules_all ar_payment_schedules, ra_customer_trx_all, ra_cust_trx_types_all ra_cust_trx_types, hz_cust_accounts cust, hz_parties party, hz_customer_profiles cust_cp, hz_customer_profiles site_cp, &lp_table_show_bill_mo ar_collectors, ( select distinct y.customer_trx_id , listagg(y.text,chr(10)) within group (order by y.text) over (partition by y.customer_trx_id) text from ( select arn.customer_trx_id , arn.text , sum(lengthb(arn.text)+1) over (partition by arn.customer_trx_id order by arn.note_id rows between unbounded preceding and current row) lengthb from ( select ar_notes.customer_trx_id , ar_notes.note_id , ar_notes.text from ar_notes ) arn ) y where y.lengthb <= 4000 ) notes where cust.party_id = party.party_id and ar_payment_schedules.customer_trx_id = ra_customer_trx_all.customer_trx_id and ra_customer_trx_all.set_of_books_id = sob.set_of_books_id and ra_customer_trx_all.org_id = hou.organization_id and hou.set_of_books_id = sob.set_of_books_id and ar_payment_schedules.cust_trx_type_id = ra_cust_trx_types.cust_trx_type_id and ar_payment_schedules.org_id = ra_cust_trx_types.org_id and ar_payment_schedules.customer_id = cust.cust_account_id and cust.cust_account_id = cust_cp.cust_account_id and cust_cp.site_use_id is null and ar_payment_schedules.customer_site_use_id = site_cp.site_use_id(+) and nvl(site_cp.collector_id,cust_cp.collector_id) = ar_collectors.collector_id and ar_payment_schedules.amount_in_dispute != 0 and ra_customer_trx_all.customer_trx_id = notes.customer_trx_id (+) and 1=1 &lp_due_date_low &lp_due_date_high &lp_item_number_low &lp_item_number_high &lp_customer_name_low &lp_customer_name_high &lp_customer_number_low &lp_customer_number_high &lp_collector_low &lp_collector_high &lp_where_show_bill_mo &lp_order_by ) x Changed to lowercase AR ARXDIR_XML AR AR Disputed Invoice Application: المقبوضات Source: تقرير الفواتير موضع النزاع (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: ARXDIR_XML DB package: AR_ARXDIR_XMLP_PKG D AR Disputed Invoice Application: Debitoren Source: Rechnungen - strittig (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: ARXDIR_XML DB package: AR_ARXDIR_XMLP_PKG E AR Disputed Invoice Importación del informe estándar de Oracle sobre facturas impugnadas Fuente: Informe de facturas impugnadas (XML) Nombre corto: ARXDIR_XML Paquete DB: AR_ARXDIR_XMLP_PKG F AR Disputed Invoice Application: Receivables Source: Etat Factures en litige (XML) - Non pris en charge : réservé en vue d'une utilisation future Short Name: ARXDIR_XML DB package: AR_ARXDIR_XMLP_PKG I AR Disputed Invoice Application: Receivables Source: Rapporto Fatture contestate (XML) - non supportato: riservato per usi futuri Short Name: ARXDIR_XML DB package: AR_ARXDIR_XMLP_PKG JA AR Disputed Invoice Oracle標準の係争中の請求書レポートをインポート 出典は、以下の通りです。争点となった請求書レポート（XML 短縮名。ARXDIR_XML DB パッケージ。AR_ARXDIR_XMLP_PKG KO AR Disputed Invoice 가져온 Oracle 표준 분쟁 송장 보고서 출처 : 분쟁 송장 보고서 (XML) 짧은 이름 : ARXDIR_XML DB 패키지 : AR_ARXDIR_XMLP_PKG PTB AR Disputed Invoice Relatório de fatura contestada padrão importado da Oracle Fonte: Relatório de Fatura Contestável (XML) Nome curto: ARXDIR_XML Pacote DB: AR_ARXDIR_XMLP_PKG RU AR Disputed Invoice Импортированный стандартный спорный отчет по счету-фактуре Oracle Источник: Спорный отчет по счету-фактуре (XML) Короткое имя: ARXDIR_XML БД-пакет: AR_ARXDIR_XMLP_PKG S AR Disputed Invoice Importerad Oracle standard omstridd fakturarapport Källa: Disputed Invoice Report (XML) Kort namn: ARXDIR_XML DB-paket: AR_ARXDIR_XMLP_PKG TR AR Disputed Invoice İçe aktarılan Oracle standart itirazlı fatura raporu Kaynak: İtiraz Edilen Fatura Raporu (XML) Kısa isim: ARXDIR_XML DB paketi: AR_ARXDIR_XMLP_PKG US AR Disputed Invoice Imported Oracle standard disputed invoice report Source: Disputed Invoice Report (XML) Short Name: ARXDIR_XML DB package: AR_ARXDIR_XMLP_PKG ZHS AR Disputed Invoice Application: 应收帐款 Source: 争议发票报表 (XML) - 不支持：已保留供将来使用 Short Name: ARXDIR_XML DB package: AR_ARXDIR_XMLP_PKG Enginatics R12 only &lp_collector_high &lp_collector_low &lp_customer_name_high &lp_customer_name_low &lp_customer_number_high &lp_customer_number_low &lp_due_date_high &lp_due_date_low &lp_item_number_high &lp_item_number_low &lp_order_by &lp_query_show_bill_mo &lp_table_show_bill_mo &lp_where_show_bill_mo 1=1 :lp_collector_high :lp_collector_low :lp_customer_name_high :lp_customer_name_low :lp_customer_number_high :lp_customer_number_low :lp_due_date_high :lp_due_date_low :lp_item_number_high :lp_item_number_low :lp_order_by :lp_query_show_bill :lp_status :lp_table_show_bill :lp_where_show_bill :operating_unit :p_collector_high :p_collector_low :p_conc_request_id :p_cons_profile_value :p_customer_name_high :p_customer_name_low :p_customer_number_high :p_customer_number_low :p_due_date_high :p_due_date_low :p_invoice_status :p_invoice_status_param :p_item_number_high :p_item_number_low :p_order_by :p_order_by_t :p_set_of_books_id :rp_company_name :rp_data_found :rp_report_name :rp_sum_for :rpd_report_total_bal :rpd_report_total_disp :rpd_report_total_inv 1 10 1=1 hou.name=:operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) Y US Operating Unit 2 &lp_query_show_bill_mo select decode (nvl(AR_SETUP.value('AR_SHOW_BILLING_NUMBER',204),'N') ,'N','to_char(NULL)','ci.cons_billing_number') from dual US Operating Unit 3 &lp_table_show_bill_mo select decode (nvl(AR_SETUP.value('AR_SHOW_BILLING_NUMBER',204),'N') ,'N',' ','ar_cons_inv_all ci,') from dual US Operating Unit 4 &lp_where_show_bill_mo select decode (nvl(AR_SETUP.value('AR_SHOW_BILLING_NUMBER',204),'N') ,'N',' ','and ar_payment_schedules.cons_inv_id = ci.cons_inv_id(+)') from dual US Operating Unit 5 20 :p_order_by LOV Oracle AR_ARXDIR_SORT_BY Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='SORT_BY_ARXDIR' order by meaning Customer Y US Order By 6 30 :p_customer_name_low LOV Oracle AR_CUSTOMER_NAME Y Y select party.party_name id, party.party_name value, null description from hz_cust_accounts cu,hz_parties party where cu.party_id=party.party_id and cu.cust_account_id in (select cu2.cust_account_id from hz_cust_accounts cu2,hz_parties party2 where cu2.party_id=party2.party_id and party2.party_name= party.party_name) order by party.party_name US Customer Name Low 7 40 :p_customer_name_high LOV Oracle AR_CUSTOMER_NAME Y Y select party.party_name id, party.party_name value, null description from hz_cust_accounts cu,hz_parties party where cu.party_id=party.party_id and cu.cust_account_id in (select cu2.cust_account_id from hz_cust_accounts cu2,hz_parties party2 where cu2.party_id=party2.party_id and party2.party_name= party.party_name) order by party.party_name :$flex$.customer_name_low US Customer Name High 8 50 :p_customer_number_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 US Customer Number Low 9 60 :p_customer_number_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 :$flex$.customer_number_low US Customer Number High 10 70 :p_item_number_low LOV Oracle AR_INVOICE_NUMBER Y Y select ct.trx_number id, ct.trx_number value, null description from ra_customer_trx ct where ct.customer_trx_id in ( select max(ct2.customer_trx_id) from ra_customer_trx ct2 where ct.trx_number=ct2.trx_number) order by ct.trx_number,ct.customer_trx_id US Invoice Number Low 11 80 :p_item_number_high LOV Oracle AR_INVOICE_NUMBER Y Y select ct.trx_number id, ct.trx_number value, null description from ra_customer_trx ct where ct.customer_trx_id in ( select max(ct2.customer_trx_id) from ra_customer_trx ct2 where ct.trx_number=ct2.trx_number) order by ct.trx_number,ct.customer_trx_id :$flex$.invoice_number_low US Invoice Number High 12 90 :p_due_date_low Date US Due Date Low 13 100 :p_due_date_high Date US Due Date High 14 110 :p_collector_low LOV Oracle AR_COLLECTOR_NAME Y select name id, name value, null description from ar_collectors where status!='I' order by name,collector_id US Collector Low 15 120 :p_collector_high LOV Oracle AR_COLLECTOR_NAME Y select name id, name value, null description from ar_collectors where status!='I' order by name,collector_id :$flex$.collector_low US Collector High 16 130 1=1 ar_payment_schedules.status = decode(:p_invoice_status,'O','OP','CL') LOV Oracle AR_OPEN_CLOSE Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='CLOSING_STATUS' and lookup_code in ('C','O') order by value,description US Invoice Status :$flex$.collector_low Collector Low Collector High :$flex$.customer_name_low Customer Name Low Customer Name High :$flex$.customer_number_low Customer Number Low Customer Number High :$flex$.invoice_number_low Invoice Number Low Invoice Number High