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）限制的操作单元。 C6E085D4723A51A9E05362FB09050512 SELECT V.vendor_name C_VENDOR_NAME, upper(V.vendor_name) C_SORT_VENDOR_NAME, V.segment1 C_VENDOR_NUMBER, VS.vendor_site_code C_VENDOR_SITE_CODE, decode(VS.address_line1, null,'', VS.address_line1||',') C_ADDRESS_LINE1, decode(VS.city, null,'', VS.city||',') C_CITY, decode(VS.state, null,VS.province||',', VS.state||',') C_STATE, VS.zip C_ZIP, C.bank_account_name C_BANK_ACCOUNT_NAME, C.check_number C_CHECK_NUMBER, C.check_date C_CHECK_DATE, C.amount C_CHECK_AMOUNT, C.currency_code C_CURRENCY_CODE, SUM(DECODE(I.payment_currency_code, :C_BASE_CURRENCY_CODE, IP.amount, IP.payment_base_amount)) C_BASE_AMOUNT, C.void_date C_VOID_DATE, C.check_id C_CHECK_ID FROM ap_checks C, ap_invoice_payments IP, ap_invoices I, po_vendor_sites VS, po_vendors V WHERE V.vendor_id = DECODE(:P_VENDOR_ID, null, V.vendor_id, :P_VENDOR_ID) AND NVL(V.vendor_type_lookup_code, 'x') = DECODE(:P_VENDOR_TYPE, null, NVL(V.vendor_type_lookup_code, 'x'), :P_VENDOR_TYPE) AND VS.vendor_id = V.vendor_id AND C.vendor_site_id = VS.vendor_site_id AND IP.invoice_id = I.invoice_id AND C.check_id = IP.check_id AND C.check_date BETWEEN NVL(:P_START_PAYMENT_DATE, sysdate - 9000) AND NVL(:P_END_PAYMENT_DATE, sysdate + 9000) GROUP BY C.check_id, V.vendor_name, V.segment1, VS.vendor_site_code, VS.address_line1, VS.city, VS.state, VS.province, VS.zip, C.bank_account_name, C.check_number, C.check_date, C.amount, C.currency_code, C.void_date /*ORDER BY DECODE(:P_VENDOR_ID, null, UPPER(V.vendor_name), V.vendor_name), VS.vendor_site_code, &P_ORDER_BY*/ ORDER BY DECODE(:P_VENDOR_ID, null, UPPER(V.vendor_name), V.vendor_name), VS.vendor_site_code, V.segment1, decode(VS.address_line1, null,'',VS.address_line1||','), decode(VS.city,null,'',VS.city||','), decode(VS.state,null,VS.province||',',VS.state||','), VS.zip, &P_ORDER_BY Y SQLAP APXPPHIS_XML AR AP تاريخ مدفوعات المورِّد (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: المدفوعات المقدمة للمورد خلال فترة زمنية معطاة Application: المدفوعات Source: تاريخ مدفوعات المورِّد (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: APXPPHIS_XML DB package: AP_APXPPHIS_XMLP_PKG D AP Lieferanten - Zahlungshistorie- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Alle innerhalb eines bestimmten Zeitraums an einen Lieferanten geleisteten Zahlungen Application: Kreditoren Source: Lieferanten - Zahlungshistorie (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: APXPPHIS_XML DB package: AP_APXPPHIS_XMLP_PKG E AP Historial de Pagos a Proveedores: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Pagos Realizados a un Proveedor en un Período de Tiempo Determinado Application: Payables Source: Historial de Pagos a Proveedores (XML) : No Admitido, Reservado para Uso Futuro Short Name: APXPPHIS_XML DB package: AP_APXPPHIS_XMLP_PKG F AP Historique des règlements à un fournisseur- Non pris en charge : réservé pour une utilisation future Imported from BI Publisher Description: Règlements effectués à un fournisseur sur une période donnée Application: Payables Source: Historique des règlements à un fournisseur (XML) - Non pris en charge : réservé pour une utilisation future Short Name: APXPPHIS_XML DB package: AP_APXPPHIS_XMLP_PKG I AP Cronologia pagamenti fornitore- non supportato: riservato per usi futuri Imported from BI Publisher Description: Pagamenti a un fornitore in un periodo di tempo specifico Application: Payables Source: Cronologia pagamenti fornitore (XML) - non supportato: riservato per usi futuri Short Name: APXPPHIS_XML DB package: AP_APXPPHIS_XMLP_PKG JA AP 仕入先支払履歴- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: 与えられた期間を超えて仕入先に支払が作成されました Application: Payables Source: 仕入先支払履歴(XML) - 未サポート: 将来の使用のために予約 Short Name: APXPPHIS_XML DB package: AP_APXPPHIS_XMLP_PKG KO AP 공급자 지급 내역- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 일정기간에 걸쳐 이루어진 공급자 지급 Application: Payables Source: 공급자 지급 내역(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: APXPPHIS_XML DB package: AP_APXPPHIS_XMLP_PKG PTB AP Histórico de Pagamento do Fornecedor- Não Suportado: Reservado Para Uso Futuro Imported from BI Publisher Description: Pagamentos feitos a um fornecedor em um determinado período Application: Payables Source: Histórico de Pagamento do Fornecedor (XML) - Não Suportado: Reservado Para Uso Futuro Short Name: APXPPHIS_XML DB package: AP_APXPPHIS_XMLP_PKG RU AP История платежей поставщика- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Платежи поставщику в течение указанного временного периода Application: Кредиторы Source: История платежей поставщика (XML) - не поддерживается: зарезервировано для будущего использования Short Name: APXPPHIS_XML DB package: AP_APXPPHIS_XMLP_PKG S AP Betalningshistorik- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Betalningar till en leverantör under en viss tidsperiod Application: Payables Source: Leverantörer: Betalningshistorik (XML) - Stöds inte: Reserverad för framtida bruk Short Name: APXPPHIS_XML DB package: AP_APXPPHIS_XMLP_PKG TR AP Tedarikçi Ödemesi Tarihçesi- Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Imported from BI Publisher Description: Belirtilen süre içinde bir tedarikçiye yapılan ödemeler. Application: Borçlar Muhasebesi Source: Tedarikçi Ödemesi Tarihçesi (XML) - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Short Name: APXPPHIS_XML DB package: AP_APXPPHIS_XMLP_PKG US AP Supplier Payment History- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Payments made to a supplier over a given time period Application: Payables Source: Supplier Payment History (XML) - Not Supported: Reserved For Future Use Short Name: APXPPHIS_XML DB package: AP_APXPPHIS_XMLP_PKG ZHS AP 供应商付款历史记录- 不支持：已保留供将来使用 Imported from BI Publisher Description: 给定时期向供应商所做的付款 Application: 应付帐款 Source: 供应商付款历史记录 (XML) - 不支持：已保留供将来使用 Short Name: APXPPHIS_XML DB package: AP_APXPPHIS_XMLP_PKG BI Publisher &p_order_by :c_base_currency_code :c_base_description :c_base_min_acct_unit :c_base_precision :c_chart_of_accounts_id :c_company_name_header :c_nls_all :c_nls_end_of_report :c_nls_no :c_nls_no_data_exists :c_nls_vendor_type :c_nls_yes :c_report_run_time :c_report_start_date :lp_end_payment_date :lp_start_payment_date :operating_unit :p_conc_request_id :p_debug_switch :p_end_payment_date :p_flexdata :p_min_precision :p_order_by :p_print_detail_flag :p_set_of_books_id :p_start_payment_date :p_vendor_id :p_vendor_type 1 -20 :p_set_of_books_id Char fnd_profile.value('GL_SET_OF_BKS_ID') 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_vendor_type LOV Oracle AP_SRS_VENDOR_TYPE Y select lookup_code id, displayed_field value, null description from po_lookup_codes where nvl(inactive_date,sysdate+1)>sysdate and lookup_type='VENDOR TYPE' order by value,description AR نوع المورد (تخطي للكل) نوع المورد D Lieferantenart Lieferantenart E Tipo de Proveedor (Omitir=Todos) Tipo de Proveedor F Type de fournisseur (Sauter si Tous) Type de fournisseur I Tipo fornitore (ignora Tuttol) Tipo di fornitore JA 仕入先タイプ (全て処理対象外) 仕入先タイプ KO 공급자 유형 (전부 생략) 공급자 유형 PTB Tipo de Fornecedor (saltar Todos) Tipo de Fornecedor RU Тип поставщика (пропуск = Все) Тип поставщика S Lev.typ (hoppa över vid Alla) Leverantörstyp TR Tedarikçi Tipi (Tümü ise atlayın) Tedarikçi Tipi US Supplier Type (skip for All) Supplier Type ZHS 供应商类型（忽略则为全部） 供应商类型 4 20 :p_vendor_id LOV Oracle AP_SRS_VENDOR_NAME Y select vendor_id id, vendor_name value, null description from po_vendors order by value,description AR اسم المورد ( تخطي للكل) معرف المورد لاسم المورد المعطى D Lieferant Lieferantenkennung für einen bestimmten Lieferantennamen E Nombre del Proveedor (Omitir=Todos) Id Proveedor para Nombre de Proveedor especificado F Nom du fournisseur (Sauter si Tous) ID fournisseur pour nom fournisseur donné I Nome fornitore (ignora Tutto) ID del fornitore per nome del fornitore specificato JA 仕入先名 (全て処理対象外) 与えられた仕入先名の仕入先ID KO 공급자명 (전부 생략) 주어진 공급자명에 대한 공급자 ID PTB Nome do Fornecedor (saltar Todos) ID do Fornecedor para o Nome do Fornecedor dado RU Имя поставщика (пропуск = Все) Идент. поставщика, соответствующий данному имени поставщика S Leverantörsnamn (hoppa över vid Alla) Leverantörs-id för ett givet leverantörsnamn TR Tedarikçi Adı (Tümü ise atlayın) Belirtilen Tedarikçi Adı için Tedarikçi No US Supplier Name (skip for All) Supplier ID for given Supplier Name ZHS 供应商名称（忽略则为全部） 给定供应商名称的供应商标识 5 30 :p_start_payment_date Date AR تاريخ بداية السداد تاريخ بداية مدى السداد D Von Zahlungsdatum Von Zahlungsdatum E De Fecha de Pago Inicio de Rango de Fechas de Pago F Date début règlement Début fourchette dates règlement I Data pagamento iniziale Inizio dell'intervallo delle date di pagamento JA 開始支払日 開始支払日 KO 지급 시작 일자 시작 지급일자 범위 PTB Data de Pgto. Inicial Início da Faixa da Data de Pagamento RU Начальная дата платежа Начало диапазона дат платежа S Startdatum för betalning Startdatum betalningsintervall TR İlk Ödeme Tarihi Ödeme Tarihi Aralığı Başlangıcı US Start Payment Date Begin of Payment Date Range ZHS 起始付款日期 起始付款日期范围 6 40 :p_end_payment_date Date AR تاريخ نهاية السداد تاريخ نهاية مدى السداد D Bis Zahlungsdatum Bis Zahlungsdatum E A Fecha de Pago Finalización de Rango de Fechas de Pago F Date fin règlement Fin fourchette dates règlement I Data pagamento finale Fine dell'intervallo delle date di pagamento JA 最終支払日 支払日範囲:至 KO 지급 종료 일자 종료 지급일자 범위 PTB Data de Pgto. Final Final da Faixa da Data de Pagamento RU Конечная дата платежа Окончание диапазона дат платежа S Slutbetalningsdatum Slutdatum betalningsintervall TR Son Ödeme Tarihi Ödeme Tarihi Aralığı Sonu US End Payment Date End of Payment Date Range ZHS 终止付款日期 终止付款日期范围 7 50 :p_print_detail_flag LOV Oracle AP_SRS_YES_NO_MAND Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'N' Y AR تفاصيل الفاتورة يتضمن تفاصيل الفاتورة للمدفوعات D Rechnungsdetails Mit Rechnungsdetails für Zahlungen E Detalle de Factura Incluir detalle de la factura de pagos F Détail facture Inclure détails facture pour règlements I Dettaglio fattura Include i dettagli della fattura per pagamenti JA 請求書詳細 支払用請求書詳細を含む KO 송장 상세내역 지급에 대한 송장 상세내역 포함 PTB Detalhe da NFF Incluir detalhe da NFF para pagamentos RU Сведения о счете-фактуре Включить сведения о счете-фактуре для платежей S Fakturadetalj Inkludera fakturainformation vid bet TR Fatura Detayı Ödemeler için fatura detaylarını dahil eder US Invoice Detail Include invoice detail for payments ZHS 发票明细 包括付款发票明细 8 60 :p_order_by LOV Oracle AP_SRS_PAYMENT_HISTORY_ORDER Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where lookup_type='PAYMENT_HISTORY_ORDER_BY' order by value,description select displayed_field from ap_lookup_codes where lookup_type = 'PAYMENT_HISTORY_ORDER_BY' and lookup_code = 'C.CHECK_DATE' Y AR ترتيب بواسطة الخيار ترتيب بواسطة الخيار D Sortieren nach Sortieren nach E Opción Ordenar por Opción Ordenar por F Option de tri Option de tri I Opzione Ordina per Opzione Ordina per JA オプションでソート オプションでソート KO 옵션별 정렬 옵션별 정렬 PTB Ordenar por Opção Ordenar por Opção RU Параметр сортировки Параметр сортировки S Sorteringsalternativ Sorteringsalternativ TR Sıralama Bazı Seçeneği Sıralama Bazı Seçeneği US Order By Option Order By Option ZHS 按选项排序 按选项排序