ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1513869E053B46B63588994Y SELECT jgvtd.trx_id trx_id ,jgvtd.trx_number trx_number ,jgvtd.tax_rate_code tax_rate_code ,jgvtd.tax_rate_code_description tax_rate_code_description ,jgvtd.tax_rate tax_rate ,jgvtd.tax_rate_register_type_code tax_rate_register_type_code ,jgvtd.trx_class_mng trx_class_mng ,jgvtd.tax_recovery_rate tax_recovery_rate ,jgvtd.offset_tax_rate_code offset_tax_rate_code ,jgvrs.source source ,jgvtd.tax_type_code tax_type_code ,decode(jgvtd.extract_source_ledger,'AP',decode(jgvtd.tax_amt_included_flag,'N',jgvtd.orig_taxable_amt_tax_curr,jgvtd.TAXABLE_AMT_FUNCL_CURR), jgvtd.taxable_amt_funcl_curr) taxable_amt_funcl_curr ,jgvtd.tax_amt_funcl_curr tax_amt_funcl_curr ,decode(jgvtd.tax_recoverable_flag, 'Y', (decode(jgvtd.tax_amt_included_flag,'N',jgvtd.orig_taxable_amt_tax_curr,jgvtd.TAXABLE_AMT_FUNCL_CURR) * jgvtd.tax_recovery_rate/100),0) taxable_rec ,decode(jgvtd.tax_recoverable_flag, 'N', (decode(jgvtd.tax_amt_included_flag,'N',jgvtd.orig_taxable_amt_tax_curr,jgvtd.TAXABLE_AMT_FUNCL_CURR) * jgvtd.tax_recovery_rate/100),0) taxable_non_rec ,decode(jgvtd.tax_type_code, 'I', decode(jgvtd.tax_amt_included_flag,'N',jgvtd.orig_taxable_amt_tax_curr,jgvtd.TAXABLE_AMT_FUNCL_CURR),0) taxable_debit ,decode(jgvtd.tax_type_code, 'O', decode(jgvtd.tax_amt_included_flag,'N',jgvtd.orig_taxable_amt_tax_curr,jgvtd.TAXABLE_AMT_FUNCL_CURR),0) taxable_credit ,decode(jgvtd.tax_recoverable_flag, 'Y', jgvtd.tax_amt_funcl_curr,0) tax_rec ,decode(jgvtd.tax_recoverable_flag, 'N', jgvtd.tax_amt_funcl_curr,0) tax_non_rec ,decode(jgvtd.tax_type_code, 'I', jgvtd.tax_amt_funcl_curr,0) tax_debit ,decode(jgvtd.tax_type_code, 'O', jgvtd.tax_amt_funcl_curr,0) tax_credit ,jgvtd.nrec_tax_amt_tax_curr nrec_tax_amt_tax_curr ,jgvtd.tax_rate_vat_trx_type_desc tax_rate_vat_trx_type_desc ,jgvtd.reporting_code reporting_code ,jgvtd.functional_currency_code functional_currency_code ,jgvtd.tax_recoverable_flag tax_recoverable_flag ,jgvrs.tax_calendar_period tax_calendar_period ,jgvtd.application_id application_id ,FND_PROFILE.value('JEIT_EXEMPT_TAX_TAG') exempt_value ,glp.period_num period_num FROM jg_zz_vat_trx_details jgvtd ,jg_zz_vat_rep_entities jgvre ,jg_zz_vat_rep_status jgvrs ,gl_periods glp WHERE jgvrs.reporting_status_id = jgvtd.reporting_status_id (+) AND jgvrs.vat_reporting_entity_id = jgvre.VAT_REPORTING_ENTITY_ID AND jgvre.vat_reporting_entity_id = :P_REPORTING_ENTITY_ID AND jgvrs.final_reporting_status_flag = 'S' AND jgvrs.tax_calendar_year = glp.period_year AND jgvrs.tax_calendar_name = glp.period_set_name AND jgvrs.tax_calendar_period = glp.period_name AND jgvrs.tax_calendar_year = :P_TAX_CALENDAR_YEAR ORDER BY jgvtd.application_id DESC NULLS LAST JG JGZZYEXR AR JG EMEA VAT: تقرير الاستخراج السنوي Application: المحليات الأقليمية Source: EMEA VAT: تقرير الاستخراج السنوي Short Name: JGZZYEXR DB package: JG_ZZ_VAT_YEARLY_EXT_PKG D JG EMEA USt: Jährlicher Datenauszug Application: Regionale Lokalisierungen Source: EMEA USt: Jährlicher Datenauszug Short Name: JGZZYEXR DB package: JG_ZZ_VAT_YEARLY_EXT_PKG F JG EMEA - TVA : Etat d'extraction annuel Application: Regional Localizations Source: EMEA - TVA : Etat d'extraction annuel Short Name: JGZZYEXR DB package: JG_ZZ_VAT_YEARLY_EXT_PKG US JG EMEA VAT: Yearly Extract Application: Regional Localizations Source: EMEA VAT: Yearly Extract Report Short Name: JGZZYEXR DB package: JG_ZZ_VAT_YEARLY_EXT_PKG ZHS JG EMEA 增值税：年度提取报表 Application: 区域性本地化 Source: EMEA 增值税：年度提取报表 Short Name: JGZZYEXR DB package: JG_ZZ_VAT_YEARLY_EXT_PKG BI Publisher :gn_return_code :p_level :p_reporting_entity_id :p_tax_calendar_year 1 10 :p_reporting_entity_id LOV Oracle JGZZ_VAT_ENTITY_ID Y select jvre.vat_reporting_entity_id id, jvre.entity_identifier value, null description from jg_zz_vat_rep_entities jvre where jvre.vat_reporting_entity_id in (select jvrein.vat_reporting_entity_id from jg_zz_vat_rep_entities jvrein,gl_access_set_assignments gasa,gl_ledger_config_details glcd,gl_ledgers gl where jvrein.legal_entity_id=glcd.object_id and glcd.configuration_id=gl.configuration_id and gl.ledger_id=gasa.ledger_id and gasa.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') union select jvre.vat_reporting_entity_id from jg_zz_vat_rep_entities jvre,gl_access_set_assignments gasa where jvre.ledger_id=gasa.ledger_id and gasa.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and jvre.legal_entity_id is null union (select jvre2.mapping_vat_rep_entity_id from jg_zz_vat_rep_entities jvre2, gl_access_set_assignments gasa where jvre2.ledger_id=gasa.ledger_id and gasa.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID'))) order by value,description Y AR معرف إعداد التقرير D Kennung Steuerpflichtiger F Identifiant de reporting US Reporting Identifier ZHS 申报标识 2 20 :p_tax_calendar_year LOV Oracle JGZZ_VAT_TAX_CALENDAR_YEAR Y select jvrs.tax_calendar_year id, jvrs.tax_calendar_year value, null description from (select distinct tax_calendar_year,vat_reporting_entity_id from jg_zz_vat_rep_status) jvrs where jvrs.vat_reporting_entity_id=:$flex$.jgzz_vat_entity_id order by value,description Y AR سنة تقويم ضريبة VAT D USt.-Kalenderjahr F Année du calendrier de TVA US VAT Calendar Year ZHS 增值税日历年度 3 30 :p_level LOV Oracle JGZZ_VAT_DETAIL_SUMMARY Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='JGZZ_DETAIL_SUMMARY' and lookup_code in ('DETAIL','SUMMARY') order by value,description SELECT meaning FROM fnd_lookups WHERE lookup_type = 'JGZZ_DETAIL_SUMMARY' AND lookup_code = 'DETAIL' Y AR طور تقديم التقرير D Auswertungsausführungsmodus F Mode de lancement de l'édition US Report Submission Mode ZHS 报表提交模式