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）限制的操作单元。 C6E085D4723651A9E05362FB09050512 SELECT upper(ALC.DISPLAYED_FIELD) C_PAYMENT_METHOD, APS.DUE_DATE C_DUE_DATE, decode(:h_sort_by_alternate, 'Y', PV.VENDOR_NAME_ALT, 'N', PV.VENDOR_NAME) C_SUPPLIER_NAME, decode(:h_sort_by_alternate, 'Y', PVS.VENDOR_SITE_CODE_ALT, 'N', PVS.VENDOR_SITE_CODE) C_SUPPLIER_SITE, PV.VENDOR_NAME C_SUPPLIER_NAME_DISP, PVS.VENDOR_SITE_CODE C_SUPPLIER_SITE_CODE_DISP, AI.INVOICE_NUM C_INVOICE_NUM, AI.INVOICE_DATE C_INVOICE_DATE, APS.GROSS_AMOUNT C_INVOICE_AMOUNT, APS.AMOUNT_REMAINING C_SCHEDULED_AMOUNT FROM AP_LOOKUP_CODES ALC, AP_PAYMENT_SCHEDULES APS, AP_INVOICES AI, PO_VENDORS PV, PO_VENDOR_SITES PVS WHERE APS.DUE_DATE <= :p_end_due_date and nvl(APS.HOLD_FLAG,'N') <> 'Y' and APS.PAYMENT_STATUS_FLAG IN ('N','P') and AI.PAYMENT_CURRENCY_CODE = :p_payment_currency and (ALC.LOOKUP_CODE = :p_payment_method or :p_payment_method is null) and ALC.LOOKUP_TYPE = 'PAYMENT METHOD' and ALC.LOOKUP_CODE = APS.PAYMENT_METHOD_LOOKUP_CODE and (AI.PAY_GROUP_LOOKUP_CODE = :p_pay_group or :p_pay_group is null) and ((APS.PAYMENT_PRIORITY between :p_priority_range_low and :p_priority_range_high) or (:p_priority_range_low is null and :p_priority_range_high is null)) and (AI.VENDOR_ID = :p_supplier_name or :p_supplier_name is null) and APS.INVOiCE_ID = AI.INVOICE_ID and PV.VENDOR_ID = AI.VENDOR_ID and PVS.VENDOR_SITE_ID = AI.VENDOR_SITE_ID and AI.CANCELLED_DATE is NULL and AP_INVOICES_PKG.GET_APPROVAL_STATUS(AI.INVOICE_ID, AI.INVOICE_AMOUNT, AI.PAYMENT_STATUS_FLAG, AI.INVOICE_TYPE_LOOKUP_CODE) IN ('APPROVED', 'UNPAID') ORDER BY C_PAYMENT_METHOD,C_DUE_DATE,C_SUPPLIER_NAME,C_SUPPLIER_SITE,C_SUPPLIER_NAME_DISP,C_SUPPLIER_SITE_CODE_DISP,C_INVOICE_NUM SQLAP APXPAYSC_XML AR AP تقرير جدول السداد (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: تقرير جدول السداد الياباني Application: المدفوعات Source: تقرير جدول السداد (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: APXPAYSC_XML DB package: AP_APXPAYSC_XMLP_PKG D AP Zahlungsplan- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Japan - Zahlungspläne Application: Kreditoren Source: Zahlungsplan (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: APXPAYSC_XML DB package: AP_APXPAYSC_XMLP_PKG E AP Informe Programa de Pago: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Japón - Informe Calendario de Pagos Application: Payables Source: Informe Programa de Pago (XML): No Admitido, Reservado para Uso Futuro Short Name: APXPAYSC_XML DB package: AP_APXPAYSC_XMLP_PKG F AP Etat des échéanciers de règlement- Non pris en charge : réservé pour une utilisation future Imported from BI Publisher Description: Etat des échéanciers de règlement (Japon) Application: Payables Source: Etat des échéanciers de règlement (XML) - Non pris en charge : réservé pour une utilisation future Short Name: APXPAYSC_XML DB package: AP_APXPAYSC_XMLP_PKG I AP Rapporto Programmi pagamenti- non supportato: riservato per usi futuri Imported from BI Publisher Description: Rapporto Programma di pagamenti giapponese Application: Payables Source: Rapporto Programmi pagamenti (XML) - non supportato: riservato per usi futuri Short Name: APXPAYSC_XML DB package: AP_APXPAYSC_XMLP_PKG JA AP 支払予定レポート- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: 支払予定レポート (日本) Application: Payables Source: 支払予定レポート(XML) - 未サポート: 将来の使用のために予約 Short Name: APXPAYSC_XML DB package: AP_APXPAYSC_XMLP_PKG KO AP 지급 스케줄 보고서- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 일본 지급 스케줄 보고서 Application: Payables Source: 지급 스케줄 보고서(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: APXPAYSC_XML DB package: AP_APXPAYSC_XMLP_PKG PTB AP Relatório de Cronograma de Pagamentos- Não Suportado: Reservado Para Uso Futuro Imported from BI Publisher Description: Relatório de Programação do Pagamento - Japão Application: Payables Source: Relatório de Cronograma de Pagamentos (XML) - Não Suportado: Reservado Para Uso Futuro Short Name: APXPAYSC_XML DB package: AP_APXPAYSC_XMLP_PKG RU AP Отчет о графике платежей- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Отчет о графике платежей (Япония) Application: Кредиторы Source: Отчет о графике платежей (XML) - не поддерживается: зарезервировано для будущего использования Short Name: APXPAYSC_XML DB package: AP_APXPAYSC_XMLP_PKG S AP Betalningsplan - rapport- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Japansk betalningsplan - rapport Application: Payables Source: Betalningsplan - rapport (XML) - Stöds inte: Reserverad för framtida bruk Short Name: APXPAYSC_XML DB package: AP_APXPAYSC_XMLP_PKG TR AP Ödeme Planı Raporu- Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Imported from BI Publisher Description: Japonya Ödeme Çizelgesi Raporu Application: Borçlar Muhasebesi Source: Ödeme Planı Raporu (XML) - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Short Name: APXPAYSC_XML DB package: AP_APXPAYSC_XMLP_PKG US AP Payment Schedule Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Japanese Payment Schedule Report Application: Payables Source: Payment Schedule Report (XML) - Not Supported: Reserved For Future Use Short Name: APXPAYSC_XML DB package: AP_APXPAYSC_XMLP_PKG ZHS AP 付款分摊计划报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 日本付款分摊计划报表 Application: 应付帐款 Source: 付款分摊计划报表 (XML) - 不支持：已保留供将来使用 Short Name: APXPAYSC_XML DB package: AP_APXPAYSC_XMLP_PKG BI Publisher :applications_template_report :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_na :c_nls_no :c_nls_no_data_exists :c_nls_void :c_nls_yes :c_report_start_date :cp_end_due_date :h_chart_of_accounts_id :h_currency :h_currency_precision :h_dateformat :h_set_of_books_name :h_sort_by_alternate :operating_unit :p_conc_request_id :p_debug_switch :p_end_due_date :p_flexdata :p_min_precision :p_pay_group :p_payment_currency :p_payment_method :p_priority_range_high :p_priority_range_low :p_set_of_books_id :p_supplier_name :p_trace_switch 1 -20 :p_set_of_books_id Char fnd_profile.value('GL_SET_OF_BKS_ID') Y 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_payment_currency 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 Y AR عملة السداد عملة السداد D Zahlungswährung Zahlungswährung E Divisa de Pago Divisa de Pago F Devise de règlement Devise de règlement I Divisa pagamento Divisa del pagamento JA 支払通貨 支払通貨 KO 결제 통화 결제 통화 PTB Moeda do Pagto. Moeda do Pagto. RU Валюта платежа Валюта платежа S Betalningsvaluta Betalningsvaluta TR Ödeme Para Birimi Ödeme Para Birimi US Payment Currency Payment Currency ZHS 付款币种 付款币种 4 20 :p_end_due_date Date Y AR تاريخ نهاية الاستحقاق تاريخ نهاية الاستحقاق D Bis Fälligkeitsdatum Bis Fälligkeitsdatum E Fecha de Vencimiento Final Fecha de Vencimiento Final F Date échéance fin Date échéance fin I Data scadenza finale Data scadenza finale JA 最終期日 最終期日 KO 만기 종료 일자 만기 종료 일자 PTB Data de Vencimento Final Data de Vencimento Final RU Конечный срок Конечный срок S Sista förfallodatum Sista förfallodatum TR Son Vade Tarihi Son Vade Tarihi US End Due Date End Due Date ZHS 终止到期日 终止到期日 5 30 :p_payment_method LOV Oracle AP_SRS_PAYMENT_METHOD Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where lookup_type='PAYMENT METHOD' 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 di 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 付款方法 付款方法 6 40 :p_pay_group LOV Oracle AP_SRS_PAYGROUP Y select lookup_code id, lookup_code value, null description from po_lookup_codes where nvl(inactive_date,sysdate+1)>sysdate and lookup_type='PAY GROUP' order by value,description AR مجموعة السداد مجموعة الدفع D Zahlungsgruppe Zahlungsgruppe E Grupo de Pago Grupo de Pago F Classe de règlements Classe de règlements I Gruppo di pagamenti Gruppo di pagamenti JA 支払グループ 支払グループ KO 지급 그룹 지급 그룹 PTB Grupo de Pagtos. Grupo de Pagtos. RU Платежная группа Платежная группа S Betalningsgrupp Betalningsgrupp TR Ödeme Grubu Ödeme Grubu US Pay Group Pay Group ZHS 支付组 支付组 7 50 :p_priority_range_low Number AR مدى الأولوية منخفض مدى الأولوية منخفض D Von Priorität Von Priorität E De Prioridad De Prioridad F Fourchette priorités - De Fourchette priorités - De I Valore minimo intervallo priorità Valore minimo dell'intervallo delle priorità JA 優先度範囲:自 優先度範囲:自 KO 우선순위 범위 하한 우선순위 범위 하한 PTB Faixa de Prioridade - Inferior Faixa de Prioridade - Inferior RU Диапазон приоритетов с Диапазон приоритетов с S Lågt prioritetsintervall Lågt prioritetsintervall TR Öncelik Aralığı - Alt Değer Öncelik Aralığı - Alt Değer US Priority Range Low Priority Range Low ZHS 下限优先级 下限优先级 8 60 :p_priority_range_high Number AR مدى الأولوية عالي مدى الأولوية عالي D Bis Priorität Bis Priorität E A Prioridad A Prioridad F Fourchette priorités - A Fourchette priorités - A I Valore massimo intervallo priorità Valore massimo dell'intervallo delle priorità JA 優先度範囲:至 優先度範囲:至 KO 우선순위 범위 상한 우선순위 범위 상한 PTB Faixa de Prioridade - Superior Faixa de Prioridade - Superior RU Диапазон приоритетов по Диапазон приоритетов по S Högt prioritetsintervall Högt prioritetsintervall TR Öncelik Aralığı - Üst Değer Öncelik Aralığı - Üst Değer US Priority Range High Priority Range High ZHS 上限优先级 上限优先级 9 70 :p_supplier_name 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 Lieferantenname Lieferantenname E Nombre de Proveedor Nombre de Proveedor F Nom du fournisseur Nom du fournisseur I Nome fornitore Nome del fornitore JA 仕入先名 仕入先名 KO 공급자명 공급자명 PTB Nome do Fornecedor Nome do Fornecedor RU Имя поставщика Имя поставщика S Leverantör Leverantör TR Tedarikçi Adı Tedarikçi Adı US Supplier Name Supplier Name ZHS 供应商名称 供应商名称