ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4705751A9E05362FB09050512Y SELECT JZVTD.reporting_code REPORTING_CODE ,JZVTD.trx_id INVOICE_ID ,DECODE(JZVTD.trx_line_class ,'ADJUSTMENT',JZVTD.applied_to_trx_number , JZVTD.trx_number) INVOICE_NUMBER ,NULL EXPORT_NUMBER ,TO_CHAR(JZVTD.trx_date,'DD-Mon-RRRR') INVOICE_DATE ,JZVTD.trx_line_class TRX_LINE_CLASS_CODE ,JZVTD.tax_rate_code_vat_trx_type_mng VAT_CODE ,JZVTD.tax_rate_vat_trx_type_desc VAT_DESC ,JZVTD.tax_rate_vat_trx_type_code VAT_TYPE ,JZVTD.posted_flag POSTED_FLAG ,SUM(NVL( JZVTD.tax_amt_funcl_curr,JZVTD.tax_amt) + NVL( JZVTD.taxable_amt_funcl_curr,JZVTD.TAXABLE_AMT) ) TRX_AMOUNT ,SUM(NVL(JZVTD.tax_amt_funcl_curr,0) + NVL(JZVTD.taxable_amt_funcl_curr,0) ) FUNC_AMOUNT ,SUM(DECODE(JZVTD.reporting_code,'IL_VAT_EXEMPT', 0 ,'VAT-EXEMPT',0 ,'VAT-0',0 ,(DECODE(JZVTD.TAX_RATE,0,0, NVL(JZVTD.taxable_amt_funcl_curr,JZVTD.taxable_amt))) ) ) TAXABLE_AMOUNT ,SUM(DECODE(JZVTD.reporting_code,'IL_VAT_EXEMPT', 0 ,'VAT-EXEMPT',0 ,'VAT-0',0 ,(DECODE(JZVTD.TAX_RATE,0,0, NVL( JZVTD.tax_amt_funcl_curr,JZVTD.tax_amt))) ) ) TAX_AMOUNT ,SUM((DECODE(JZVTD.reporting_code,'IL_VAT_EXEMPT',NVL(JZVTD.taxable_amt_funcl_curr,JZVTD.taxable_amt) ,'VAT-EXEMPT',NVL(JZVTD.taxable_amt_funcl_curr,JZVTD.taxable_amt) ,'VAT-0',NVL(JZVTD.taxable_amt_funcl_curr,JZVTD.taxable_amt) ,DECODE(JZVTD.tax_rate,0,NVL(JZVTD.taxable_amt_funcl_curr,JZVTD.taxable_amt),0) ) ) ) EXEMPT_AMOUNT ,SUM(DECODE(JZVTD.reporting_code,'IL_VAT_EXEMPT', 0 ,'VAT-EXEMPT',0 ,'VAT-0',0 ,(DECODE(JZVTD.TAX_RATE,0,0, NVL(JZVTD.taxable_amt_funcl_curr,JZVTD.taxable_amt))) ) ) + SUM(DECODE(JZVTD.reporting_code,'IL_VAT_EXEMPT', 0 ,'VAT-EXEMPT',0 ,'VAT-0',0 ,(DECODE(JZVTD.TAX_RATE,0,0, NVL( JZVTD.tax_amt_funcl_curr,JZVTD.tax_amt))) ) ) + SUM((DECODE(JZVTD.reporting_code,'IL_VAT_EXEMPT',NVL(JZVTD.taxable_amt_funcl_curr,JZVTD.taxable_amt) ,'VAT-EXEMPT',NVL(JZVTD.taxable_amt_funcl_curr,JZVTD.taxable_amt) ,'VAT-0',NVL(JZVTD.taxable_amt_funcl_curr,JZVTD.taxable_amt) ,DECODE(JZVTD.tax_rate,0,NVL(JZVTD.taxable_amt_funcl_curr,JZVTD.taxable_amt),0) ) ) ) DERIVED_TOT_AMT -- bug 22480577 ,NVL(JZVTD.billing_tp_taxpayer_id,'N') TAX_PAY_ID FROM JG_ZZ_VAT_TRX_DETAILS JZVTD ,JG_ZZ_VAT_REP_STATUS JZVRS WHERE :P_CALLINGREPORT = 'JEILARDR' AND JZVRS.vat_reporting_entity_id = :P_VAT_REP_ENTITY_ID AND JZVTD.reporting_status_id = JZVRS.REPORTING_STATUS_ID AND JZVRS.tax_calendar_period = :P_PERIOD AND (JZVTD.tax_rate_vat_trx_type_code = :P_VAT_TRX_TYPE OR :P_VAT_TRX_TYPE IS NULL) AND JZVRS.source = 'AR' AND JZVTD.reporting_code NOT IN ('VAT-NO-REP','VAT-Y') GROUP BY JZVTD.reporting_code ,JZVTD.trx_id ,DECODE(JZVTD.trx_line_class ,'ADJUSTMENT',JZVTD.applied_to_trx_number , JZVTD.trx_number) ,JZVTD.trx_date ,JZVTD.trx_line_class ,JZVTD.tax_rate_code_vat_trx_type_mng ,JZVTD.tax_rate_vat_trx_type_desc ,JZVTD.tax_rate_vat_trx_type_code ,JZVTD.posted_flag ,NVL(JZVTD.billing_tp_taxpayer_id,'N') UNION ALL SELECT JZVTD.reporting_code REPORTING_CODE ,JZVTD.trx_id INVOICE_ID ,DECODE(JZVTD.trx_line_class ,'ADJUSTMENT',JZVTD.applied_to_trx_number , JZVTD.trx_number) INVOICE_NUMBER ,NVL(RCTLA.global_attribute1,'999999999') EXPORT_NUMBER ,TO_CHAR(DECODE(LENGTH(NVL(RCTLA.global_attribute2,'A')), 1,JZVTD.TRX_DATE, 19,TO_DATE(RCTLA.global_attribute2,'RRRR/MM/DD HH24:MI:SS'), TO_DATE(RCTLA.global_attribute2, 'DD-MM-RRRR') ),'DD-Mon-RRRR') INVOICE_DATE ,JZVTD.trx_line_class TRX_LINE_CLASS_CODE ,JZVTD.tax_rate_code_vat_trx_type_mng VAT_CODE ,JZVTD.tax_rate_vat_trx_type_desc VAT_DESC ,JZVTD.tax_rate_vat_trx_type_code VAT_TYPE ,JZVTD.posted_flag POSTED_FLAG ,SUM(NVL(JZVTD.taxable_amt_funcl_curr,JZVTD.taxable_amt)+ NVL( JZVTD.tax_amt_funcl_curr,JZVTD.tax_amt) ) TRX_AMOUNT ,SUM(NVL(JZVTD.tax_amt_funcl_curr,0) + NVL(JZVTD.taxable_amt_funcl_curr,0) ) FUNC_AMOUNT ,0 TAXABLE_AMOUNT ,0 TAX_AMOUNT ,SUM(NVL(JZVTD.taxable_amt_funcl_curr,JZVTD.taxable_amt)) EXEMPT_AMOUNT ,SUM(NVL(JZVTD.taxable_amt_funcl_curr,JZVTD.taxable_amt)) DERIVED_TOT_AMT -- bug22480577 ,'N/A' TAX_PAY_ID FROM JG_ZZ_VAT_TRX_DETAILS JZVTD ,JG_ZZ_VAT_REP_STATUS JZVRS ,RA_CUSTOMER_TRX_ALL RCTA ,RA_CUSTOMER_TRX_LINES_ALL RCTLA WHERE :P_CALLINGREPORT = 'JEILARDR' AND JZVRS.vat_reporting_entity_id = :P_VAT_REP_ENTITY_ID AND JZVTD.reporting_status_id = JZVRS.REPORTING_STATUS_ID AND RCTA.customer_trx_id = RCTLA.customer_trx_id AND RCTA.customer_trx_id = JZVTD.trx_id AND RCTLA.customer_trx_line_id = JZVTD.trx_line_id AND JZVRS.tax_calendar_period = :P_PERIOD AND (JZVTD.tax_rate_vat_trx_type_code = :P_VAT_TRX_TYPE OR :p_vat_trx_type IS NULL) AND JZVRS.source = 'AR' AND JZVTD.reporting_code = 'VAT-Y' GROUP BY JZVTD.reporting_code ,JZVTD.trx_id ,DECODE(JZVTD.trx_line_class ,'ADJUSTMENT',JZVTD.applied_to_trx_number , JZVTD.trx_number) ,NVL(RCTLA.global_attribute1,'999999999') ,DECODE(LENGTH(NVL(RCTLA.global_attribute2,'A')), 1,JZVTD.TRX_DATE, 19,TO_DATE(RCTLA.global_attribute2,'RRRR/MM/DD HH24:MI:SS'), TO_DATE(RCTLA.global_attribute2, 'DD-MM-RRRR')) ,JZVTD.trx_line_class ,JZVTD.tax_rate_code_vat_trx_type_mng ,JZVTD.tax_rate_vat_trx_type_desc ,JZVTD.tax_rate_vat_trx_type_code ,JZVTD.posted_flag ORDER BY 6,1,4 JE JEDEDVOR_XMLP AR JE ضريبة القيمة المضافة الألمانية للإيصالات تحت الحساب Imported from BI Publisher Description: تقرير ضريبة القيمة المضافة الألمانية لإيصالات على الحساب Application: المحليات الأوروبية Source: ضريبة القيمة المضافة الألمانية للإيصالات تحت الحساب Short Name: JEDEDVOR_XMLP DB package: JG_ZZ_SUMMARY_AR_PKG D JE Umsatzsteuer auf Vorauszahlungen Imported from BI Publisher Description: Deutschland: Auswertung "Umsatzsteuer auf Vorauszahlungen" Application: Europäische Lokalisierungen Source: Deutschland: Umsatzsteuer auf Vorauszahlungen Short Name: JEDEDVOR_XMLP DB package: JG_ZZ_SUMMARY_AR_PKG E JE Alemania - IVA para Cobros a Cuenta Imported from BI Publisher Description: Alemania - Informe de IVA para cobros a cuenta Application: Localizaciones Europeas Source: Alemania - IVA para Cobros a Cuenta Short Name: JEDEDVOR_XMLP DB package: JG_ZZ_SUMMARY_AR_PKG F JE Allemagne - TVA pour règlements en compte Imported from BI Publisher Description: Allemagne - Etat de TVA pour règlements en compte Application: European Localizations Source: Allemagne - TVA pour règlements en compte Short Name: JEDEDVOR_XMLP DB package: JG_ZZ_SUMMARY_AR_PKG I JE Germania - IVA per incassi in conto Imported from BI Publisher Description: Germania - rapporto IVA per incassi in conto Application: European Localizations Source: Germania - IVA per incassi in conto Short Name: JEDEDVOR_XMLP DB package: JG_ZZ_SUMMARY_AR_PKG RU JE НДС для предварительных поступлений (Германия) Imported from BI Publisher Application: Версии для Европы Source: НДС для предварительных поступлений (Германия) Short Name: JEDEDVOR_XMLP DB package: JG_ZZ_SUMMARY_AR_PKG S JE Tysk moms för a konto-betalningar Imported from BI Publisher Description: Tyskland: Moms för a konto-betalningar - rapport Application: European Localizations Source: Tysk moms för a konto-betalningar Short Name: JEDEDVOR_XMLP DB package: JG_ZZ_SUMMARY_AR_PKG TR JE Almanya Hesaba Mahsuben Ödemeler için KDV Imported from BI Publisher Description: German VAT for On-Account Receipts Report Application: Avrupa Yerelleştirmeleri Source: Almanya Hesaba Mahsuben Ödemeler için KDV Short Name: JEDEDVOR_XMLP DB package: JG_ZZ_SUMMARY_AR_PKG US JE German VAT for On-Account Receipts Imported from BI Publisher Description: German VAT for On-Account Receipts Report Application: European Localizations Source: German VAT for On-Account Receipts Short Name: JEDEDVOR_XMLP DB package: JG_ZZ_SUMMARY_AR_PKG BI Publisher :g_precision :g_vat_agg_limit :p_callingreport :p_chart_of_acc_id :p_company :p_debug_switch :p_ex_vat_trx_type :p_gl_period_end_date :p_gl_period_start_date :p_ledger_id :p_legal_entity_id :p_period :p_reporting_level :p_tax :p_tax_code :p_tax_jurisdiction_code :p_tax_rate_id :p_tax_regime_code :p_tax_status_code :p_tax_status_id :p_trx_status :p_vat_rep_entity_id :p_vat_trx_type 1 -20 :p_chart_of_acc_id LOV Oracle JG_ZZ_VAT_COA_ID Y select chart_of_accounts_id id, chart_of_accounts_id value, null description from gl_sets_of_books where set_of_books_id=fnd_profile.value('GL_SET_OF_BKS_ID') order by value,description SELECT CHART_OF_ACCOUNTS_ID FROM GL_LEDGERS WHERE LEDGER_ID =:$flex$.ledger AR معرف دليل الحسابات معرف دليل الحسابات D Kontenplankennung Kontenplankennung E Id Plan de Cuentas Id Plan de Cuentas F ID plan de comptes ID plan de comptes I ID del piano dei conti ID del piano dei conti RU Идент. плана счетов Идент. плана счетов S Kontoplans-id Kontoplans-id TR Hesap Planı No Hesap Planı No US Chart of Accounts ID Chart of Accounts ID 2 -10 :p_callingreport Char JEDEDVOR AR طلب التقرير طلب التقرير D Aufrufende Auswertung Aufrufende Auswertung E Informe Que Solicita los Datos Informe Que Solicita los Datos F Etat appelant Etat appelant I Rapporto chiamante Rapporto chiamante RU Отчет вызова Отчет вызова S Anropar rapport Anropar rapport US Calling Report Calling Report 3 10 :p_reporting_level LOV Oracle JGZZ_VAT_ENTITY_LEVEL Y select lookup_code id, meaning value, description description from fnd_lookup_values where lookup_type='JG_ZZ_VAT_ENTITY_LEVEL' and enabled_flag='Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) and language=userenv('LANG') order by value,description Y AR مستوى إعداد التقرير مستوى إعداد التقرير. القيم المتاحة هي LE وLEDGER وBSV D Auswertungsebene Auswertungsebene. Verfügbare Werte: LE, LEDGER, BSV. E Nivel de Informe Nivel de informe - Los valores disponibles son: entidad jurídica, libro mayor, valor de segmento de balance. F Niveau de déclaration Niveau de déclaration. Les valeurs disponibles sont Entité juridique, Livre, Valeur de segment d'équilibrage. I Livello rapporti Livello di dichiarazione. I valori disponibili sono LE, LEDGER, BSV. RU Уровень отчетности Уровень отчетности. Возможные значения: LE, LEDGER, BSV. S Rapporteringsnivå Rapporteringsnivå. Tillgängliga värden är LE, LEDGER, BSV. TR Raporlama Düzeyi Raporlama Düzeyi. Kullanılabilir değerler: LE, LEDGER, BSV. US Reporting Level Reporting Level. Available values are LE, LEDGER, BSV. 4 20 :p_legal_entity_id LOV Oracle XLE_FIRSTPARTY Y select legal_entity_id id, name value, legal_entity_identifier description from xle_entity_profiles where transacting_entity_flag='Y' order by value,description Y AR الكيان القانوني الكيان القانوني D Mandant Mandant E Entidad Jurídica Entidad Jurídica F Entité juridique Entité juridique I Persona giuridica Persona giuridica RU Юридическое лицо Юридическое лицо S Juridisk enhet Juridisk enhet TR Tüzel Kişilik Tüzel Kişilik US Legal Entity Legal Entity 5 30 :p_ledger_id LOV Oracle JGZZ_SRS_LEDGER_NAME Y select l.ledger_id id, l.name value, l.description description from gl_access_set_ledgers ac,gl_ledgers_public_v l where ac.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and l.ledger_id=ac.ledger_id order by name AR دفتر الأستاذ دفتر الأستاذ D Buch Buch E Libro Mayor Libro Mayor F Livre Livre I Libro contabile Libro contabile RU Книга Книга S Huvudbok Huvudbok US Ledger Ledger 6 40 :p_company Char AR مقطع الترصيد مقطع الترصيد D Buchungskreis Buchungskreis E Segmento de Balance Segmento de Balance F Segment d'équilibrage Segment d'équilibrage I Segmento di quadratura Segmento di quadratura RU Балансирующий сегмент Балансирующий сегмент S Balanssegment Balanssegment TR Dengeleme Segmenti Dengeleme Segmenti US Balancing Segment Balancing Segment 7 50 :p_tax_regime_code LOV Oracle JG_ZZ_TAX_REGIME_CODE Y select tax_regime_code id, tax_regime_code value, tax_regime_name description from zx_regimes_vl where has_sub_regime_flag='N' order by value,description AR رمز النظام رمز النظام D Schlüssel Steuersystem Schlüssel Steuersystem E Código de Régimen Código de Régimen F Code régime Code régime I Codice regime Codice regime RU Код режима Код режима S Förvaltningskod Förvaltningskod US Regime Code Regime Code 8 60 :p_tax LOV Oracle JG_ZZ_TAXES Y select tax id, tax value, tax_full_name description from zx_taxes_vl where tax_regime_code=:$flex$.jg_zz_tax_regime_code order by value,description AR الضريبة الضريبة D Steuer Steuer E Impuesto Impuesto F Taxe Taxe I Imposta Imposta RU Налог Налог S Skatt Skatt US Tax Tax 9 70 :p_tax_status_code LOV Oracle JG_ZZ_TAX_STATUS_CODE Y select tax_status_code id, tax_status_code value, tax_status_name description from zx_status_vl where tax_regime_code=:$flex$.jg_zz_tax_regime_code and tax=:$flex$.jg_zz_taxes order by value,description AR موقف الضريبة موقف الضريبة D Steuerstatus Steuerstatus E Estado Fiscal Estado Fiscal F Statut fiscal Statut fiscal I Stato imposta Stato imposta RU Налоговый статус Налоговый статус S Skattestatus Skattestatus US Tax Status Tax Status 10 80 :p_tax_jurisdiction_code LOV Oracle JG_ZZ_TAX_JURISDICTION Y select tax_jurisdiction_code id, tax_jurisdiction_code value, tax_jurisdiction_name description from zx_jurisdictions_vl where tax_regime_code=:$flex$.jg_zz_tax_regime_code and tax=:$flex$.jg_zz_taxes order by value,description AR جهة الاختصاص جهة الاختصاص D Steuerzuständigkeit Steuerzuständigkeit E Jurisdicción Jurisdicción F Juridiction Juridiction I Giurisdizione Giurisdizione RU Юрисдикция Юрисдикция S Jurisdiktion Jurisdiktion US Jurisdiction Jurisdiction 11 90 :p_tax_rate_id LOV Oracle JG_ZZ_TAX_RATE_CODE Y select tax_rate_id id, tax_rate_code value, tax_rate_name description from zx_rates_vl where tax_regime_code=:$flex$.jg_zz_tax_regime_code and tax=:$flex$.jg_zz_taxes and tax_status_code=:$flex$.jg_zz_tax_status_code and active_flag='Y' and (tax_jurisdiction_code is null or tax_jurisdiction_code=nvl(:$flex$.jg_zz_tax_jurisdiction:null, tax_jurisdiction_code)) order by value,description AR معدل الضريبة معدل الضريبة D Steuersatz Steuersatz E Tipo Impositivo Tipo Impositivo F Taux de taxe Taux de taxe I Aliquota Aliquota RU Налоговая ставка Налоговая ставка S Skattesats Skattesats TR Vergi Oranı Vergi Oranı US Tax Rate Tax Rate 12 100 :p_gl_period_start_date Date AR تاريخ بداية أ/ع تاريخ بداية أ/ع D Von Buchungsdatum Von Buchungsdatum E Fecha Contable de Inicio Fecha Contable de Inicio F Date de début GL Date de début GL I Data inizio GL Data inizio GL RU Дата ГК с Дата ГК с S Från bokföringsdatum Från bokföringsdatum TR GL Başlangıç Tarihi GL Başlangıç Tarihi US GL Start Date GL Start Date 13 110 :p_gl_period_end_date Date AR تاريخ نهاية أ/ع تاريخ نهاية أ/ع D Bis Buchungsdatum Bis Buchungsdatum E Fecha Contable de Finalización Fecha Contable de Finalización F Date de fin GL Date de fin GL I Data fine GL Data fine GL RU Дата ГК по Дата ГК по S Sista bokföringsdatum Sista bokföringsdatum TR GL Bitiş Tarihi GL Bitiş Tarihi US GL End Date GL End Date