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）限制的操作单元。 C6E085D46F3151A9E05362FB09050512 select decode (:P_SORT_BY, 'DUE DATE', null, 'INVOICE NUMBER', trx.trx_number, null) dcol_A, decode(:P_SORT_BY, 'DUE DATE', pays.due_date, 'INVOICE NUMBER', pays.due_date, null ) ddatecol_A, decode(:P_SORT_BY, 'DUE DATE', decode(:RP_SUMMARIZE, 'YES', null, trx.trx_number), null ) dcol_B, trx.invoice_currency_code currency_code, lc.meaning status, lc.lookup_code status_code, pmt.name method, decode(:RP_SUMMARIZE, 'YES', null, SUBSTRB(PARTY.PARTY_NAME,1,50)) cust_name, decode(:RP_SUMMARIZE, 'YES', null, cust.ACCOUNT_NUMBER) cust_num, decode(:RP_SUMMARIZE, 'YES', null, su.location) location, decode(:RP_SUMMARIZE, 'YES', null, trx.trx_number) inv_num, decode(:RP_SUMMARIZE, 'YES', null, trxtype.name) inv_type, decode(:RP_SUMMARIZE, 'YES', null, trx.trx_date) inv_date, pays.due_date due_date, decode(:RP_SUMMARIZE, 'YES', null, batch.name) batch, &LP_SUM_COLUMN amount_due, AR_ARXAPIPM_XMLP_PKG.D_SUM_AMOUNT_DUE_CURRFormula from ar_batches batch, ar_receipt_methods pmt, ar_receipt_classes class, ar_payment_schedules pays, ar_cash_receipt_history crh, ar_receivable_applications ra, ra_customer_trx trx, ra_cust_trx_types trxtype, HZ_CUST_ACCOUNTS cust, HZ_PARTIES PARTY, ar_lookups lc, HZ_CUST_site_uses su where trx.set_of_books_id = :P_SET_OF_BOOKS_ID and pays.selected_for_receipt_batch_id = batch.batch_id (+) and trx.customer_trx_id = pays.customer_trx_id and trx.receipt_method_id = pmt.receipt_method_id and class.receipt_class_id = pmt.receipt_class_id and class.creation_method_code in ('AUTOMATIC','BR') and trx.paying_customer_id = cust.CUST_ACCOUNT_ID(+) AND CUST.PARTY_ID = PARTY.PARTY_ID(+) and trx.paying_site_use_id = su.site_use_id (+) and trxtype.cust_trx_type_id = trx.cust_trx_type_id and pays.status = 'OP' and pays.payment_schedule_id = ra.applied_payment_schedule_id(+) and ra.confirmed_flag(+) = 'N' and ra.cash_receipt_id = crh.cash_receipt_id(+) and nvl(crh.batch_id, -2) = decode(crh.batch_id , null, -2, batch.batch_id) and nvl(batch.batch_applied_status, 'AVAILABLE_FOR_RECEIPT') = lc.lookup_code(+) and lc.lookup_type(+) = 'ARXAPIPM_BATCH_APPLIED_STATUS' &LP_STATUS &LP_INV_DATE &LP_DUE_DATE &LP_PMT_METHOD &LP_CUST_NAME &LP_CUST_NUM &LP_INV_NUM &LP_INV_TYPE &LP_CURRENCY &LP_GROUP_BY --order by 8, 9, 10, 11, 12, 14, 13, 16, 15 order by 4,5,6,7,1,2,3,8,9,10,11,12,14,13,16,15 Y AR ARXAPIPM_XML AR AR حركات بانتظار التجميع (بتنسيق XML) Imported from BI Publisher Description: حركات بانتظار التجميع Application: المقبوضات Source: حركات بانتظار التجميع (بتنسيق XML) Short Name: ARXAPIPM_XML DB package: AR_ARXAPIPM_XMLP_PKG D AR Transaktionen mit anstehender Konsolidierung Imported from BI Publisher Description: Transaktionen mit anstehender Konsolidierung Application: Debitoren Source: Transaktionen mit anstehender Konsolidierung (XML) Short Name: ARXAPIPM_XML DB package: AR_ARXAPIPM_XMLP_PKG E AR Transacciones en Espera de Consolidación Imported from BI Publisher Description: Transacciones en espera de consolidación Application: Receivables Source: Transacciones en Espera de Consolidación (XML) Short Name: ARXAPIPM_XML DB package: AR_ARXAPIPM_XMLP_PKG F AR Mouvements en attente de consolidation Imported from BI Publisher Description: Mouvements en attente de consolidation Application: Receivables Source: Mouvements en attente de consolidation (XML) Short Name: ARXAPIPM_XML DB package: AR_ARXAPIPM_XMLP_PKG I AR Transazioni in attesa di consolidamento Imported from BI Publisher Description: Transazioni in attesa di consolidamento Application: Receivables Source: Transazioni in attesa di consolidamento (XML) Short Name: ARXAPIPM_XML DB package: AR_ARXAPIPM_XMLP_PKG JA AR 連結を待機中の取引 Imported from BI Publisher Description: 連結を待機中の取引 Application: Receivables Source: 連結を待機中の取引(XML) Short Name: ARXAPIPM_XML DB package: AR_ARXAPIPM_XMLP_PKG KO AR 연결 대기 거래 Imported from BI Publisher Description: 연결 대기 거래 Application: Receivables Source: 연결 대기 거래(XML) Short Name: ARXAPIPM_XML DB package: AR_ARXAPIPM_XMLP_PKG PTB AR Transações Aguardando Consolidação Imported from BI Publisher Description: Transações Aguardando Consolidação Application: Receivables Source: Transações Aguardando Consolidação (XML) Short Name: ARXAPIPM_XML DB package: AR_ARXAPIPM_XMLP_PKG RU AR Транзакции, ожидающие консолидации Imported from BI Publisher Description: Транзакции, ожидающие консолидации Application: Дебиторы Source: Транзакции, ожидающие консолидации (XML) Short Name: ARXAPIPM_XML DB package: AR_ARXAPIPM_XMLP_PKG S AR Transaktioner som väntar på att konsolideras Imported from BI Publisher Description: Transaktioner som väntar på att konsolideras Application: Receivables Source: Transaktioner som väntar på att konsolideras (XML) Short Name: ARXAPIPM_XML DB package: AR_ARXAPIPM_XMLP_PKG TR AR Konsolidasyon Bekleyen İşlemler Imported from BI Publisher Description: Konsolidasyon Bekleyen İşlemler Application: Alacaklar Muhasebesi Source: Konsolidasyon Bekleyen İşlemler (XML) Short Name: ARXAPIPM_XML DB package: AR_ARXAPIPM_XMLP_PKG US AR Transactions Awaiting Consolidation Imported from BI Publisher Description: Transactions Awaiting Consolidation Application: Receivables Source: Transactions Awaiting Consolidation (XML) Short Name: ARXAPIPM_XML DB package: AR_ARXAPIPM_XMLP_PKG ZHS AR 等待合并的事务处理 Imported from BI Publisher Description: 等待合并的事务处理 Application: 应收帐款 Source: 等待合并的事务处理 (XML) Short Name: ARXAPIPM_XML DB package: AR_ARXAPIPM_XMLP_PKG BI Publisher &lp_currency &lp_cust_name &lp_cust_num &lp_due_date &lp_group_by &lp_inv_date &lp_inv_num &lp_inv_type &lp_pmt_method &lp_status &lp_sum_column :lp_currency :lp_cust_name :lp_cust_num :lp_due_date :lp_group_by :lp_inv_date :lp_inv_num :lp_inv_type :lp_pmt_method :lp_status :lp_sum_column :operating_unit :p_conc_request_id :p_currency :p_cust_name :p_cust_number :p_due_date_high :p_due_date_high_t :p_due_date_low :p_due_date_low_t :p_inv_date_high :p_inv_date_high_t :p_inv_date_low :p_inv_date_low_t :p_inv_num_high :p_inv_num_low :p_inv_type :p_pmt_mtd :p_set_of_books_id :p_sort_by :p_status :p_summarize :rp_company_name :rp_data_found :rp_functional_currency :rp_report_name :rp_sub_title1 :rp_sub_title2 :rp_summarize 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 AR معرف دفتر الأستاذ معرف دفتر الأستاذ D Buchkennung Buchkennung E Id Libro Mayor Identificador de libro mayor F ID livre ID livre I Id libro contabile Id del libro contabile JA 元帳ID 元帳ID KO 원장 ID 원장 ID PTB Id do Razão Id do Razão RU Идентификатор книги Идентификатор книги S Huvudboks-id Huvudboks-id TR Defter No Defter No US Ledger Id Ledger Id 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_sort_by LOV Oracle AR_ARXAPIPM_SORT_BY Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='SORT_BY_ARXAPIPM' and enabled_flag='Y' order by meaning AR ترتيب حسب فرز حسب D Sortieren nach Sortieren nach E Ordenar por Ordenar por F Tri par Tri par I Ordina per Ordina per JA ソート・キー ソート・キー KO 정렬 기준 정렬 기준 PTB Ordenar Por Classificar Por RU Сортировка Сортировка S Ordna per Sortera efter TR Sıralama Bazı Sıralama Bazı US Order By Sort By ZHS 排序依据 排序依据 4 20 :p_summarize 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 AR إجمالي إجمالي D Zusammenfassen Zusammenfassen E Resumir Resumir F Synthèse Synthèse I Sintetico Sintetico JA 要約処理 要約処理 KO 요약 요약 PTB Sumariar Sumariar RU Сводка Сводка S Summera Summera TR Özetle Özetle US Summarize Summarize ZHS 汇总 汇总 5 30 :p_status LOV Oracle AR_IPM_BATCH_APPLIED_STATUS Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='ARXAPIPM_BATCH_APPLIED_STATUS' and enabled_flag='Y' order by meaning AR الموقف الموقف E Estado Estado F Statut Statut I Stato Stato JA ステータス ステータス KO 상태 상태 RU Статус Статус TR Statü Statü US Status Status ZHS 状态 状态 6 40 :p_inv_date_low Date AR تاريخ الفاتورة من تاريخ الفاتورة من D Von Rechnungsdatum Von Rechnungsdatum E De Fecha de Factura De Fecha de Factura F Date de facture - Du Date de facture - Du I Data fattura (min) Data fattura (min) JA 請求日:自 請求日:自 KO 송장 일자 하한 송장 일자 하한 PTB Data de NFF - Inferior Data de NFF - Inferior RU Дата счета-фактуры с Дата счета-фактуры с S Från fakturadatum Från fakturadatum TR Fatura Tarihi Alt Değeri Fatura Tarihi Alt Değeri US Invoice Date Low Invoice Date Low ZHS 发票日期下限 发票日期下限 7 50 :p_inv_date_high Date AR تاريخ الفاتورة إلى تاريخ الفاتورة إلى D Bis Rechnungsdatum Bis Rechnungsdatum E A Fecha de Factura A Fecha de Factura F Date de facture - Au Date de facture - Au I Data fattura (max) Data fattura (max) JA 請求日:至 請求日:至 KO 송장 일자 상한 송장 일자 상한 PTB Data de NFF - Superior Data de NFF - Superior RU Дата счета-фактуры по Дата счета-фактуры по S Till fakturadatum Till fakturadatum TR Fatura Tarihi Üst Değeri Fatura Tarihi Üst Değeri US Invoice Date High Invoice Date High ZHS 发票日期上限 发票日期上限 8 60 :p_due_date_low Date AR تاريخ استحقاق من تاريخ استحقاق من D Von Fälligkeitsdatum Von Fälligkeitsdatum E De Fecha de Vencimiento De Fecha de Vencimiento F Date d'échéance - Du Date d'échéance - Du I Data scadenza (min) Data scadenza (min) JA 支払期日:自 支払期日:自 KO 만기 일자 하한 만기 일자 하한 PTB Data de Vencimento - Inferior Data de Vencimento - Inferior RU Срок с Срок с S Från förfallodatum Från förfallodatum TR Vade Tarihi Alt Değeri Vade Tarihi Alt Değeri US Due Date Low Due Date Low ZHS 到期日下限 到期日下限 9 70 :p_due_date_high Date AR تاريخ استحقاق إلى تاريخ استحقاق إلى D Bis Fälligkeitsdatum Bis Fälligkeitsdatum E A Fecha de Vencimiento A Fecha de Vencimiento F Date d'échéance - Au Date d'échéance - Au I Data scadenza (max) Data scadenza (max) JA 支払期日:至 支払期日:至 KO 만기 일자 상한 만기 일자 상한 PTB Data de Vencimento - Superior Data de Vencimento - Superior RU Срок по Срок по S Till förfallodatum Till förfallodatum TR Vade Tarihi Üst Değeri Vade Tarihi Üst Değeri US Due Date High Due Date High ZHS 到期日上限 到期日上限 10 80 :p_pmt_mtd LOV Oracle AR_ARXAPIPM_RECEIPT_METHOD Y select rmt.name id, rmt.name value, null description from ar_receipt_methods rmt,ar_receipt_classes class where sysdate between rmt.start_date and nvl(rmt.end_date,sysdate+1) and rmt.receipt_class_id=class.receipt_class_id and class.creation_method_code in ('AUTOMATIC','BR') order by value,description AR طريقة السداد طريقة السداد D Zahlungsart Zahlungsart E Método de Pago Método de Pago F Mode de règlement Mode de règlement I Metodo pagamento Metodo di pagamento JA 支払方法 支払方法 KO 결제 방법 결제 방법 PTB Método de Pagamento Método de Pagamento RU Метод платежа Метод платежа S Betalningssätt Betalningssätt TR Ödeme Yöntemi Ödeme Yöntemi US Payment Method Payment Method ZHS 付款方法 付款方法 11 90 :p_cust_name 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_cust_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_inv_num_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 AR رقم فاتورة من رقم فاتورة من D Von Rechnungsnummer Von Rechnungsnummer E De Número de Factura De Número de Factura F Numéro de facture - De Numéro de facture - De I Numero fattura (min) Valore minimo per il numero di fattura JA 請求書番号:自 請求書番号:自 KO 송장 번호 하한 송장 번호 하한 PTB Número de NFF - Inferior Número de NFF - Inferior RU Номер счета-фактуры с Номер счета-фактуры с S Från fakturanummer Från fakturanummer TR Fatura Numarası Alt Değeri Fatura Numarası Alt Değeri US Invoice Number Low Invoice Number Low ZHS 发票编号下限 发票编号下限 14 120 :p_inv_num_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 AR رقم فاتورة إلى رقم فاتورة إلى D Bis Rechnungsnummer Bis Rechnungsnummer E A Número de Factura A Número de Factura F Numéro de facture - A Numéro de facture - A I Numero fattura (max) Valore massimo per il numero di fattura JA 請求書番号:至 請求書番号:至 KO 송장 번호 상한 송장 번호 상한 PTB Número de NFF - Superior Número de NFF - Superior RU Номер счета-фактуры по Номер счета-фактуры по S Till fakturanummer Till fakturanummer TR Fatura Numarası Üst Değeri Fatura Numarası Üst Değeri US Invoice Number High Invoice Number High ZHS 发票编号上限 发票编号上限 15 130 :p_inv_type LOV Oracle AR_INVOICE_TYPE Y select name id, name value, null description from ra_cust_trx_types order by name AR نوع الفاتورة نوع الفاتورة D Rechnungsart Rechnungsart E Tipo de Factura Tipo de Factura F Type de facture Type de facture I Tipo fattura Tipo di fattura JA 請求書タイプ 請求書タイプ KO 송장 유형 송장 유형 PTB Tipo de NFF Tipo de NFF RU Тип счета-фактуры Тип счета-фактуры S Fakturatyp Fakturatyp TR Fatura Tipi Fatura Tipi US Invoice Type Invoice Type ZHS 发票类型 发票类型 16 140 :p_currency 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 Divisa Divisa F Devise Devise I Divisa Divisa JA 通貨 通貨 KO 통화 통화 PTB Moeda Moeda RU Валюта Валюта S Valuta Valuta TR Para Birimi Para Birimi US Currency Currency ZHS 币种 币种