ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1363869E053B46B63588994 select 1 dummyForCount -- dummy column to count the number of records fetched by query , brathod , jzvtd.extract_source_ledger source , jzvtd.doc_seq_name , jzvtd.doc_seq_value , jzvtd.billing_tp_name , jzvtd.trx_number , jzvtd.trx_line_number , jzvtd.trx_line_amt , jzvtd.accounting_date , jzvtd.posted_flag , substr(jzvbe.allocation_error_code,7) allocation_error_code , jzvbe.period_type --, null financial_document_type -- jzvar.financial_document_type , JG_ZZ_AERL_DT_PKG.get_financial_document_type(jzvtd.trx_id , jzvtd.trx_type_id , jzvrs.source , jzvtd.entity_code ) financial_document_type , jzvtd.tax_rate_vat_trx_type_code vat_transaction_type --jzvar.vat_transaction_type , jzvtd.tax tax_code -- jzvar.tax_code , jzvtd.tax_status_code tax_status -- jzvar.tax_status , jzvtd.tax_jurisdiction_code --jzvar.tax_jurisdiction_code , jzvtd.tax_rate_id --jzvar.tax_rate_id , jzvtd.tax_rate_code -- jzvar.tax_rate_code , jzvrs.tax_calendar_period , jzvrs.tax_registration_number , jzvre.entity_identifier , JG_ZZ_AERL_DT_PKG.cf_batch_name(jzvtd.trx_id, jzvtd.extract_source_ledger) cf_batch_name ,nvl(jzvtd.self_assessed_flag,'N') self_assessed_flag from /* jg_zz_vat_alloc_rules jzvar , ra_batches rabatch , */ jg_zz_vat_box_errors jzvbe , jg_zz_vat_rep_status jzvrs , jg_zz_vat_trx_details jzvtd , jg_zz_vat_rep_entities jzvre where jzvbe.vat_transaction_id = jzvtd.vat_transaction_id and jzvrs.reporting_status_id = jzvtd.reporting_status_id and jzvre.vat_reporting_entity_id = jzvrs.vat_reporting_entity_id /* this piece of filtering is commented because rules table is removed in the FROM CLAUSE and ((jzvre.entity_type_code = 'ACCOUNTING' and jzvre.mapping_vat_rep_entity_id = jzvar.vat_reporting_entity_id) OR (jzvre.entity_type_code = 'LEGAL' and jzvre.vat_reporting_entity_id = jzvar.vat_reporting_entity_id)) */ and jzvrs.vat_reporting_entity_id = :p_vat_reporting_entity_id and jzvrs.tax_calendar_period = :P_PERIOD_NAME and ((:P_SOURCE = 'ALL') or (jzvrs.source = nvl(:P_SOURCE, jzvrs.source))) and jzvbe.allocation_error_code is not null Y JG JGZZAERL AR JG ضريبة القيمة المضافة لـ EMEA: قائمة أخطاء التخصيص Application: المحليات الأقليمية Source: ضريبة القيمة المضافة لـ EMEA: قائمة أخطاء التخصيص Short Name: JGZZAERL DB package: JG_ZZ_AERL_DT_PKG D JG EMEA USt - Umlagefehler Application: Regionale Lokalisierungen Source: EMEA USt - Umlagefehler Short Name: JGZZAERL DB package: JG_ZZ_AERL_DT_PKG F JG EMEA - TVA : Liste des erreurs de répartition Application: Regional Localizations Source: EMEA - TVA : Liste des erreurs de répartition Short Name: JGZZAERL DB package: JG_ZZ_AERL_DT_PKG US JG EMEA VAT: Allocation Errors Listing Application: Regional Localizations Source: EMEA VAT: Allocation Errors Listing Short Name: JGZZAERL DB package: JG_ZZ_AERL_DT_PKG ZHS JG EMEA 增值税：分摊错误列表 Application: 区域性本地化 Source: EMEA 增值税：分摊错误列表 Short Name: JGZZAERL DB package: JG_ZZ_AERL_DT_PKG BI Publisher :p_period_name :p_source :p_vat_reporting_entity_id 1 10 :p_vat_reporting_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_name 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 Periodenbezeichnung F Nom de la période US Period Name ZHS 期间名称 3 30 :p_source LOV Oracle JGZZ_VAT_SOURCES Y select lookup_code id, lookup_code value, meaning description from fnd_lookup_values where lookup_type='JGZZ_SOURCE' 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 AR المصدر D Herkunft F Origine US Source ZHS 来源 :$flex$.jgzz_vat_reporting_entity_id Reporting Identifier Period Name