ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F14E3869E053B46B63588994 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 Y JG JGZZSUMMARYAR_XMLP AR JG ضريبة القيمة المضافة لـ EMEA: استخراج إجمالي حساب المقبوضات Application: المحليات الأقليمية Source: ضريبة القيمة المضافة لـ EMEA: استخراج إجمالي حساب المقبوضات Short Name: JGZZSUMMARYAR_XMLP DB package: JG_ZZ_SUMMARY_AR_PKG D JG EMEA USt: DE-Übersichtsdatenauszug Application: Regionale Lokalisierungen Source: EMEA USt: DE-Übersichtsdatenauszug Short Name: JGZZSUMMARYAR_XMLP DB package: JG_ZZ_SUMMARY_AR_PKG F JG EMEA - TVA : Synthèse - AR : Extraction Application: Regional Localizations Source: EMEA - TVA : Synthèse - AR : Extraction Short Name: JGZZSUMMARYAR_XMLP DB package: JG_ZZ_SUMMARY_AR_PKG US JG EMEA VAT: Summary AR Extract Application: Regional Localizations Source: EMEA VAT: Summary AR Extract Short Name: JGZZSUMMARYAR_XMLP DB package: JG_ZZ_SUMMARY_AR_PKG ZHS JG EMEA 增值税：汇总 AR 提取 Application: 区域性本地化 Source: EMEA 增值税：汇总 AR 提取 Short Name: JGZZSUMMARYAR_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 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 F Identifiant de reporting US Reporting Identifier ZHS 申报标识 2 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 Steuerkalenderperiode F Période du calendrier fiscal US Tax Calendar Period ZHS 纳税日历期间 :$flex$.jgzz_vat_reporting_entity_id Reporting Identifier Tax Calendar Period