ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4709F51A9E05362FB09050512 SELECT JG.doc_seq_value DOC_SEQUENCE_NUM , JG.tax_rate TAX_RATE , (NVL(JG.tax_amt,0) + NVL(JG.taxable_amt,0)) ENTERED_AMOUNT , (NVL(JG.tax_amt_funcl_curr,0) + NVL(JG.taxable_amt_funcl_curr,0)) ACCOUNTED_AMOUNT , NVL(JG.tax_amt_funcl_curr,0) TAX_FUNC_AMOUNT , NVL(JG.taxable_amt_funcl_curr,0) TAXABLE_AMOUNT , JG.tax_recovery_rate TAX_RECOVERY_RATE /*, DECODE (JG.tax_recoverable_flag ,'Y', JG.tax_amt , NULL) RECOVERY_AMOUNT */ , DECODE(JG.PRL_NO, 'I', DECODE (NVL(JG.tax_recoverable_flag,'Y'), 'Y', JG.tax_amt, 0),0) RECOVERY_AMOUNT --bug 12917786 /* , DECODE (JG.tax_recoverable_flag ,'N',JG.tax_amt , NULL) NON_RECOVERY_AMOUNT*/ , DECODE(JG.PRL_NO, 'I', DECODE (NVL(JG.tax_recoverable_flag,'Y'), 'N', JG.tax_amt, 0),0) NON_RECOVERY_AMOUNT --bug 12917786 , JG.tax_recoverable_flag TAX_RECOVERABLE_FLAG , JG.tax_invoice_date TAX_DATE , JG.accounting_date GL_DATE , JG.trx_number DOC_NUMBER , JG.billing_tp_name PARTY_NAME , JG.billing_tp_tax_reg_num PARTY_TAX_REG_NUM , JG.trx_currency_code CURR , JG.actg_line_description ACCT_LINE_DESC , JG.tax_rate_code TAX_RATE_CODE , JG.tax_rate_code_description TAX_RATE_DESC , JG.tax_rate_code_vat_trx_type_mng TAX_RATE_CODE_VAT_MEANING , DECODE(JG.tax_rate_vat_trx_type_desc ,NULL,JG.tax_rate_code_vat_trx_type_mng ,JG.tax_rate_code_vat_trx_type_mng || ' - ' || JG.tax_rate_vat_trx_type_desc) VAT_CODE_DETAILS , JG.tax_rate_vat_trx_type_desc TAX_RATE_VAT_DESC , JG.tax_rate_vat_trx_type_code TAX_RATE_VAT_CODE /* , JG.tax_type_code TAX_TYPE , JG.tax_type_mng TAX_TYPE_MEANING */ , JG.PRL_NO TAX_TYPE , DECODE(JG.PRL_NO, 'I', 'Input', 'O', 'Output') TAX_TYPE_MEANING /* , JGR.tax_calendar_period PERIOD_NAME , JGR.tax_calendar_year PERIOD_YEAR*/ /* , JG.PERIOD_NAME PERIOD_NAME */ , Glp.Period_Name PERIOD_NAME , Glp.Period_Year PERIOD_YEAR , GLP.period_num PERIOD_NUM , ACCOUNT_FLEXFIELD GL_ACCOUNT , JG.trx_id TRX_ID , JG.application_id APPLICATION_ID , JG.event_class_code EVENT_CLASS_CODE , JG.entity_code ENTITY_CODE , JG.ledger_id LEDGER_ID , JG.trx_line_id TRX_LINE_ID , JG.vat_transaction_id VAT_TRANSACTION_ID FROM jg_zz_vat_trx_details JG , jg_zz_vat_rep_status JGR , gl_periods GLP WHERE JGR.vat_reporting_entity_id = :P_VAT_REP_ENTITY_ID AND JGR.tax_calendar_period = :P_PERIOD AND GLP.period_set_name = JGR.tax_calendar_name AND GLP.adjustment_period_flag = 'N' AND JG.tax_invoice_date BETWEEN GLP.start_date AND GLP.end_date AND JG.reporting_status_id = JGR.reporting_status_id AND (JG.tax_rate_vat_trx_type_code = :P_VAT_TRX_TYPE OR :P_VAT_TRX_TYPE IS NULL) AND (JG.tax_type_code = :P_TAX_TYPE OR :P_TAX_TYPE IS NULL) AND JG.tax_rate_register_type_code = 'TAX' AND JGR.source = 'GL' AND :P_CALLINGREPORT = 'JGZZGLVR' ORDER BY tax_type -- , tax_rate_code_vat_meaning -- , to_date(PERIOD_NAME,'MM-RRRR') , PERIOD_YEAR , PERIOD_NUM , TAX_RATE_CODE_VAT_MEANING , TAX_RATE_CODE , to_number(doc_sequence_num) , tax_date Y JG JGZZGLVR_XMLP AR JG تسجيل ضريبة القيمة المضافة للأستاذ العام لـ ECE Imported from BI Publisher Application: المحليات الأقليمية Source: تسجيل ضريبة القيمة المضافة للأستاذ العام لـ ECE Short Name: JGZZGLVR_XMLP DB package: JG_ZZ_AUDIT_GL_PKG D JG ECE Rechnungswesen - Umsatzsteuer-Register Imported from BI Publisher Application: Regionale Lokalisierungen Source: ECE Rechnungswesen - Umsatzsteuer-Register Short Name: JGZZGLVR_XMLP DB package: JG_ZZ_AUDIT_GL_PKG E JG Registro de IVA de Contabilidad General de ECE Imported from BI Publisher Application: Localizaciones Regionales Source: Registro de IVA de Contabilidad General de ECE Short Name: JGZZGLVR_XMLP DB package: JG_ZZ_AUDIT_GL_PKG F JG ECE - General Ledger - Registre de la TVA Imported from BI Publisher Application: Regional Localizations Source: ECE - General Ledger - Registre de la TVA Short Name: JGZZGLVR_XMLP DB package: JG_ZZ_AUDIT_GL_PKG I JG Registro IVA General Ledger ECE Imported from BI Publisher Application: Regional Localizations Source: Registro IVA General Ledger ECE Short Name: JGZZGLVR_XMLP DB package: JG_ZZ_AUDIT_GL_PKG JA JG ECE General Ledger VAT台帳 Imported from BI Publisher Application: Regional Localizations Source: ECE General Ledger VAT台帳 Short Name: JGZZGLVR_XMLP DB package: JG_ZZ_AUDIT_GL_PKG KO JG ECE General Ledger VAT 등록 Imported from BI Publisher Application: Regional Localizations Source: ECE General Ledger VAT 등록 Short Name: JGZZGLVR_XMLP DB package: JG_ZZ_AUDIT_GL_PKG PTB JG ECE - Registro IVA do General Ledger Imported from BI Publisher Application: Locais Regionais Source: ECE - Registro IVA do General Ledger Short Name: JGZZGLVR_XMLP DB package: JG_ZZ_AUDIT_GL_PKG RU JG реестр НДС Главной книги Imported from BI Publisher Application: Местные версии Source: ШОД: реестр НДС Главной книги Short Name: JGZZGLVR_XMLP DB package: JG_ZZ_AUDIT_GL_PKG S JG Momsregister för Huvudbok Imported from BI Publisher Application: Regional Localizations Source: ECE: Momsregister för Huvudbok Short Name: JGZZGLVR_XMLP DB package: JG_ZZ_AUDIT_GL_PKG TR JG ECE Genel Muhasebe KDV Kaydı Imported from BI Publisher Application: Bölgesel Yerelleştirmeler Source: ECE Genel Muhasebe KDV Kaydı Short Name: JGZZGLVR_XMLP DB package: JG_ZZ_AUDIT_GL_PKG US JG ECE General Ledger VAT Register Imported from BI Publisher Application: Regional Localizations Source: ECE General Ledger VAT Register Short Name: JGZZGLVR_XMLP DB package: JG_ZZ_AUDIT_GL_PKG ZHS JG ECE 总帐增值税登记表 Imported from BI Publisher Application: 区域性本地化 Source: ECE 总帐增值税登记表 Short Name: JGZZGLVR_XMLP DB package: JG_ZZ_AUDIT_GL_PKG BI Publisher :g_entity_identifier :g_ledger_id :g_tax_calendar_name :p_callingreport :p_period :p_tax_type :p_vat_rep_entity_id :p_vat_trx_type 1 -10 :p_callingreport Char JGZZGLVR AR رمز التقرير اسم التقرير D Auswertungsschlüssel Auswertungsbezeichnung E Código de Informe Nombre del informe F Code état Nom de l'état I Codice rapporto Nome rapporto JA レポート・コード レポート名 KO 보고서 코드 보고서명 PTB Código de Relatório Nome do Relatório RU Код отчета Имя отчета S Rapportkod Rapportnamn TR Rapor Kodu Rapor Adı US Report Code Report Name ZHS 报表代码 报表名称 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 Informes Identificador de informes F Identifiant de reporting Identifiant de reporting I Identificativo dichiarazione Identificativo dichiarazione JA レポート識別子 レポート識別子 KO 보고 식별자 보고 식별자 PTB Identificador de Relatório Identificador de Relatório RU Идентификатор отчета Идентификатор отчета S Rapporterings-id Rapporterings-id TR Raporlama Tanımlayıcı Raporlama Tanımlayıcı US Reporting Identifier Reporting Identifier ZHS 申报标识 申报标识 3 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 Steuerkalenderperiode E Período de Calendario Fiscal Período de calendario fiscal F Période du calendrier fiscal Période du calendrier fiscal I Periodo calendario fiscale Periodo calendario fiscale JA 税金カレンダ期間 税金カレンダ期間 KO 세금 달력 기간 세금 달력 기간 PTB Período do Calendário de Imposto Período do Calendário de Imposto RU Налоговый календарный период Налоговый календарный период S Skattekalenderperiod Skattekalenderperiod TR Vergi Takvim Dönemi Vergi Takvim Dönemi US Tax Calendar Period Tax Calendar Period ZHS 纳税日历期间 纳税日历期间 4 30 :p_vat_trx_type LOV Oracle JGZZ_VAT_TRANS_TYPES Y select lookup_code id, lookup_code value, meaning description from fnd_lookup_values where lookup_type='ZX_JEBE_VAT_TRANS_TYPE' 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 USt-Transaktionsart USt-Transaktionsart E Tipo de Transacción de IVA Tipo de Transacción de IVA F Type de mouvement de TVA Type de mouvement de TVA I Tipo di transazione IVA Tipo di transazione IVA JA VAT取引タイプ VAT取引タイプ KO VAT 트랜잭션 유형 VAT 트랜잭션 유형 PTB Tipo de Transação IVA Tipo de Transação IVA RU Тип транзакции НДС Тип транзакции НДС S Momstransaktionstyp Momstransaktionstyp TR KDV İşlem Tipi KDV İşlem Tipi US VAT Transaction Type VAT Transaction Type ZHS 增值税事务处理类型 增值税事务处理类型 5 40 :p_tax_type LOV Oracle JGZZ_VAT_TAX_TYPES Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='JGZZ_VAT_TAX_TYPES' and enabled_flag='Y' and start_date_active<=sysdate and nvl(end_date_active,sysdate)>=sysdate order by meaning AR نوع الضريبة نوع الضريبة D Steuerart Steuerart E Clase de Impuesto Tipo de impuesto F Type de taxe Type de taxe I Tipo imposta Tipo di imposta JA 税金タイプ 税金タイプ KO 세금 유형 세금 유형 PTB Tipo de imposto Tipo de imposto RU Тип налога Тип налога S Skattetyp Skattetyp TR Vergi Tipi Vergi Tipi US Tax Type Tax Type ZHS 税种 税种 :$flex$.jgzz_vat_reporting_entity_id Reporting Identifier Tax Calendar Period