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）限制的操作单元。 C6E085D4722751A9E05362FB09050512Y SELECT substr(vendor_name,1,60) C_VENDOR_NAME, V.segment1 C_VENDOR_NUM, substr(vendor_site_code,1,20) C_VENDOR_SITE_CODE, substr(invoice_num,1,32) C_INVOICE_NUM, substr(description,1,60) C_DESCRIPTION, DECODE(S.ALWAYS_TAKE_DISC_FLAG, 'Y', P.DUE_DATE, DECODE(SIGN(:c_test_date --8266843 -nvl(TO_DATE(P.DISCOUNT_DATE,'DD/MM/YYYY'), --8266843 to_date('31/12/2999','DD/MM/YYYY'))), -1, P.DISCOUNT_DATE, DECODE(SIGN(:c_test_date -nvl(TO_DATE(P.SECOND_DISCOUNT_DATE,'DD/MM/YYYY'), to_date('31/12/2999','DD/MM/YYYY'))), -1, P.SECOND_DISCOUNT_DATE, DECODE(SIGN(:c_test_date -nvl(TO_DATE(P.THIRD_DISCOUNT_DATE,'DD/MM/YYYY'), to_date('31/12/2999','DD/MM/YYYY'))), -1, P.THIRD_DISCOUNT_DATE, P.DUE_DATE)))) C_DISCOUNT_DATE, due_date C_DUE_DATE, nvl(invoice_amount,0) C_INCOME, gross_amount C_GROSS_AMOUNT, amount_remaining C_AMOUNT_REMAINING, ap_utilities_pkg.ap_round_currency(nvl(DECODE(P.GROSS_AMOUNT, 0, 0, DECODE(S.ALWAYS_TAKE_DISC_FLAG, 'Y', P.DISCOUNT_AMOUNT_AVAILABLE, GREATEST( DECODE(SIGN(:c_test_date -nvl(TO_DATE(P.DISCOUNT_DATE,'DD/MM/YYYY'), to_date('01/01/1901','DD/MM/YYYY'))), 1, 0, nvl(P.DISCOUNT_AMOUNT_AVAILABLE,0)), DECODE(SIGN(:c_test_date -nvl(TO_DATE(P.SECOND_DISCOUNT_DATE,'DD/MM/YYYY'), to_date('01/01/1901','DD/MM/YYYY'))), 1, 0, nvl(P.SECOND_DISC_AMT_AVAILABLE,0)), DECODE(SIGN(:c_test_date -nvl(TO_DATE(P.THIRD_DISCOUNT_DATE,'DD/MM/YYYY'), to_date('01/01/1901','DD/MM/YYYY'))), 1, 0, nvl(P.THIRD_DISC_AMT_AVAILABLE,0)) )) * (P.AMOUNT_REMAINING/ DECODE(P.GROSS_AMOUNT, 0, 1, P.GROSS_AMOUNT))),0)/I.payment_cross_rate,I.invoice_currency_code) C_DISCOUNT_INCOME, I.invoice_currency_code C_CURRENCY_CODE FROM ap_invoices I, po_vendors V, ap_payment_schedules P, po_vendor_sites S, ap_system_parameters O WHERE I.vendor_site_id = S.vendor_site_id AND I.vendor_id = V.vendor_id AND I.invoice_id = P.invoice_id AND I.cancelled_date IS NULL -- bug 12712125 AND P.payment_status_flag in ('N', 'P') AND DECODE(S.ALWAYS_TAKE_DISC_FLAG, 'Y', P.DUE_DATE, DECODE(SIGN(:c_test_date -nvl(TO_DATE(P.DISCOUNT_DATE,'DD/MM/YYYY'), to_date('31/12/2999','DD/MM/YYYY'))), -1, P.DISCOUNT_DATE, DECODE(SIGN(:c_test_date -nvl(TO_DATE(P.SECOND_DISCOUNT_DATE,'DD/MM/YYYY'), to_date('31/12/2999','DD/MM/YYYY'))), -1, P.SECOND_DISCOUNT_DATE, DECODE(SIGN(:c_test_date -nvl(TO_DATE(P.THIRD_DISCOUNT_DATE,'DD/MM/YYYY'), to_date('31/12/2999','DD/MM/YYYY'))), -1, P.THIRD_DISCOUNT_DATE, P.DUE_DATE)))) <= (:P_DISC_THRU_DATE) AND invoice_amount +0 >= :p_min_inv_amount AND ap_utilities_pkg.ap_round_currency(DECODE(P.GROSS_AMOUNT, 0, 0, DECODE(S.ALWAYS_TAKE_DISC_FLAG, 'Y', P.DISCOUNT_AMOUNT_AVAILABLE, GREATEST( DECODE(SIGN(:c_test_date -nvl(TO_DATE(P.DISCOUNT_DATE,'DD/MM/YYYY'), to_date('01/01/1901','DD/MM/YYYY'))), 1, 0, nvl(P.DISCOUNT_AMOUNT_AVAILABLE,0)), DECODE(SIGN(:c_test_date -nvl(TO_DATE(P.SECOND_DISCOUNT_DATE,'DD/MM/YYYY'), to_date('01/01/1901','DD/MM/YYYY'))), 1, 0, nvl(P.SECOND_DISC_AMT_AVAILABLE,0)), DECODE(SIGN(:c_test_date -nvl(TO_DATE(P.THIRD_DISCOUNT_DATE,'DD/MM/YYYY'), to_date('01/01/1901','DD/MM/YYYY'))), 1, 0, nvl(P.THIRD_DISC_AMT_AVAILABLE,0)) )) * (P.AMOUNT_REMAINING/ DECODE(P.GROSS_AMOUNT, 0, 1, P.GROSS_AMOUNT)))/I.payment_cross_rate,I.invoice_currency_code)>= :p_min_disc_amount &C_WHERE_CLAUSE /*Bug 16291918*/ SQLAP APXINDIA_XML AR AP تقرير الخصومات المتاحة (بتنسيق XML) Imported from BI Publisher Description: تقرير الخصومات المتاحة Application: المدفوعات Source: تقرير الخصومات المتاحة (بتنسيق XML) Short Name: APXINDIA_XML DB package: AP_APXINDIA_XMLP_PKG D AP Zahlungen - verfügbare Skonti Imported from BI Publisher Description: Zahlungen - verfügbare Skonti Application: Kreditoren Source: Zahlungen - verfügbare Skonti (XML) Short Name: APXINDIA_XML DB package: AP_APXINDIA_XMLP_PKG E AP Informe de Descuentos Disponibles Imported from BI Publisher Description: Informe de descuentos disponibles Application: Payables Source: Informe de Descuentos Disponibles (XML) Short Name: APXINDIA_XML DB package: AP_APXINDIA_XMLP_PKG F AP Etat des escomptes disponibles Imported from BI Publisher Description: Etat des escomptes disponibles Application: Payables Source: Etat des escomptes disponibles (XML) Short Name: APXINDIA_XML DB package: AP_APXINDIA_XMLP_PKG I AP Rapporto Sconti disponibili Imported from BI Publisher Description: Rapporto Sconti disponibili Application: Payables Source: Rapporto Sconti disponibili (XML) Short Name: APXINDIA_XML DB package: AP_APXINDIA_XMLP_PKG JA AP 割引可能レポート Imported from BI Publisher Description: 割引可能レポート Application: Payables Source: 割引可能レポート (XML) Short Name: APXINDIA_XML DB package: AP_APXINDIA_XMLP_PKG KO AP 할인 가능 보고서 Imported from BI Publisher Description: 할인 가능 보고서 Application: Payables Source: 할인 가능 보고서(XML) Short Name: APXINDIA_XML DB package: AP_APXINDIA_XMLP_PKG PTB AP Relatório de Descontos Disponíveis Imported from BI Publisher Description: Relat. Descontos Disponív. Application: Payables Source: Relatório de Descontos Disponíveis (XML) Short Name: APXINDIA_XML DB package: AP_APXINDIA_XMLP_PKG RU AP Отчет о доступных скидках Imported from BI Publisher Description: Отчет о доступных скидках Application: Кредиторы Source: Отчет о доступных скидках (XML) Short Name: APXINDIA_XML DB package: AP_APXINDIA_XMLP_PKG S AP Tillgängliga rabatter - rapport Imported from BI Publisher Description: Tillgängliga rabatter - rapport Application: Payables Source: Tillgängliga rabatter - rapport (XML) Short Name: APXINDIA_XML DB package: AP_APXINDIA_XMLP_PKG TR AP Uygulanabilir İndirim Raporu Imported from BI Publisher Description: Uygulanabilir İndirim Raporu Application: Borçlar Muhasebesi Source: Uygulanabilir İndirim Raporu (XML) Short Name: APXINDIA_XML DB package: AP_APXINDIA_XMLP_PKG US AP Discounts Available Imported from BI Publisher Description: Discounts Available Report Application: Payables Source: Discounts Available Report (XML) Short Name: APXINDIA_XML DB package: AP_APXINDIA_XMLP_PKG ZHS AP 可用折扣报表 Imported from BI Publisher Description: 可用折扣报表 Application: 应付帐款 Source: 可用折扣报表 (XML) Short Name: APXINDIA_XML DB package: AP_APXINDIA_XMLP_PKG BI Publisher &c_where_clause :c_base_currency_code :c_base_min_acct_unit :c_base_precision :c_company_name_header :c_nls_all :c_nls_end_of_report :c_nls_no_data_exists :c_pay_group :c_report_run_time :c_report_start_date :c_test_date :c_ven_name :c_vendor_type :c_where_clause :operating_unit :p_conc_request_id :p_debug_switch :p_disc_thru_date :p_disc_thru_date_p :p_min_disc_amount :p_min_inv_amount :p_min_precision :p_pay_group :p_sob_id :p_ven_id :p_vendor_type 1 -20 :p_sob_id Char fnd_profile.value('GL_SET_OF_BKS_ID') AR دفتر الأستاذ معرف دفتر الأستاذ D Buch Buchkennung E Libro Mayor Identificador de libro mayor F Livre ID livre I Libro contabile Id del libro contabile JA 元帳 元帳ID KO 원장 원장 ID PTB Razão Id do Razão RU Книга Идентификатор книги S Huvudbok Huvudboks-id TR Defter Defter No US Ledger 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_ven_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 Lieferantenname E Nombre del Proveedor (Omitir=Todos) Nombre de Proveedor F Nom du fournisseur (Sauter si Tous) Nom du fournisseur I Nome fornitore (ignora Tutto) Nome del fornitore JA 仕入先名 (全て処理対象外) 仕入先名 KO 공급자명 (전부 생략) 공급자명 PTB Nome do Fornecedor (saltar Todos) Nome do Fornecedor RU Имя поставщика (пропуск = Все) Имя поставщика S Leverantörsnamn (hoppa över vid Alla) Leverantör TR Tedarikçi Adı (Tümü ise atlayın) Tedarikçi Adı US Supplier Name (skip for All) Supplier Name ZHS 供应商名称（忽略则为全部） 供应商名称 5 30 :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 (Omitir=Todos) Grupo de Pago F Classe de règlements (Sauter si Tous) Classe de règlements I Gruppo pagamenti (ignora Tutto) Gruppo di pagamenti JA 支払グループ (全て処理対象外) 支払グループ KO 지급 그룹 (전부 생략) 지급 그룹 PTB Grupo de Pagamentos (ignorar Todos) Grupo de Pagtos. RU Платежная группа (пропуск = Все) Платежная группа S Betalningsgrupp (hoppa över vid Alla) Betalningsgrupp TR Ödeme Grubu (Tümü ise atlayın) Ödeme Grubu US Pay Group (skip for All) Pay Group ZHS 支付类别（忽略则为全部） 支付组 6 40 :p_min_disc_amount Number Y AR الحد الأدنى لمبلغ الخصم الحد الأدنى لمبلغ الخصم D Mindest-Skontobetrag Mindest-Skontobetrag E Importe Mínimo de Descuento importe mínimo de descuento F Montant minimum d'escompte Montant minimum d'escompte I Importo minimo sconto Importo minimo sconto JA 最小割引額 最小割引額 KO 최소 할인 금액 최소 할인 금액 PTB Quantia Mínima p/Desc. quantia mínima de desconto RU Минимальная сумма скидки Минимальная сумма скидки S Lägsta rabattbelopp lägsta rabattbelopp TR Minimum İndirim Tutarı minimum indirim tutarı US Minimum Discount Amount minimum discount amount ZHS 最小折扣额 最小折扣额 7 50 :p_min_inv_amount Number Y AR الحد الأدنى لقيمة الفاتورة الحد الأدنى لقيمة الفاتورة D Mindest-Rechnungsbetrag Mindest-Rechnungsbetrag E Importe Mínimo de Factura importe mínimo de factura F Montant minimum de facture Montant minimum de facture I Importo minimo fattura Importo minimo fattura JA 最小請求額 最小請求額 KO 최소 송장 금액 최소 송장 금액 PTB Quantia Mínima da NFF quantia mínima da NFF RU Минимальная сумма по счету-фактуре Минимальная сумма по счету-фактуре S Lägsta fakturabelopp lägsta fakturabelopp TR Minimum Fatura Tutarı minimum fatura tutarı US Minimum Invoice Amount minimum invoice amount ZHS 最小发票额 最小发票额 8 60 :p_disc_thru_date Date sysdate Y AR تاريخ نهاية الخصم تاريخ نهاية الخصم D Bis Skontodatum Bis Skontodatum E Fecha de Descuento Final fecha de descuento final F Date de fin d'escompte Date de fin d'escompte I Data fine sconto Data fine sconto JA 最終割引日 最終割引日 KO 할인 종료 일자 할인 종료 일자 PTB Data Final do Desconto data final do desconto RU Дата окончания скидки Дата окончания скидки S Sista rabattdatum sista rabattdatum TR İndirim Bitiş Tarihi indirim bitiş tarihi US Ending Discount Date ending discount date ZHS 终止折扣日期 终止折扣日期