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）限制的操作单元。 C6E085D46F4251A9E05362FB09050512 select :CP_order_by order_by_cu, CR.receipt_number note_number_cu, CR.amount note_amount_cu, CR.currency_code currency_code_cu, CR.issuer_name issuer_name_cu, CR.issue_date issue_date_cu, CR.reversal_date reversal_date_cu, PS.due_date maturity_date_cu, SUBSTRB(PARTY.PARTY_NAME,1,50) cust_name_cu, CU.ACCOUNT_NUMBER cust_num_cu, SU.location site_name_cu, CBA.bank_account_name bank_account_cu, BB.bank_name remittance_bank_cu, BBI.bank_name issuer_bank_name_cu, PSX.trx_number debit_memo_cu, DECODE(CRX.reversal_date, NULL, CRX.receipt_number, ' ') exchange_note_cu, LK.meaning status_cu, DECODE(:RP_SORT_BY_PHONETICS, 'Y', PARTY.ORGANIZATION_NAME_PHONETIC, SUBSTRB(PARTY.PARTY_NAME,1,50)) customer_name_sort_cu, DECODE(:RP_SORT_BY_PHONETICS, 'Y', BB.bank_name_alt, BB.bank_name) bank_name_sort_cu from ar_cash_receipts CR, ar_cash_receipts CRX, ar_cash_receipt_history RH, ar_receipt_methods RM, ar_receipt_classes RC, ce_bank_acct_uses BA, ce_bank_accounts CBA, ce_bank_branches_v BB, ce_bank_branches_v BBI, ar_payment_schedules PS, ar_payment_schedules PSX, HZ_CUST_ACCOUNTS CU, HZ_PARTIES PARTY, HZ_CUST_site_uses SU, ar_receivable_applications RAX, ar_lookups LK WHERE :P_ORDER_BY = 'CUSTOMER' AND CR.reversal_date is not NULL AND CR.reversal_date >= nvl(:P_START_REVERSAL_DATE, CR.reversal_date) AND CR.reversal_date <= nvl(:P_END_REVERSAL_DATE, CR.reversal_date) AND CR.currency_code = nvl(:P_CURRENCY_CODE, CR.currency_code) AND RH.cash_receipt_id = CR.cash_receipt_id AND RH.current_record_flag = 'Y' AND RM.receipt_method_id = CR.receipt_method_id AND RC.receipt_class_id = RM.receipt_class_id AND nvl(RC.notes_receivable,'N') = 'Y' AND BA.bank_acct_use_id = CR.remit_bank_acct_use_id AND BA.bank_account_id = CBA.bank_account_id AND BA.bank_acct_use_id = nvl(:P_BANK_ACCOUNT, BA.bank_acct_use_id) AND BB.branch_party_id = CBA.bank_branch_id AND BB.bank_name = nvl(:P_REMITTANCE_BANK, BB.bank_name) AND BBI.branch_party_id(+) = CR.issuer_bank_branch_id AND PS.cash_receipt_id = CR.cash_receipt_id AND PS.due_date >= nvl(:P_START_MATURITY_DATE, PS.due_date) AND PS.due_date <= nvl(:P_END_MATURITY_DATE, PS.due_date) AND CU.CUST_ACCOUNT_ID (+) = CR.pay_from_customer AND CU.PARTY_ID = PARTY.PARTY_ID(+) AND CU.ACCOUNT_NUMBER = nvl(:P_CUSTOMER_NUMBER, CU.ACCOUNT_NUMBER) AND SU.site_use_id(+) = CR.customer_site_use_id AND PSX.reversed_cash_receipt_id(+) = PS.cash_receipt_id AND nvl(PSX.payment_schedule_id, -1) in (select nvl(max(payment_schedule_id), -1) from ar_payment_schedules PSS where PSS.reversed_cash_receipt_id = CR.cash_receipt_id and PSS.class = 'DM') AND RAX.applied_payment_schedule_id (+) = PSX.payment_schedule_id AND nvl(RAX.receivable_application_id, -1) in (select nvl(max(RAXX.receivable_application_id), -1) from ar_receivable_applications RAXX where RAXX.applied_payment_schedule_id = RAX.applied_payment_schedule_id and RAXX.status = 'APP') AND CRX.cash_receipt_id(+) = RAX.cash_receipt_id AND DECODE(:P_NON_EXCHANGED, 'Y', DECODE(PSX.trx_number, NULL, 'N', DECODE(CRX.receipt_number, NULL, 'Y', DECODE(CRX.reversal_date, NULL, 'N', 'Y'))), 'Y') = 'Y' AND LK.lookup_code = DECODE(PSX.trx_number, NULL, 'RETURN', DECODE(CR.reversal_date-PS.due_date, 0, 'RETURN', DECODE((CR.reversal_date-PS.due_date+1)/abs(CR.reversal_date-PS.due_date+1), -1, 'RETURN', DECODE(RH.factor_flag, 'N', 'DELINQUENT', 'REPURCHASE')))) AND LK.lookup_type = 'AR_NOTE_STATUS' and LK.lookup_code = nvl(:P_NOTE_STATUS, LK.lookup_code) order by CR.reversal_date, DECODE(:RP_SORT_BY_PHONETICS, 'Y', BB.bank_name_alt, BB.bank_name) Y AR ARXNRREV_XML Y AR AR تقرير أوراق القبض المعكوسة (بتنسيق XML) Imported from BI Publisher Description: تقرير أوراق القبض المعكوسة Application: المقبوضات Source: تقرير أوراق القبض المعكوسة (بتنسيق XML) Short Name: ARXNRREV_XML DB package: AR_ARXNRREV_XMLP_PKG D AR Stornierte Wechselforderungen Imported from BI Publisher Description: Auswertung "Stornierte Wechselforderungen" Application: Debitoren Source: Stornierte Wechselforderungen (XML) Short Name: ARXNRREV_XML DB package: AR_ARXNRREV_XMLP_PKG E AR Documentos Posdatados Revertidos Imported from BI Publisher Description: Informe de documentos posdatados revertidos Application: Receivables Source: Documentos Posdatados Revertidos (XML) Short Name: ARXNRREV_XML DB package: AR_ARXNRREV_XMLP_PKG F AR Etat Effets à recevoir annulés Imported from BI Publisher Description: Etat des effets à recevoir annulés Application: Receivables Source: Etat Effets à recevoir annulés (XML) Short Name: ARXNRREV_XML DB package: AR_ARXNRREV_XMLP_PKG I AR Rapporto Note conto clienti stornate Imported from BI Publisher Description: Rapporto sulle note stornate conto clienti Application: Receivables Source: Rapporto Note conto clienti stornate (XML) Short Name: ARXNRREV_XML DB package: AR_ARXNRREV_XMLP_PKG JA AR 戻し処理済受取手形レポート Imported from BI Publisher Description: 戻し処理済受取手形レポート Application: Receivables Source: 戻し処理済受取手形レポート(XML) Short Name: ARXNRREV_XML DB package: AR_ARXNRREV_XMLP_PKG KO AR 취소된 받을 어음 보고서 Imported from BI Publisher Description: 취소된 받을 어음 보고서 Application: Receivables Source: 취소된 받을 어음 보고서(XML) Short Name: ARXNRREV_XML DB package: AR_ARXNRREV_XMLP_PKG PTB AR Relatório de Notas a Receber Estornadas Imported from BI Publisher Description: Relatório de Notas a Receber Estornadas Application: Receivables Source: Relatório de Notas a Receber Estornadas (XML) Short Name: ARXNRREV_XML DB package: AR_ARXNRREV_XMLP_PKG RU AR Отчет о сторнированных векселях к получению Imported from BI Publisher Description: Отчет о сторнированных векселях к получению Application: Дебиторы Source: Отчет о сторнированных векселях к получению (XML) Short Name: ARXNRREV_XML DB package: AR_ARXNRREV_XMLP_PKG S AR Återförda växelfordringar - rapport Imported from BI Publisher Description: Återförda växelfordringar - rapport Application: Receivables Source: Återförda växelfordringar - rapport (XML) Short Name: ARXNRREV_XML DB package: AR_ARXNRREV_XMLP_PKG TR AR Ters Kaydı Yapılan Alacak Senetleri Raporu Imported from BI Publisher Description: Ters Kaydı Yapılan Alacak Senetleri Raporu Application: Alacaklar Muhasebesi Source: Ters Kaydı Yapılan Alacak Senetleri Raporu (XML) Short Name: ARXNRREV_XML DB package: AR_ARXNRREV_XMLP_PKG US AR Reversed Notes Receivable Imported from BI Publisher Description: Reversed Notes Receivable Report Application: Receivables Source: Reversed Notes Receivable Report (XML) Short Name: ARXNRREV_XML DB package: AR_ARXNRREV_XMLP_PKG ZHS AR 已冲销应收票据报表 Imported from BI Publisher Description: 已冲销应收票据报表 Application: 应收帐款 Source: 已冲销应收票据报表 (XML) Short Name: ARXNRREV_XML DB package: AR_ARXNRREV_XMLP_PKG BI Publisher :cp_order_by :operating_unit :p_bank_account :p_conc_request_id :p_currency_code :p_customer_number :p_end_maturity_date :p_end_reversal_date :p_non_exchanged :p_note_status :p_order_by :p_remittance_bank :p_set_of_books_id :p_start_maturity_date :p_start_reversal_date :rp_company_name :rp_data_found :rp_report_name :rp_sort_by_phonetics :rp_sub_title 1 -20 :p_set_of_books_id LOV Oracle AR_SRS_SET_OF_BOOKS_ID Y select set_of_books_id id, set_of_books_id value, null description from ar_system_parameters order by value,description select set_of_books_id from ar_system_parameters Y AR دفتر الأستاذ دفتر الأستاذ D Buch Buch E Libro Mayor Libro mayor F Livre Livre I Libro contabile Libro contabile JA 元帳 元帳 KO 원장 원장 PTB Razão Razão RU Книга Книга S Huvudbok Huvudbok TR Defter Defter US Ledger Ledger ZHS 分类帐 分类帐 2 0 :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 select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 3 10 :p_currency_code 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 Währung Währung E Código de Divisa Código de Divisa F Code devise Code devise I Codice divisa Codice della divisa JA 通貨コード 通貨コード KO 통화 코드 통화 코드 PTB Código da Moeda Código da Moeda RU Код валюты Код валюты S Valutakod Valutakod TR Para Birimi Kodu Para Birimi Kodu US Currency Code Currency Code ZHS 币种代码 币种代码 4 20 :p_order_by LOV Oracle AR_ARXNRREV_ORDER_BY Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='ARXNRREV_ORDER_BY' order by value,description select meaning from ar_lookups where lookup_type = 'ARXNRREV_ORDER_BY' and lookup_code = 'REMITTANCE_BANK' Y AR خيار الفرز خيار الفرز D Sortieroption Sortieroption E Opción de Ordenación Opción de ordenación F Option de tri Option de tri I Opzione di ordinamento Opzione di ordinamento JA ソート・オプション ソート・オプション KO 정렬 옵션 정렬 옵션 PTB Opção de Classificação Opção de Classificação RU Параметр сортировки Параметр сортировки S Sorteringsalternativ Sorteringsalternativ TR Sıralama Seçeneği Sıralama Seçeneği US Sort Option Sort Option ZHS 排序选项 排序选项 5 30 :p_start_maturity_date Date AR تاريخ بداية الاستحقاق تاريخ بداية الاستحقاق D Von Fälligkeitsdatum Von Fälligkeitsdatum E De Fecha de Vencimiento De fecha de vencimiento F Date de début d'exigibilité Date de début d'exigibilité I Data scadenza iniziale Data di scadenza iniziale JA 開始満期日 開始満期日 KO 만기 시작 일자 만기 시작 일자 PTB Data de Vencimento Inicial Data de Vencimento Inicial RU Дата погашения с Дата погашения с S Från förfallodatum Från förfallodatum TR Başlangıç Vade Tarihi Başlangıç Vade Tarihi US Start Maturity Date Start Maturity Date ZHS 起始到期日 起始到期日 6 40 :p_end_maturity_date Date AR تاريخ نهاية الاستحقاق تاريخ نهاية الاستحقاق D Bis Fälligkeitsdatum Bis Fälligkeitsdatum E A Fecha de Vencimiento A fecha de vencimiento F Date de fin d'exigibilité Date de fin d'exigibilité I Data scadenza finale Data di scadenza finale JA 満期日:至 満期日:至 KO 만기 종료 일자 만기 종료 일자 PTB Data de Vencimento Final Data de Vencimento Final RU Дата погашения по Дата погашения по S Till förfallodatum Till förfallodatum TR Bitiş Vade Tarihi Bitiş Vade Tarihi US End Maturity Date End Maturity Date ZHS 终止到期日 终止到期日 7 50 :p_start_reversal_date Date AR تاريخ بداية العكس تاريخ بداية العكس D Von Korrekturdatum Von Korrekturdatum E De Fecha de Reversión De Fecha de Reversión F Date début contrepassation Date début contrepassation I Data storno iniziale Data di storno iniziale JA 戻し処理日:自 戻し処理日:自 KO 취소 시작 일자 취소 시작 일자 PTB Data de Estorno Inicial Data de Estorno Inicial RU Дата сторнирования с Дата сторнирования с S Från återföringsdatum Från återföringsdatum TR Başlangıç Ters İşlem Tarihi Başlangıç Ters İşlem Tarihi US Start Reversal Date Start Reversal Date ZHS 起始冲销日期 起始冲销日期 8 60 :p_end_reversal_date Date AR تاريخ نهاية العكس تاريخ نهاية العكس D Bis Korrekturdatum Bis Korrekturdatum E A Fecha de Reversión A Fecha de Reversión F Date fin contrepassation Date fin contrepassation I Data storno finale Data di storno finale JA 戻し処理日:至 戻し処理日:至 KO 취소 종료 일자 취소 종료 일자 PTB Data de Estorno Final Data de Estorno Final RU Дата сторнирования по Дата сторнирования по S Till återföringsdatum Till återföringsdatum TR Bitiş Ters İşlem Tarihi Bitiş Ters İşlem Tarihi US End Reversal Date End Reversal Date ZHS 终止冲销日期 终止冲销日期 9 70 :p_remittance_bank LOV Oracle AR_REMITTANCE_BANK_NAME Y select bb.bank_name id, bb.bank_name value, null description from ce_bank_branches_v bb where exists ( select cba.bank_branch_id from ce_bank_acct_uses ba,ce_bank_accounts cba where cba.bank_branch_id=bb.branch_party_id and ba.bank_account_id=cba.bank_account_id and cba.account_classification='INTERNAL') order by bb.bank_name AR البنك المستفيد البنك المستفيد D Eigene Bank Eigene Bank E Banco de Remesa Banco de remesa F Banque de remise Banque de remise I Banca di rimessa Banca di rimessa JA 送金銀行 送金銀行 KO 수탁 은행 수탁 은행 PTB Banco para Remessa Banco para Remessa RU Банк-корреспондент Банк-корреспондент S Överföringsbank Överföringsbank TR Tahsile Verilen Banka Tahsile Verilen Banka US Remittance Bank Remittance Bank ZHS 汇款银行 汇款银行 10 80 :p_bank_account LOV Oracle AR_REMITTANCE_ACCOUNTS Y select bank_acct_use_id id, cba.bank_account_name value, null description from ce_bank_acct_uses uses,ce_bank_accounts cba,ce_bank_branches_v bb where cba.bank_account_id=uses.bank_account_id and bb.branch_party_id=cba.bank_branch_id and cba.account_classification='INTERNAL' order by bank_account_name AR حساب التحويل النقدي حساب التحويل النقدي D Konto Eigene Bank Konto Eigene Bank E Cuenta Bancaria de Remesa Cuenta bancaria de la remesa F Compte bancaire de remise Compte bancaire de remise I Conto bancario di rimessa Conto bancario di rimessa JA 送金銀行口座 送金銀行口座 KO 수탁 은행 계정 수탁 은행 계정 PTB Conta Bancária para Remessa Conta Bancária para Remessa RU Счет в банке-корреспонденте Счет в банке-корреспонденте S Remitteringskonto Remitteringskonto TR Tahsile Verilen Banka Hesabı Tahsile Verilen Banka Hesabı US Remittance Bank Account Remittance Bank Account ZHS 汇款银行帐户 汇款银行帐户 11 90 :p_customer_name_id 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 AR اسم العميل اسم العميل D Kundenname Kundenname E Nombre del Cliente Nombre del cliente F Nom du client Nom du client I Nome cliente Nome cliente JA 顧客名 顧客名 KO 고객명 고객명 PTB Nome do Cliente Nome do Cliente RU Имя заказчика Имя заказчика S Kund Kund TR Müşteri Adı Müşteri Adı US Customer Name Customer Name ZHS 客户名称 客户名称 12 100 :p_customer_number 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 Kundennummer Kundennummer E Número de Cliente Número de cliente F Numéro du client Numéro du client I Numero cliente Numero cliente JA 顧客番号 顧客番号 KO 고객 번호 고객 번호 PTB Número do Cliente Nr. do Cliente RU Номер заказчика Номер заказчика S Kundnummer Kundnummer TR Müşteri Numarası Müşteri Numarası US Customer Number Customer Number ZHS 客户编号 客户编号 13 110 :p_note_status LOV Oracle AR_ARXNRREV_STATUS Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='AR_NOTE_STATUS' and lookup_code in ('RETURN','DELINQUENT','REPURCHASE') order by value,description AR موقف أوراق القبض موقف أوراق القبض D Status Wechselforderung Status Wechselforderung E Estado de Documento Posdatado Estado de Documento Posdatado F Statut effet à recevoir Statut effet à recevoir I Stato note conto clienti Stato delle note del conto clienti JA 受取手形ステータス 受取手形ステータス KO 받을 어음 상태 받을 어음 상태 PTB Informar Status das Contas a Receber Informar Status das Contas a Receber RU Статус векселя к получению Статус векселя к получению S Status på växelfordran Status på växelfordran TR Alacak Senedi Statüsü Alacak Senedi Statüsü US Note Receivable Status Note Receivable Status ZHS 应收票据状态 应收票据状态 14 120 :p_non_exchanged LOV Oracle AR_SRS_YES_NO Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by meaning select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'N' Y AR تقرير إشعارات غير متبادلة تقرير إشعارات غير متبادلة فقط D Nicht-Ersatzwechsel auswerten Nur Wechsel auswerten, die keine Ersatzwechsel sind E Notificar Letras No Intercambiadas Notificar Únicamente Letras No Intercambiadas F Editer effets à recevoir non échangés Editer uniquement les effets à recevoir non échangés I Rapporto per note non scambiate Rapporto solo per le note non scambiate JA 未換算手形レポート 未換算手形レポートのみ KO 교환되지 않은 어음 보고 교환되지 않은 어음만 보고 PTB Emitir Apenas Relatório de Observações Não-troca Emitir Apenas Relatório de Observações Não-troca RU Отчет о незаменяющих векселях Только отчет о незаменяющих векселях S Rapportera ej ändrade fordringar Rapportera bara fordringar som inte ändrats TR Kambiyo Senedi Olmayanları Raporla Sadece Kambiyo Senedi Olmayanları Raporlar US Report Non-Exchanged Notes Only Report Non-Exchanged Notes ZHS 报告未兑换的票据 仅报告未兑换的票据 :$flex$.ledger Ledger Operating Unit