ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 41D74B452851CFA5E06362FB09050951 INSERT INTO AP_1099_TAPE_DATA ( VENDOR_ID , REGION_CODE , ORG_ID ) SELECT /*+ ordered */ P.VENDOR_ID , '' , I.ORG_ID FROM AP_INVOICE_PAYMENTS IP , AP_CHECKS C , CE_BANK_ACCOUNTS ABA , CE_BANK_ACCT_USES_ALL BAU , AP_INVOICES I , PO_VENDORS P , AP_INVOICE_DISTRIBUTIONS ID , GL_CODE_COMBINATIONS CC , AP_REPORTING_ENTITY_LINES REL , (SELECT INVOICE_ID , COUNT (*) IP_COUNT FROM AP_INVOICE_PAYMENTS_ALL AIP WHERE AIP.AMOUNT != 0 AND AIP.ACCOUNTING_DATE BETWEEN :b1 AND :b2 GROUP BY INVOICE_ID ) IP2 WHERE P.VENDOR_ID = I.VENDOR_ID AND ( ( :b3 = 'Y' AND P.FEDERAL_REPORTABLE_FLAG = 'Y' ) OR ( :b3 = 'N' OR :b3 IS NULL ) ) AND I.INVOICE_ID = IP.INVOICE_ID AND IP.INVOICE_ID = IP2.INVOICE_ID (+) AND I.INVOICE_ID = ID.INVOICE_ID AND ( C.VOID_DATE IS NULL OR C.VOID_DATE NOT BETWEEN :b1 AND :b2 ) AND IP.ACCOUNTING_DATE BETWEEN :b1 AND :b2 AND ID.TYPE_1099 IS NOT NULL AND ABA.ASSET_CODE_COMBINATION_ID = CC.CODE_COMBINATION_ID AND C.CE_BANK_ACCT_USE_ID = BAU.BANK_ACCT_USE_ID AND BAU.BANK_ACCOUNT_ID = ABA.BANK_ACCOUNT_ID AND C.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID AND C.CHECK_ID = IP.CHECK_ID AND REL.TAX_ENTITY_ID = :b4 AND CC.CHART_OF_ACCOUNTS_ID = :b5 AND DECODE(:b6 , 'SEGMENT1' , CC.SEGMENT1 , 'SEGMENT2' , CC.SEGMENT2 , 'SEGMENT3' , CC.SEGMENT3 , 'SEGMENT4' , CC.SEGMENT4 , 'SEGMENT5' , CC.SEGMENT5 , 'SEGMENT6' , CC.SEGMENT6 , 'SEGMENT7' , CC.SEGMENT7 , 'SEGMENT8' , CC.SEGMENT8 , 'SEGMENT9' , CC.SEGMENT9 , 'SEGMENT10' , CC.SEGMENT10 , 'SEGMENT11' , CC.SEGMENT11 , 'SEGMENT12' , CC.SEGMENT12 , 'SEGMENT13' , CC.SEGMENT13 , 'SEGMENT14' , CC.SEGMENT14 , 'SEGMENT15' , CC.SEGMENT15 , 'SEGMENT16' , CC.SEGMENT16 , 'SEGMENT17' , CC.SEGMENT17 , 'SEGMENT18' , CC.SEGMENT18 , 'SEGMENT19' , CC.SEGMENT19 , 'SEGMENT20' , CC.SEGMENT20 , 'SEGMENT21' , CC.SEGMENT21 , 'SEGMENT22' , CC.SEGMENT22 , 'SEGMENT23' , CC.SEGMENT23 , 'SEGMENT24' , CC.SEGMENT24 , 'SEGMENT25' , CC.SEGMENT25 , 'SEGMENT26' , CC.SEGMENT26 , 'SEGMENT27' , CC.SEGMENT27 , 'SEGMENT28' , CC.SEGMENT28 , 'SEGMENT29' , CC.SEGMENT29 , 'SEGMENT30' , CC.SEGMENT30 ) = REL.BALANCING_SEGMENT_VALUE GROUP BY P.VENDOR_ID , I.ORG_ID HAVING :b7 = 'N' OR ( SUM (DECODE(ID.TYPE_1099 , 'MISC1' , ( DECODE(I.CANCELLED_AMOUNT , NULL , ID.AMOUNT , DECODE(GREATEST(ID.ACCOUNTING_DATE , :b2 + 1 ) , ID.ACCOUNTING_DATE , 0 , DECODE(LEAST(ID.ACCOUNTING_DATE , :b1 - 1 ) , ID.ACCOUNTING_DATE , 0 , ID.AMOUNT ) ) ) / DECODE(I.INVOICE_AMOUNT , 0 , DECODE(I.CANCELLED_AMOUNT , NULL , 1 , 0 , 1 , I.CANCELLED_AMOUNT ) , DECODE(AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) , 0 , 1 , AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) ) ) * DECODE(IP.AMOUNT , 0 , DECODE(IP2.IP_COUNT , NULL , 1 , 0 ) , IP.AMOUNT ) ) , 0 ) ) + SUM (DECODE(ID.TYPE_1099 , 'MISC3' , ( DECODE(I.CANCELLED_AMOUNT , NULL , ID.AMOUNT , DECODE(GREATEST(ID.ACCOUNTING_DATE , :b2 + 1 ) , ID.ACCOUNTING_DATE , 0 , DECODE(LEAST(ID.ACCOUNTING_DATE , :b1 - 1 ) , ID.ACCOUNTING_DATE , 0 , ID.AMOUNT ) ) ) / DECODE(I.INVOICE_AMOUNT , 0 , DECODE(I.CANCELLED_AMOUNT , NULL , 1 , 0 , 1 , I.CANCELLED_AMOUNT ) , DECODE(AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) , 0 , 1 , AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) ) ) * DECODE(IP.AMOUNT , 0 , DECODE(IP2.IP_COUNT , NULL , 1 , 0 ) , IP.AMOUNT ) ) , 0 ) ) + SUM (DECODE(ID.TYPE_1099 , 'MISC6' , ( DECODE(I.CANCELLED_AMOUNT , NULL , ID.AMOUNT , DECODE(GREATEST(ID.ACCOUNTING_DATE , :b2 + 1 ) , ID.ACCOUNTING_DATE , 0 , DECODE(LEAST(ID.ACCOUNTING_DATE , :b1 - 1 ) , ID.ACCOUNTING_DATE , 0 , ID.AMOUNT ) ) ) / DECODE(I.INVOICE_AMOUNT , 0 , DECODE(I.CANCELLED_AMOUNT , NULL , 1 , 0 , 1 , I.CANCELLED_AMOUNT ) , DECODE(AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) , 0 , 1 , AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) ) ) * DECODE(IP.AMOUNT , 0 , DECODE(IP2.IP_COUNT , NULL , 1 , 0 ) , IP.AMOUNT ) ) , 0 ) ) + SUM (DECODE(ID.TYPE_1099 , 'MISC7' , ( DECODE(I.CANCELLED_AMOUNT , NULL , ID.AMOUNT , DECODE(GREATEST(ID.ACCOUNTING_DATE , :b2 + 1 ) , ID.ACCOUNTING_DATE , 0 , DECODE(LEAST(ID.ACCOUNTING_DATE , :b1 - 1 ) , ID.ACCOUNTING_DATE , 0 , ID.AMOUNT ) ) ) / DECODE(I.INVOICE_AMOUNT , 0 , DECODE(I.CANCELLED_AMOUNT , NULL , 1 , 0 , 1 , I.CANCELLED_AMOUNT ) , DECODE(AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) , 0 , 1 , AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) ) ) * DECODE(IP.AMOUNT , 0 , DECODE(IP2.IP_COUNT , NULL , 1 , 0 ) , IP.AMOUNT ) ) , 0 ) ) + SUM (DECODE(ID.TYPE_1099 , 'MISC9' , ( DECODE(I.CANCELLED_AMOUNT , NULL , ID.AMOUNT , DECODE(GREATEST(ID.ACCOUNTING_DATE , :b2 + 1 ) , ID.ACCOUNTING_DATE , 0 , DECODE(LEAST(ID.ACCOUNTING_DATE , :b1 - 1 ) , ID.ACCOUNTING_DATE , 0 , ID.AMOUNT ) ) ) / DECODE(I.INVOICE_AMOUNT , 0 , DECODE(I.CANCELLED_AMOUNT , NULL , 1 , 0 , 1 , I.CANCELLED_AMOUNT ) , DECODE(AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) , 0 , 1 , AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) ) ) * DECODE(IP.AMOUNT , 0 , DECODE(IP2.IP_COUNT , NULL , 1 , 0 ) , IP.AMOUNT ) ) , 0 ) ) + SUM (DECODE(ID.TYPE_1099 , 'MISC10' , ( DECODE(I.CANCELLED_AMOUNT , NULL , ID.AMOUNT , DECODE(GREATEST(ID.ACCOUNTING_DATE , :b2 + 1 ) , ID.ACCOUNTING_DATE , 0 , DECODE(LEAST(ID.ACCOUNTING_DATE , :b1 - 1 ) , ID.ACCOUNTING_DATE , 0 , ID.AMOUNT ) ) ) / DECODE(I.INVOICE_AMOUNT , 0 , DECODE(I.CANCELLED_AMOUNT , NULL , 1 , 0 , 1 , I.CANCELLED_AMOUNT ) , DECODE(AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) , 0 , 1 , AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) ) ) * DECODE(IP.AMOUNT , 0 , DECODE(IP2.IP_COUNT , NULL , 1 , 0 ) , IP.AMOUNT ) ) , 0 ) ) >= 600 OR SUM (DECODE(ID.TYPE_1099 , 'MISC2' , ( DECODE(I.CANCELLED_AMOUNT , NULL , ID.AMOUNT , DECODE(GREATEST(ID.ACCOUNTING_DATE , :b2 + 1 ) , ID.ACCOUNTING_DATE , 0 , DECODE(LEAST(ID.ACCOUNTING_DATE , :b1 - 1 ) , ID.ACCOUNTING_DATE , 0 , ID.AMOUNT ) ) ) / DECODE(I.INVOICE_AMOUNT , 0 , DECODE(I.CANCELLED_AMOUNT , NULL , 1 , 0 , 1 , I.CANCELLED_AMOUNT ) , DECODE(AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) , 0 , 1 , AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) ) ) * DECODE(IP.AMOUNT , 0 , DECODE(IP2.IP_COUNT , NULL , 1 , 0 ) , IP.AMOUNT ) ) , 0 ) ) >= 10 OR SUM (DECODE(ID.TYPE_1099 , 'MISC8' , ( DECODE(I.CANCELLED_AMOUNT , NULL , ID.AMOUNT , DECODE(GREATEST(ID.ACCOUNTING_DATE , :b2 + 1 ) , ID.ACCOUNTING_DATE , 0 , DECODE(LEAST(ID.ACCOUNTING_DATE , :b1 - 1 ) , ID.ACCOUNTING_DATE , 0 , ID.AMOUNT ) ) ) / DECODE(I.INVOICE_AMOUNT , 0 , DECODE(I.CANCELLED_AMOUNT , NULL , 1 , 0 , 1 , I.CANCELLED_AMOUNT ) , DECODE(AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) , 0 , 1 , AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) ) ) * DECODE(IP.AMOUNT , 0 , DECODE(IP2.IP_COUNT , NULL , 1 , 0 ) , IP.AMOUNT ) ) , 0 ) ) >= 10 OR SUM (DECODE(ID.TYPE_1099 , 'MISC15a T' , ( DECODE(I.CANCELLED_AMOUNT , NULL , ID.AMOUNT , DECODE(GREATEST(ID.ACCOUNTING_DATE , :b2 + 1 ) , ID.ACCOUNTING_DATE , 0 , DECODE(LEAST(ID.ACCOUNTING_DATE , :b1 - 1 ) , ID.ACCOUNTING_DATE , 0 , ID.AMOUNT ) ) ) / DECODE(I.INVOICE_AMOUNT , 0 , DECODE(I.CANCELLED_AMOUNT , NULL , 1 , 0 , 1 , I.CANCELLED_AMOUNT ) , DECODE(AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) , 0 , 1 , AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) ) ) * DECODE(IP.AMOUNT , 0 , DECODE(IP2.IP_COUNT , NULL , 1 , 0 ) , IP.AMOUNT ) ) , 0 ) ) + SUM (DECODE(ID.TYPE_1099 , 'MISC15a NT' , ( DECODE(I.CANCELLED_AMOUNT , NULL , ID.AMOUNT , DECODE(GREATEST(ID.ACCOUNTING_DATE , :b2 + 1 ) , ID.ACCOUNTING_DATE , 0 , DECODE(LEAST(ID.ACCOUNTING_DATE , :b1 - 1 ) , ID.ACCOUNTING_DATE , 0 , ID.AMOUNT ) ) ) / DECODE(I.INVOICE_AMOUNT , 0 , DECODE(I.CANCELLED_AMOUNT , NULL , 1 , 0 , 1 , I.CANCELLED_AMOUNT ) , DECODE(AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) , 0 , 1 , AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) ) ) * DECODE(IP.AMOUNT , 0 , DECODE(IP2.IP_COUNT , NULL , 1 , 0 ) , IP.AMOUNT ) ) , 0 ) ) >= 600 OR SUM (DECODE(ID.TYPE_1099 , 'MISC13' , ( DECODE(I.CANCELLED_AMOUNT , NULL , ID.AMOUNT , DECODE(GREATEST(ID.ACCOUNTING_DATE , :b2 + 1 ) , ID.ACCOUNTING_DATE , 0 , DECODE(LEAST(ID.ACCOUNTING_DATE , :b1 - 1 ) , ID.ACCOUNTING_DATE , 0 , ID.AMOUNT ) ) ) / DECODE(I.INVOICE_AMOUNT , 0 , DECODE(I.CANCELLED_AMOUNT , NULL , 1 , 0 , 1 , I.CANCELLED_AMOUNT ) , DECODE(AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) , 0 , 1 , AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) ) ) * DECODE(IP.AMOUNT , 0 , DECODE(IP2.IP_COUNT , NULL , 1 , 0 ) , IP.AMOUNT ) ) , 0 ) ) + SUM (DECODE(ID.TYPE_1099 , 'MISC5' , ( DECODE(I.CANCELLED_AMOUNT , NULL , ID.AMOUNT , DECODE(GREATEST(ID.ACCOUNTING_DATE , :b2 + 1 ) , ID.ACCOUNTING_DATE , 0 , DECODE(LEAST(ID.ACCOUNTING_DATE , :b1 - 1 ) , ID.ACCOUNTING_DATE , 0 , ID.AMOUNT ) ) ) / DECODE(I.INVOICE_AMOUNT , 0 , DECODE(I.CANCELLED_AMOUNT , NULL , 1 , 0 , 1 , I.CANCELLED_AMOUNT ) , DECODE(AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) , 0 , 1 , AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) ) ) * DECODE(IP.AMOUNT , 0 , DECODE(IP2.IP_COUNT , NULL , 1 , 0 ) , IP.AMOUNT ) ) , 0 ) ) > 0 OR SUM (DECODE(ID.TYPE_1099 , 'MISC14' , ( DECODE(I.CANCELLED_AMOUNT , NULL , ID.AMOUNT , DECODE(GREATEST(ID.ACCOUNTING_DATE , :b2 + 1 ) , ID.ACCOUNTING_DATE , 0 , DECODE(LEAST(ID.ACCOUNTING_DATE , :b1 - 1 ) , ID.ACCOUNTING_DATE , 0 , ID.AMOUNT ) ) ) / DECODE(I.INVOICE_AMOUNT , 0 , DECODE(I.CANCELLED_AMOUNT , NULL , 1 , 0 , 1 , I.CANCELLED_AMOUNT ) , DECODE(AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) , 0 , 1 , AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) ) ) * DECODE(IP.AMOUNT , 0 , DECODE(IP2.IP_COUNT , NULL , 1 , 0 ) , IP.AMOUNT ) ) , 0 ) ) >= 600 OR SUM (DECODE(ID.TYPE_1099 , 'MISC15b' , ( DECODE(I.CANCELLED_AMOUNT , NULL , ID.AMOUNT , DECODE(GREATEST(ID.ACCOUNTING_DATE , :b2 + 1 ) , ID.ACCOUNTING_DATE , 0 , DECODE(LEAST(ID.ACCOUNTING_DATE , :b1 - 1 ) , ID.ACCOUNTING_DATE , 0 , ID.AMOUNT ) ) ) / DECODE(I.INVOICE_AMOUNT , 0 , DECODE(I.CANCELLED_AMOUNT , NULL , 1 , 0 , 1 , I.CANCELLED_AMOUNT ) , DECODE(AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) , 0 , 1 , AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) ) ) * DECODE(IP.AMOUNT , 0 , DECODE(IP2.IP_COUNT , NULL , 1 , 0 ) , IP.AMOUNT ) ) , 0 ) ) > 0 OR -1 * SUM (DECODE(ID.TYPE_1099 , 'MISC4' , ( DECODE(I.CANCELLED_AMOUNT , NULL , ID.AMOUNT , DECODE(GREATEST(ID.ACCOUNTING_DATE , :b2 + 1 ) , ID.ACCOUNTING_DATE , 0 , DECODE(LEAST(ID.ACCOUNTING_DATE , :b1 - 1 ) , ID.ACCOUNTING_DATE , 0 , ID.AMOUNT ) ) ) / DECODE(I.INVOICE_AMOUNT , 0 , DECODE(I.CANCELLED_AMOUNT , NULL , 1 , 0 , 1 , I.CANCELLED_AMOUNT ) , DECODE(AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) , 0 , 1 , AP_UTILITIES_PKG.NET_INVOICE_AMOUNT(I.INVOICE_ID ) ) ) * DECODE(IP.AMOUNT , 0 , DECODE(IP2.IP_COUNT , NULL , 1 , 0 ) , IP.AMOUNT ) ) , 0 ) ) > 0 ) Y AR AP تقرير مدفوعات 1099 Imported from Concurrent Program Application: المدفوعات Source: تقرير مدفوعات 1099 Short Name: APXTRRVT D AP US-Steuerformular 1099 - Zahlungsliste Imported from Concurrent Program Application: Kreditoren Source: US-Steuerformular 1099 - Zahlungsliste Short Name: APXTRRVT E AP 1099 de Pagos Imported from Concurrent Program Description: Informe 1099 de Pagos Application: Payables Source: 1099 de Pagos Short Name: APXTRRVT F AP Etat des règlements d'honoraires Imported from Concurrent Program Application: Payables Source: Etat des règlements d'honoraires Short Name: APXTRRVT I AP Rapporto Pagamenti 1099 (US) Imported from Concurrent Program Application: Payables Source: Rapporto Pagamenti 1099 (US) Short Name: APXTRRVT JA AP 1099支払レポート Imported from Concurrent Program Application: Payables Source: 1099支払レポート Short Name: APXTRRVT KO AP 1099 지급 보고서 Imported from Concurrent Program Application: Payables Source: 1099 지급 보고서 Short Name: APXTRRVT PTB AP Relatório de Pagamentos 1099 Imported from Concurrent Program Application: Payables Source: Relatório de Pagamentos 1099 Short Name: APXTRRVT RU AP Отчет о платежах 1099 Imported from Concurrent Program Application: Кредиторы Source: Отчет о платежах 1099 Short Name: APXTRRVT S AP 1099-betalningar - rapport Imported from Concurrent Program Application: Payables Source: 1099-betalningar - rapport Short Name: APXTRRVT TR AP 1099 Ödemeler Raporu Imported from Concurrent Program Application: Borçlar Muhasebesi Source: 1099 Ödemeler Raporu Short Name: APXTRRVT US AP 1099 Payments (1) Imported from Concurrent Program Application: Payables Source: 1099 Payments Report Short Name: APXTRRVT ZHS AP 1099 付款报表 Imported from Concurrent Program Application: 应付帐款 Source: 1099 付款报表 Short Name: APXTRRVT Concurrent Program 1=1 1 -10 :p_set_of_books_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 10 :p_group_by LOV Oracle AP_SRS_GROUP_BY Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where nvl(inactive_date,sysdate+1)>sysdate and lookup_type='GROUP BY' order by value,description select displayed_field from ap_lookup_codes where lookup_type = 'GROUP BY' and lookup_code = 'Vendor' Y AR تجميع بواسطة تجميع بواسطة D Gruppieren nach Gruppieren nach E Agrupar por Agrupar por F Groupé par Groupé par I Raggruppa per Raggruppa per JA グループ別 グループ別 KO 그룹핑 기준 그룹핑 기준 PTB Agrupar por agrupar por RU Группировка Группировка S Gruppera per gruppera efter TR Gruplama bazı gruplama bazı US Group By group by ZHS 分组依据 分组依据 3 20 :p_break_method LOV Oracle AP_SRS_RUN_REPORT_OPTION Y select lookup_code id, displayed_field value, description description from ap_lookup_codes where lookup_type='1099 PAYMENT REPORT OPTION' order by value,description select displayed_field from ap_lookup_codes where lookup_type = '1099 PAYMENT REPORT OPTION' and lookup_code = 'Summary' Y AR خيار التقرير طريقة التقرير D Auswertungsoption Auswertungsart E Opción de Declaración Método de Declaración F Option d'édition Méthode d'édition I Opzione Dichiarazione Metodo della dichiarazione JA レポート・オプション レポート方法 KO 보고 옵션 보고 방법 PTB Opção de Registro Método do Relatório RU Параметр отчетности Метод отчетности S Rapporteringsalternativ Rapporteringsmetod TR Raporlama Seçeneği Parorlama Yöntemi US Reporting Option Reporting Method ZHS 报告选项 报告方法 4 30 :p_start_date Date Y AR من تاريخ السداد من تاريخ السداد D Von Zahlungsdatum Von Zahlungsdatum E De Fecha de Pago De Fecha de Pago F Date de règlement - Du date du règlement - Du I Data pagamento - Da Data pagamento - Da JA 支払日:自 支払日:自 KO 지급 일자: 부터 지급 일자: 부터 PTB Data do Pagamento - De data do pagamento - de RU Дата платежа с дата платежа с S Från betalningsdatum från betalningsdatum TR İlk Ödeme Tarihi ödeme tarihi - başlangıç US From Payment Date from payment date ZHS 自付款日期 起始付款日期 5 40 :p_end_date Date sysdate Y AR إلى تاريخ السداد إلى تاريخ السداد D Bis Zahlungsdatum Bis Zahlungsdatum E A Fecha de Pago A Fecha de Pago F Date de règlement - Au date du règlement - Au I Data pagamento - A Data pagamento - A JA 支払日:至 支払日:至 KO 지급 일자: 까지 지급 일자: 까지 PTB Data do Pagamento - Até data do pagamento - até RU Дата платежа по дата платежа по S Till betalningsdatum till betalningsdatum TR Son Ödeme Tarihi ödeme tarihi - bitiş US To Payment Date to payment date ZHS 至付款日期 终止付款日期 6 50 :p_vendor_id LOV Oracle AP_SRS_SUPPLIER_NAME_1099 Y select vendor_id id, v.vendor_name value, null description from po_vendors v where :$flex$.ap_srs_group_by='Vendor' order by v.vendor_name AR اسم المورِّد اسم المورِّد D Lieferantenname Lieferantenname E Nombre de Proveedor Nombre de Proveedor F Nom du fournisseur Nom du fournisseur I Nome fornitore Nome 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 供应商名称 供应商名称 7 60 :p_input_region_short_name LOV Oracle AP_SRS_INCOME_TAX_REGIONS Y select region_short_name id, region_short_name value, region_long_name description from ap_income_tax_regions where sysdate between nvl(active_date,sysdate) and nvl(inactive_date,sysdate) order by upper(region_long_name) AR منطقة ضريبة الدخل منطقة ضريبة الدخل للتقرير على D Einkommensteuerregion Einkommensteuerregion, für die die Auswertung gestartet wird E Región Fiscal Región Fiscal sobre la que declarar F Région de déclaration des honoraires Région de déclaration des honoraires pour laquelle vous voulez éditer l'état I Area imposta sul reddito Provincia dell'imposta sul reddito per cui eseguire il rapporto JA 所得税リージョン レポートに記載された所得税リージョン KO 소득세 납세지 보고 대상 소득세 납부지역 PTB Região Imposto de Renda Região do Imposto de Renda a ser emitido relatório em RU Область подоходного налога Область подоходного налога для отчетности S 1099-region Den 1099-region som du vill ha med i rapporten TR Gelir Vergi Bölgesi Raporlanacak Gelir Vergi Bölgesi US Income Tax Region Income Tax Region to report on ZHS 所得税区域 要报告的所得税区域 8 70 :p_tax_entity_id LOV Oracle AP_SRS_TAX_REPORTING_ENTITIES Y select tax_entity_id id, entity_name value, null description from ap_reporting_entities order by value,description select entity_name from ap_reporting_entities where 1 = (select count(*) from ap_reporting_entities) Y AR كيان تقرير الضريبة كيان تقرير الضريبة D Steuerpflichtiger Steuerpflichtiger E Entidad Fiscal Entidad Fiscal F Entité DAS2 Entité DAS2 I Soggetto fiscale Soggetto fiscale JA 税金レポート・エンティティ 税金レポート・エンティティ KO 세금 신고 법인체 세금 신고 법인체 PTB Entidade para Geração de Relatórios de Imposto Entidade para Geração de Relatórios de Imposto RU Единица налоговой отчетности Единица налоговой отчетности S Skatterapporteringsenhet Skatterapporteringsenhet TR Vergi Raporlama Şirketi Vergi Raporlama Şirketi US Tax Reporting Entity Tax Reporting Entity ZHS 纳税申报实体 纳税申报实体 9 80 :p_fed_reportable 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 Nur für US Finanzamt Nur Lieferanten, die der US-Einkommensteuerpflicht unterliegen E Sólo Declarar a Hacienda Incluir sólo los proveedores que se pueden declarar a Hacienda F Déclarer IRS (USA) seulement Inclure uniquement les fournisseurs de type Déclarer IRS (USA) I Solo dichiarabile federale Include solo i fornitori dichiarabili federali JA 連邦政府レポートのみ 連邦レポート可能の仕入先のみ含む KO 연방 보고만 국세 신고 대상 공급자만 포함 PTB Apenas Encaminhamento Federal Incluir apenas os fornecedores com encaminhamento federal RU Только отчетность на федеральном уровне Включить только поставщиков, подотчетных на федеральном уровне S Rapporteras enligt federala regler Ta bara med de leverantörer som rapporterar statlig inkomstskatt TR Salt Federal Raporlanabilir Salt federal olarak raporlanabilir olan tedarikçileri dahil eder US Federal Reportable Only Include only vendors who are federally reportable ZHS 仅可以联邦申报 仅包括可向联邦申报的供应商 10 90 :p_min_report_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 Nur Mindestanforderungen Nur Lieferanten, die die Mindestanforderungen der US-Einkommensteuererklärung erfüllen E Sólo Reúnen Niveles Mínimos Incluir sólo los proveedores que cumplen los criterios mínimos de declaración a Hacienda F Niveaux minimum uniquement Uniquement fournisseurs répondant aux critères minimum pour édition d'états fédéraux I Rispondente solo a livelli minimi Include i solo i fornitori rispondenti a criteri minimi di dichiarazione federale JA 最小レベルのみに合致 最小連邦レポート基準と合致する仕入先のみ含む KO 최소 수준만 충족 최소 국세 보고 기준에 맞는 공급자만 포함 PTB Apenas os Níveis Mínimos de Satisfação Incluir apenas os fornecedores que satisfaçam os critérios mínimos de encaminhamento federal RU Только соответствующие мин. уровню Включить только поставщиков, соответствующих минимальному уровню федеральной отчетности S Uppfyller bara de lägsta villkoren Inkludera endast de leverantörer som uppfyller de lägsta kriterierna för rapportering av statlig inkomstskatt TR Salt Minimum Düzeyleri Karşıla Salt minimum federal raporlama ölçütünü karşılayan tedarikçileri dahil eder US Meeting Minimum Levels Only Include only vendors meeting the minimum federal reporting criteria ZHS 仅满足最低层 仅包括满足最低联邦申报标准的供应商 11 100 :p_query_driver Char PAY AR مشغل الاستعلام مشغل الاستعلام D Abfrage-Treiber Abfrage-Treiber E Controlador de Consultas Controlador de Consultas F Paramètre de détermination de compte (query driver) Paramètre de détermination de compte (query driver) I Esegui query su driver Esegue la query sui driver JA クエリー・ドライバ クエリー・ドライバ KO 조회 드라이버 조회 드라이버 PTB Driver de Consulta Driver de Consulta RU Драйвер запроса Драйвер запроса S Drivrutin för sökning Drivrutin för sökning TR Sorgulama Sürücüsü Sorgulama Sürücüsü US Query Driver Query Driver ZHS 查询驱动程序 查询驱动程序 :$flex$.ap_srs_group_by Group By Supplier Name