ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4705151A9E05362FB09050512Y SELECT JG.account_description ACCOUNT_DESCRIPTION , JG.account_flexfield ACCOUNT , JG.accounting_date GL_DATE , JG.applied_to_trx_number APPLIED_TO_TRX_NUMBER , JG.billing_tp_name VENDOR_NAME , JG.billing_tp_number VENDOR_NUMBER , JG.cancel_flag TRX_CANCEL_FLAG , JG.cancelled_date TRX_CANCELLED_DATE , JG.currency_conversion_rate EXCHANGE_RATE , JG.doc_seq_name DOCUMENT_SEQ_NAME , JG.doc_seq_value DOCUMENT_SEQ_VALUE , JG.event_class_code EVENT_CLASS_CODE , JG.extract_source_ledger EXTRACT_SOURCE_LEDGER , JG.extract_source_ledger SOURCE_LEDGER , JG.legal_contact_party_name CONTACT_NAME , JG.offset_flag TAX_OFFSET_FLAG , JG.posted_flag POSTED_FLAG , JG.rep_context_entity_location_id LE_LOCATION_ID , JG.rep_context_entity_name LEGAL_ENTITY_NAME , JG.tax_amt TAX_AMOUNT , JG.tax_amt_funcl_curr TAX_AMOUNT_FUNCL_CURR , JG.tax_rate TAX_RATE , JG.tax_rate_code TAX_CODE_RATE , JG.tax_rate_vat_trx_type_code TAX_RATE_VAT_TRX_TYPE_CODE , JG.tax_rate_vat_trx_type_desc TAX_RATE_VAT_TRX_TYPE_DESC , JG.tax_recoverable_flag TAX_RECOVERABLE_FLAG , JG.tax_recovery_rate TAX_RECV_RATE , JG.tax_type_code TAX_TYPE_CODE , JG.tax_type_mng TAX_TYPE_MEANING , JG.taxable_amt TAXABLE_AMOUNT , JG.taxable_amt_funcl_curr TAXABLE_AMT_FUNCL_CURR , JG.trx_id TRANSACTION_ID , JG.trx_line_class TAX_CLASS , JG.trx_line_id TRX_LINE_ID , JG.trx_line_number LINE_NUMBER , JG.trx_number INVOICE , JZVRS.period_end_date PERIOD_END_DATE , JZVRS.period_start_date PERIOD_START_DATE , JZVRS.tax_calendar_name PERIOD_NAME , JZVRS.tax_calendar_year PERIOD_YEAR , JZVRS.tax_registration_number LE_TAX_REGISTRATION_NUMBER FROM jg_zz_vat_trx_details JG ,jg_zz_vat_rep_status JZVRS ,ra_cust_trx_types RTT WHERE :P_REPORT_NAME IS NULL AND JZVRS.vat_reporting_entity_id = :P_VAT_REP_ENTITY_ID AND JZVRS.tax_calendar_year = :P_PERIOD AND JZVRS.source = 'AR' AND JG.reporting_status_id = JZVRS.reporting_status_id AND RTT.cust_trx_type_id = JG.trx_type_id AND RTT.TYPE IN ('INV','CM','DM') JE JEBEVA24_XMLP AR JE تقرير عائد سنوي لضريبة قيمة مضافة في بلجيكا Imported from BI Publisher Application: المحليات الأوروبية Source: تقرير عائد سنوي لضريبة قيمة مضافة في بلجيكا Short Name: JEBEVA24_XMLP DB package: jg_zz_turnover_ar_pkg D JE Belgische USt. - Jährliche Erklärung Imported from BI Publisher Application: Europäische Lokalisierungen Source: Belgische USt. - Jährliche Erklärung Short Name: JEBEVA24_XMLP DB package: jg_zz_turnover_ar_pkg E JE Bélgica - Devolución de IVA. Anual Imported from BI Publisher Application: Localizaciones Europeas Source: Bélgica - Devolución de IVA. Anual Short Name: JEBEVA24_XMLP DB package: jg_zz_turnover_ar_pkg F JE Belgique - Etat de déclaration annuelle de TVA Imported from BI Publisher Application: European Localizations Source: Belgique - Etat de déclaration annuelle de TVA Short Name: JEBEVA24_XMLP DB package: jg_zz_turnover_ar_pkg I JE Belgio - rapporto Rimborso annuale IVA Imported from BI Publisher Application: European Localizations Source: Belgio - rapporto Rimborso annuale IVA Short Name: JEBEVA24_XMLP DB package: jg_zz_turnover_ar_pkg RU JE Годовой отчет о возврате НДС (Бельгия) Imported from BI Publisher Application: Версии для Европы Source: Годовой отчет о возврате НДС (Бельгия) Short Name: JEBEVA24_XMLP DB package: jg_zz_turnover_ar_pkg S JE Årlig deklaration av belgisk moms - rapport Imported from BI Publisher Application: European Localizations Source: Årlig deklaration av belgisk moms - rapport Short Name: JEBEVA24_XMLP DB package: jg_zz_turnover_ar_pkg TR JE Belgian VAT Annual Return Imported from BI Publisher Application: Avrupa Yerelleştirmeleri Source: Belgian VAT Annual Return Report Short Name: JEBEVA24_XMLP DB package: jg_zz_turnover_ar_pkg US JE Belgian VAT Annual Return Imported from BI Publisher Application: European Localizations Source: Belgian VAT Annual Return Report Short Name: JEBEVA24_XMLP DB package: jg_zz_turnover_ar_pkg BI Publisher :p_debug_flag :p_declarant_type :p_err_code :p_min_amount :p_period :p_report_name :p_vat_rep_entity_id 1 -10 :p_report_name Char JEBEVA24 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 2 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 3 20 :p_period LOV Oracle JGZZ_TAX_CALENDAR_YEAR_ENTITY Y select rps.tax_calendar_year id, rps.tax_calendar_year 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_year) order by value,description Y AR سنة تقويم الضريبة سنة تقويم الضريبة D Steuerkalenderjahr Steuerkalenderjahr E Año de Calendario Fiscal Año de Calendario Fiscal F Année du calendrier fiscal Année du calendrier fiscal I Anno calendario fiscale Anno calendario fiscale RU Налоговый календарный год Налоговый календарный год S Skattekalenderår Skattekalenderår US Tax Calender Year Tax Calender Year 4 30 :p_min_amount Number select THRESHOLD_AMOUNT from jg_zz_vat_rep_entities where vat_reporting_entity_id IN (select nvl(mapping_vat_rep_entity_id, vat_reporting_entity_id) from jg_zz_vat_rep_entities where vat_reporting_entity_id = :$flex$.reporting_identifier) Y AR الحد الأدنى لقيمة الحركة الحد الأدنى لقيمة الحركة D Mindest-Transaktionswert Mindest-Transaktionswert E Valor Mínimo de Transacción Valor Mínimo de Transacción F Valeur mouvement minimum Valeur mouvement minimum I Valore minimo transazione Valore minimo transazione RU Минимальное значение транзакции Минимальное значение транзакции S Lägsta transaktionsvärde Lägsta transaktionsvärde US Minimum Transaction Value Minimum Transaction Value 5 40 :p_declarant_type LOV Oracle JEBE_DECLARANT_TYPE Y select lookup_code id, lookup_code value, meaning description from fnd_lookups where lookup_type='JEBE_DECLARANT_TYPE' and nvl(start_date_active,sysdate)<=sysdate and nvl(end_date_active,sysdate)>=sysdate and enabled_flag='Y' order by lookup_code AR نوع الإقرار نوع الإقرار D Art Meldepflichtiger Art Meldepflichtiger E Tipo de Declarante Tipo de Declarante F Type de déclarant Type de déclarant I Tipo di dichiarante Tipo di dichiarante RU Тип заявителя Тип заявителя S Typ av deklarant Typ av deklarant TR Beyanname Sahibi Tipi Beyanname Sahibi Tipi US Declarant Type Declarant Type