ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4705D51A9E05362FB09050512Y SELECT JZVTD.rep_context_entity_name LEGAL_ENTITY_NAME ,JZVTD.rep_context_entity_location_id LE_LOCATION_ID ,HLA.address_line_1 ADDRESS1 ,HLA.address_line_2 ADDRESS2 ,HLA.address_line_3 ADDRESS3 ,HLA.town_or_city CITY ,HLA.postal_code POSTAL_CODE ,HLA.telephone_number_1 TELEPHONE ,JZVRS.tax_registration_number LE_TAX_REGISTRATION_NUMBER ,JZVTD.legal_contact_party_name CONTACT_NAME ,JZVRS.tax_calendar_year TAX_PERIOD_YEAR ,JZVRS.tax_calendar_period TAX_PERIOD_NAME ,to_char(JZVRS.period_start_date,'DD-Mon-RRRR') PERIOD_START_DATE ,to_char(JZVRS.period_end_date,'DD-Mon-RRRR') PERIOD_END_DATE ,JZVTD.extract_source_ledger EXTRACT_SOURCE_LEDGER ,JZVTD.event_class_code EVENT_CLASS_CODE ,JZVTD.period_name GL_PERIOD_NAME ,JZVTD.doc_seq_name DOC_SEQUENCE_NAME ,JZVTD.doc_seq_value DOC_SEQUENCE_NUMBER ,to_char(JZVTD.trx_date,'DD-Mon-RRRR') INVOICE_DATE ,JZVTD.billing_tp_party_number CUSTOMER_NUMBER ,JZVTD.billing_tp_taxpayer_id CUSTOMER_TAX_PAYER_ID ,JZVTD.billing_tp_site_name CUSTOMER_SITE_NAME ,JZVTD.billing_tp_name CUSTOMER_NAME ,JZVTD.billing_tp_tax_reg_num CUST_BILL_TAX_REG_NUM ,JZVTD.shipping_tp_tax_reg_num CUST_SHIP_AX_REG_NUM ,JZVTD.billing_tp_site_tax_reg_num CUST_SITE_BILL_TAX_REG_NUM ,JZVTD.shipping_tp_site_tax_reg_num CUST_SITE_SHIP_TAX_REG_NUM ,JZVTD.trx_number INVOICE_NUMBER ,NVL(JZVTD.taxable_amt,0) TAXABLE_AMT ,NVL(JZVTD.tax_amt,0) TAX_AMOUNT ,NVL(JZVTD.taxable_amt_funcl_curr,0) TAXABLE_AMT_FUNCL_CURR ,NVL(JZVTD.tax_amt_funcl_curr,0) TAX_AMOUNT_FUNCL_CURR ,JZVTD.trx_id TRX_ID ,to_char(JZVTD.cancelled_date,'DD-Mon-RRRR') TRX_CANCELLED_DATE ,JZVTD.cancel_flag TRX_CANCEL_FLAG ,JZVTD.offset_flag TAX_OFFSET_FLAG ,JZVTD.posted_flag POSTED_FLAG ,JZVTD.tax_recoverable_flag TAX_RECOVERABLE_FLAG ,JZVTD.account_flexfield ACCOUNT ,JZVTD.account_description ACCOUNT_DESCRIPTION ,JZVTD.trx_line_number LINE_NUMBER ,JZVTD.tax_type_code TAX_TYPE_CODE ,JZVTD.tax_type_mng TAX_TYPE_MEANING ,JZVTD.tax_rate TAX_RATE ,JZVTD.tax_rate_code TAX_RATE_CODE ,JZVTD.tax_rate_vat_trx_type_code TAX_RATE_VAT_TRX_TYPE_CODE ,JZVTD.tax_rate_vat_trx_type_desc TAX_RATE_VAT_TRX_TYPE_DESC ,JZVBA.taxable_box TAXABLE_REPORT_BOX ,JZVBA.tax_box TAX_REPORT_BOX ,to_char(JZVTD.accounting_date,'DD-Mon-RRRR') GL_DATE ,JZVTD.applied_to_trx_number APPLIED_TO_TRX_NUMBER ,VAT_REGISTERS.register_type VAT_REGISTER_TYPE ,VAT_REGISTERS.register_name VAT_REGISTER_NAME ,VAT_REGISTERS.db_sequence_name VAT_DOC_SEQ_NAME ,XEP.name REPORTER ,JZVTD.tax_rate_code_description TAX_RATE_DESCRIPTION ,JZVTD.trx_line_id TRX_LINE_ID FROM jg_zz_vat_trx_details JZVTD ,jg_zz_vat_rep_status JZVRS ,jg_zz_vat_box_allocs JZVBA ,hr_locations_all HLA ,xle_entity_profiles XEP ,(SELECT JZVRV.vat_reporting_entity_id vat_reporting_entity_id ,JZVRV.vat_register_id vat_register_id ,JZVRV.register_type register_type ,JZVRV.register_name register_name ,FDS.db_sequence_name db_sequence_name ,DOC_SEQ.doc_sequence_id doc_sequence_id FROM jg_zz_vat_registers_vl JZVRV ,jg_zz_vat_doc_sequences DOC_SEQ ,fnd_document_sequences FDS WHERE JZVRV.vat_register_id = DOC_SEQ.vat_register_id AND FDS.doc_sequence_id = DOC_SEQ.doc_sequence_id ) VAT_REGISTERS WHERE JZVRS.reporting_status_id = JZVTD.reporting_status_id AND JZVTD.vat_transaction_id = JZVBA.vat_transaction_id(+) /* AND VAT_REGISTERS.vat_reporting_entity_id (+)= JZVRS.mapping_vat_rep_entity_id */ AND VAT_REGISTERS.doc_sequence_id (+) = JZVTD.doc_seq_id AND JZVTD.rep_context_entity_location_id = HLA.location_id AND JZVTD.rep_entity_id = XEP.legal_entity_id AND JZVRS.source = 'AR' AND JZVRS.tax_calendar_period = :P_PERIOD AND JZVRS.vat_reporting_entity_id = :P_VAT_REP_ENTITY_ID AND :P_REPORT_NAME is NULL JE JEESRRVR_XMLP AR JE تقرير يومية ضريبة القيمة المضافة للمخرجات في أسبانيا Imported from BI Publisher Description: تقرير ضريبة القيمة المضافة المستلمة الأسبانية Application: المحليات الأوروبية Source: تقرير يومية ضريبة القيمة المضافة للمخرجات في أسبانيا Short Name: JEESRRVR_XMLP DB package: jg_zz_journal_ar_pkg D JE Umsatzsteuerjournal Imported from BI Publisher Description: Spanien: Erhaltene USt Application: Europäische Lokalisierungen Source: Spanien: Umsatzsteuerjournal Short Name: JEESRRVR_XMLP DB package: jg_zz_journal_ar_pkg E JE España - IVA Repercutido Imported from BI Publisher Description: España - Informe IVA Repercutido Application: Localizaciones Europeas Source: España - IVA Repercutido Short Name: JEESRRVR_XMLP DB package: jg_zz_journal_ar_pkg F JE Espagne - Journal de TVA sur les ventes Imported from BI Publisher Description: Espagne - Etat de la TVA collectée Application: European Localizations Source: Espagne - Journal de TVA sur les ventes Short Name: JEESRRVR_XMLP DB package: jg_zz_journal_ar_pkg I JE Spagna - rapporto Scritture contabili IVA a debito Imported from BI Publisher Description: Rapporto IVA ricevuta (Spagna) Application: European Localizations Source: Spagna - rapporto Scritture contabili IVA a debito Short Name: JEESRRVR_XMLP DB package: jg_zz_journal_ar_pkg RU JE Отчет по журналу начисленного НДС (Испания) Imported from BI Publisher Description: Отчет о полученном НДС (Испания) Application: Версии для Европы Source: Отчет по журналу начисленного НДС (Испания) Short Name: JEESRRVR_XMLP DB package: jg_zz_journal_ar_pkg S JE Spanska utdata - momsverifikationsrapport Imported from BI Publisher Description: Spansk mottagen moms - rapport Application: European Localizations Source: Spanska utdata - momsverifikationsrapport Short Name: JEESRRVR_XMLP DB package: jg_zz_journal_ar_pkg TR JE Spanish Output VAT Journal Imported from BI Publisher Description: İspanya Alınan KDV Raporu Application: Avrupa Yerelleştirmeleri Source: Spanish Output VAT Journal Report Short Name: JEESRRVR_XMLP DB package: jg_zz_journal_ar_pkg US JE Spanish Output VAT Journal Imported from BI Publisher Description: Spanish VAT Received Report Application: European Localizations Source: Spanish Output VAT Journal Report Short Name: JEESRRVR_XMLP DB package: jg_zz_journal_ar_pkg BI Publisher :g_jeitarsv_prel_alert_1 :g_jeitarsv_prel_alert_2 :g_jeitrdvr_prel_alert_1 :g_jeitrdvr_prel_alert_2 :l_err_msg :p_balancing_segment :p_chart_of_account_id :p_customer_name_from :p_customer_name_to :p_debug_flag :p_detail_summary :p_document_sequence_name_from :p_document_sequence_name_to :p_first_page_num :p_period :p_period_to :p_report_name :p_sequence :p_tax_register_type :p_tax_type :p_vat_register_id :p_vat_rep_entity_id 1 -20 :p_chart_of_account_id LOV Oracle JG_ZZ_VAT_CHART_OF_ACCT_ID Y select chart_of_accounts_id id, chart_of_accounts_id value, null description from gl_ledgers where ledger_id in (select ledger_id from jg_zz_vat_rep_entities where vat_reporting_entity_id=:$flex$.jgzz_vat_reporting_entity_id and entity_level_code in ('LEDGER','BSV') union select ledger_id from gl_ledger_le_v where legal_entity_id=(select legal_entity_id from jg_zz_vat_rep_entities where vat_reporting_entity_id=:$flex$.jgzz_vat_reporting_entity_id and entity_level_code='LE') and ledger_category_code='PRIMARY') order by value,description select chart_of_accounts_id from gl_ledgers where ledger_id in(select ledger_id from jg_zz_vat_rep_entities where vat_reporting_entity_id= :$flex$.reporting_identifier and entity_level_code in ('LEDGER','BSV') Union select ledger_id from gl_ledger_le_v where legal_entity_id = (select legal_entity_id from jg_zz_vat_rep_entities where vat_reporting_entity_id =:$flex$.reporting_identifier and entity_level_code='LE') and ledger_category_code='PRIMARY' ) Y AR معرف دليل الحسابات معرف دليل الحسابات D Kontenplankennung Kontenplankennung E Id Plan de Cuentas Id Plan de Cuentas F ID plan de comptes ID plan de comptes I Id piano dei conti Id piano dei conti RU Идент. плана счетов Идент. плана счетов S Kontoplans-id Kontoplans-id US Chart of Account Id Chart of Account Id 2 -10 :p_report_name Char JEESRRVR 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_vat_rep_entity_id LOV Oracle JGZZ_VAT_REPORTING_ENTITY_ID Y select vat_reporting_entity_id id, entity_identifier value, null description from jg_zz_vat_rep_entities order by value,description Y AR معرف إعداد التقارير معرف إعداد التقارير D Kennung Steuerpflichtiger Kennung Steuerpflichtiger E Identificador de Entidad Fiscal Identificador de Entidad Fiscal F Identifiant d'entité déclarante Identifiant d'entité déclarante I Identificativo soggetto fiscale Identificativo soggetto fiscale RU Идентификатор отчета Идентификатор отчета S Rapporterings-id Rapporterings-id TR Raporlama Tanımlayıcısı Raporlama Tanımlayıcısı US Reporting Identifier Reporting Identifier 4 20 :p_period LOV Oracle JGZZ_TAX_CALENDAR_PERIOD_ENTITY Y select rps.tax_calendar_period id, rps.tax_calendar_period value, null description from jg_zz_vat_rep_status rps where rps.vat_reporting_entity_id=:$flex$.jgzz_vat_reporting_entity_id and rps.rowid in ( select max(rps1.rowid) from jg_zz_vat_rep_status rps1 where rps1.vat_reporting_entity_id=:$flex$.jgzz_vat_reporting_entity_id group by rps1.tax_calendar_period) order by period_start_date Y AR فترة تقويم الضريبة من فترة تقويم الضريبة من D Von Steuerkalenderperiode Von Steuerkalenderperiode E De Período de Calendario Fiscal De Período de Calendario Fiscal F Période du calendrier fiscal - De Période du calendrier fiscal - De I Periodo calendario fiscale -Da Periodo calendario fiscale -Da RU Налоговый календарный период с Налоговый календарный период с S Från skattekalenderperiod Från skattekalenderperiod TR Vergi Takvimi Başlangıç Dönemi Vergi Takvimi Başlangıç Dönemi US Tax Calendar Period From Tax Calendar Period From 5 30 :p_period_to LOV Oracle JGZZ_TAX_CALENDAR_PERIOD_TO Y select rps.tax_calendar_period id, rps.tax_calendar_period value, null description from jg_zz_vat_rep_status rps where rps.vat_reporting_entity_id=:$flex$.jgzz_vat_reporting_entity_id and rps.rowid in ( select max(rps1.rowid) from jg_zz_vat_rep_status rps1 where rps1.vat_reporting_entity_id=:$flex$.jgzz_vat_reporting_entity_id and trunc(rps1.period_start_date)>=(select trunc(min(period_start_date)) from jg_zz_vat_rep_status rps2 where rps2.vat_reporting_entity_id=:$flex$.jgzz_vat_reporting_entity_id and rps2.tax_calendar_period=:$flex$.jgzz_tax_calendar_period_entity) group by rps1.tax_calendar_period) order by period_start_date select :$flex$.tax_calendar_period_from from dual Y AR فترة تقويم الضريبة إلى فترة تقويم الضريبة إلى D Bis Steuerkalenderperiode Bis Steuerkalenderperiode E A Período de Calendario Fiscal A Período de Calendario Fiscal F Période du calendrier fiscal - A Période du calendrier fiscal - A I Periodo calendario fiscale - A Periodo calendario fiscale - A RU Налоговый календарный период по Налоговый календарный период по S Till skattekalenderperiod Till skattekalenderperiod TR Vergi Takvimi Son Dönemi Vergi Takvimi Son Dönemi US Tax Calendar Period To Tax Calendar Period To 6 40 :p_tax_type LOV Oracle JEES_TAX_TYPE Y select reporting_code_char_value id, reporting_code_char_value value, reporting_code_name description from je_es_tax_type_v where nvl(vat_reporting_entity_id,:$flex$.jgzz_vat_reporting_entity_id)=:$flex$.jgzz_vat_reporting_entity_id order by value,description Y AR رمز نوع تقرير الضريبة نوع الضريبة D Schlüssel Steuerauswertungsart Steuerart E Código de Tipo de Declaración de Impuestos Tipo de Impuesto F Code type de déclaration fiscale Type de taxe I Codice tipo di rapporti imposte Tipo di imposta RU Код типа налоговой отчетности Тип налога S Kod för skatterapporteringstyp Skattetyp TR Vergi Raporlama Tipi Kodu Vergi Tipi US Tax Reporting Type Code Tax Type 7 50 :p_tax_register_type LOV Oracle JGZZ_TRL_REGISTER_TYPE Y select lookup_code id, meaning value, null description from fnd_lookup_values where lookup_type='ZX_TRL_REGISTER_TYPE' and lookup_code<>'ALL' 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 نوع المسجل نوع المسجل D Registerart Registerart E Tipo de Registro Tipo de Registro F Type de registre Type de registre I Tipo di registro Tipo di registro RU Тип реестра Тип реестра S Registertyp Registertyp TR Kayıt Tipi Kayıt Tipi US Register Type Register Type 8 60 :p_balancing_segment 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 9 70 :p_sequence LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y' AR تكوين رقم المسلسل تكوين رقم المسلسل D Folgenummern generieren Folgenummern generieren E Generar Número de Secuencia Generar Número de Secuencia F Générer des numéros d'ordre Générer des numéros d'ordre I Genera numero sequenza Genera numero sequenza RU Создать порядковый номер Создать порядковый номер S Generera sekvensnummer Generera sekvensnummer TR Sıra Numarası Oluştur Sıra Numarası Oluştur US Generate Sequence Number Generate Sequence Number