ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4726451A9E05362FB09050512Y select gjl1.je_line_num C_JE_LINE_NUM, gjl1.effective_date C_EFFECTIVE_DATE, gjl1.accounted_dr C_TAXABLE_ACC_DR, gjl1.accounted_cr C_TAXABLE_ACC_CR, gjl1.tax_document_date C_TAX_DOCUMENT_DATE, gjl1.tax_document_identifier C_TAX_DOCUMENT_IDENTIFIER, gjl1.tax_customer_name C_TAX_CUSTOMER_NAME, gjl1.tax_registration_number C_TAX_REGISTRATION_NUMBER, gjl1.tax_group_id C_TAX_GROUP_ID, gjh.je_header_id C_JE_HEADER_ID, gjh.name C_NAME, gjh.default_effective_date C_DEFAULT_EFFECTIVE_DATE, gjl2.accounted_dr C_ACCOUNTED_DR, gjl2.accounted_cr C_ACCOUNTED_CR, &p_bal_segment C_BAL_SEGMENT, &p_taxable_acc_segment C_TAXABLE_ACC_SEGMENT, &p_tax_acc_segment C_TAX_ACC_SEGMENT, gjl1.tax_code_id C_TAX_CODE_ID, gjl1.tax_type_code C_TAX_TYPE_CODE, rates.calculation_level_code C_CALCULATION_LEVEL_CODE, gl.meaning C_TAX_TYPE_MEANING, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_bal_segment_pad', 'SQLGL', 'GL#', gcc2.CHART_OF_ACCOUNTS_ID, NULL, gcc2.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'PADDED_VALUE') C_BAL_SEGMENT_PAD, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_bal_segment_f', 'SQLGL', 'GL#', gcc2.CHART_OF_ACCOUNTS_ID, NULL, gcc2.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') C_BAL_SEGMENT_F, fnd_flex_xml_publisher_apis.process_kff_combination_1('bal_secure', 'SQLGL', 'GL#', gcc2.CHART_OF_ACCOUNTS_ID, NULL, gcc2.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'SECURITY') BAL_SECURE, GL_GLXJETAX_XMLP_PKG.c_tax_codeformula(gjl1.tax_type_code, gjl1.tax_code_id) C_TAX_CODE, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_tax_acc_flexfield_pad', 'SQLGL', 'GL#', gcc2.CHART_OF_ACCOUNTS_ID, NULL, gcc2.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') C_TAX_ACC_FLEXFIELD_PAD, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_tax_acc_flexfield', 'SQLGL', 'GL#', gcc2.CHART_OF_ACCOUNTS_ID, NULL, gcc2.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_TAX_ACC_FLEXFIELD, fnd_flex_xml_publisher_apis.process_kff_combination_1('tax_secure', 'SQLGL', 'GL#', gcc2.CHART_OF_ACCOUNTS_ID, NULL, gcc2.CODE_COMBINATION_ID, 'ALL', 'Y', 'SECURITY') TAX_SECURE, GL_GLXJETAX_XMLP_PKG.c_jou_dr_or_crformula(:C_JOU_TAXABLE_ACC_DR, :C_JOU_TAXABLE_ACC_CR) C_JOU_DR_OR_CR, GL_GLXJETAX_XMLP_PKG.c_jou_taxable_acc_sumformula(:C_JOU_TAXABLE_ACC_DR, :C_JOU_TAXABLE_ACC_CR) C_JOU_TAXABLE_ACC_SUM, GL_GLXJETAX_XMLP_PKG.c_jou_accounted_sumformula(:C_JOU_ACCOUNTED_DR, :C_JOU_ACCOUNTED_CR) C_JOU_ACCOUNTED_SUM, GL_GLXJETAX_XMLP_PKG.c_jou_gross_drformula(:C_JOU_TAXABLE_ACC_DR, :C_JOU_ACCOUNTED_DR) C_JOU_GROSS_DR, GL_GLXJETAX_XMLP_PKG.c_jou_gross_crformula(:C_JOU_TAXABLE_ACC_CR, :C_JOU_ACCOUNTED_CR) C_JOU_GROSS_CR, GL_GLXJETAX_XMLP_PKG.c_jou_grossformula(:C_JOU_GROSS_DR, :C_JOU_GROSS_CR) C_JOU_GROSS, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_taxable_acc_flexfield', 'SQLGL', 'GL#', gcc2.CHART_OF_ACCOUNTS_ID, NULL, gcc2.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_TAXABLE_ACC_FLEXFIELD, GL_GLXJETAX_XMLP_PKG.c_dr_or_crformula(gjl1.accounted_dr, gjl1.accounted_cr) C_DR_OR_CR, GL_GLXJETAX_XMLP_PKG.c_taxable_acc_amountformula(gjl1.accounted_dr, gjl1.accounted_cr) C_TAXABLE_ACC_AMOUNT, GL_GLXJETAX_XMLP_PKG.c_accounted_amountformula(gjl2.accounted_dr, gjl2.accounted_cr) C_ACCOUNTED_AMOUNT, GL_GLXJETAX_XMLP_PKG.c_gross_drformula(gjl1.accounted_dr, gjl2.accounted_dr) C_GROSS_DR, GL_GLXJETAX_XMLP_PKG.c_gross_crformula(gjl1.accounted_cr, gjl2.accounted_cr) C_GROSS_CR, GL_GLXJETAX_XMLP_PKG.c_grossformula(:C_GROSS_DR, :C_GROSS_CR) C_GROSS, GL_GLXJETAX_XMLP_PKG.c_new_groupformula(gjh.je_header_id, gjl1.tax_group_id, gjl2.accounted_dr, gjl2.accounted_cr) C_NEW_GROUP, fnd_flex_xml_publisher_apis.process_kff_combination_1('acc_secure', 'SQLGL', 'GL#', gcc2.CHART_OF_ACCOUNTS_ID, NULL, gcc2.CODE_COMBINATION_ID, 'ALL', 'Y', 'SECURITY') ACC_SECURE, GL_GLXJETAX_XMLP_PKG.C_OLD_GROUPS_p C_OLD_GROUPS, GL_GLXJETAX_XMLP_PKG.C_OLD_HEADER_ID_p C_OLD_HEADER_ID, GL_GLXJETAX_XMLP_PKG.C_RUN_ACCOUNTED_DR_p C_RUN_ACCOUNTED_DR, GL_GLXJETAX_XMLP_PKG.C_RUN_ACCOUNTED_CR_p C_RUN_ACCOUNTED_CR from gl_lookups gl, zx_account_rates rates, zx_party_tax_profile ptp, gl_code_combinations gcc2, gl_je_lines gjl2, gl_code_combinations gcc1, gl_je_lines gjl1, gl_je_batches gjb, gl_je_headers gjh, gl_period_statuses gps where gps.ledger_id= :P_LEDGER_ID and gps.application_id =101 and trunc(gps.end_date) >= trunc(:P_START_DATE) and trunc(gps.start_date) <= trunc(:P_END_DATE) and gps.closing_status <> 'N' and gjh.period_name = gps.period_name and gjh.tax_status_code = 'T' and gjh.ledger_id = :P_LEDGER_ID and gjh.actual_flag = 'A' and (gjh.display_alc_journal_flag is null or gjh.display_alc_journal_flag = 'Y') and trunc(gjh.default_effective_date) between trunc(:P_START_DATE) and trunc(:P_END_DATE) and gjb.je_batch_id = gjh.je_batch_id+0 and gjb.default_period_name = gjh.period_name and gjb.actual_flag = 'A' and &P_WHERE_POSTING_STATUS and gjl1.je_header_id = gjh.je_header_id and &P_WHERE_TAX and gcc1.code_combination_id = gjl1.code_combination_id and &P_WHERE_BAL_SEGMENT and gjl2.je_header_id = gjl1.je_header_id and gjl2.tax_group_id = gjl1.tax_group_id and gjl2.tax_code_id is null and gcc2.code_combination_id = gjl2.code_combination_id and rates.Ledger_id = :P_LEDGER_ID AND rates.content_owner_id = ptp.party_tax_profile_id AND ptp.party_id = gjb.org_id AND ptp.party_type_code = 'OU' AND rates.account_segment_value is NULL and nvl(rates.tax_class, 'INPUT/OUTPUT') = decode(gjl1.tax_type_code, 'I', decode(rates.tax_status_code, 'STD_AR_INPUT', 'OUPUT', 'INPUT'), 'O', 'OUTPUT', 'INPUT/OUTPUT') &P_WHERE_DAS and gl.lookup_type = decode(gjl1.tax_type_code, NULL, 'TAX_TYPE', 'TAX_TYPE') and gl.lookup_code = gjl1.tax_type_code --order by gjl1.je_line_num order by C_BAL_SEGMENT_PAD,C_TAX_TYPE_CODE,C_TAX_CODE,C_TAX_ACC_FLEXFIELD_PAD,C_DEFAULT_EFFECTIVE_DATE, C_NAME,C_JE_HEADER_ID,C_TAX_REGISTRATION_NUMBER, gjl1.je_line_num SQLGL GLXJETAX_XML AR GL اليوميات - الضريبة (بتنسيق XML) Imported from BI Publisher Description: تقرير يوميات الضرائب Application: الأستاذ العام Source: اليوميات - الضريبة (بتنسيق XML) Short Name: GLXJETAX_XML DB package: GL_GLXJETAX_XMLP_PKG D GL Steuerbuchungen Imported from BI Publisher Description: Steuerbuchungen Application: Rechnungswesen Source: Steuerbuchungen (XML) Short Name: GLXJETAX_XML DB package: GL_GLXJETAX_XMLP_PKG E GL Asientos - Impuestos Imported from BI Publisher Description: Informe Asientos de Impuestos Application: General Ledger Source: Asientos - Impuestos (XML) Short Name: GLXJETAX_XML DB package: GL_GLXJETAX_XMLP_PKG F GL Pièces - Taxe Imported from BI Publisher Description: Etat des pièces de taxe Application: General Ledger Source: Pièces - Taxe (XML) Short Name: GLXJETAX_XML DB package: GL_GLXJETAX_XMLP_PKG I GL Scritture contabili - Imposta(1) Imported from BI Publisher Description: Rapporto Scritture contabili imposta(1) Application: General Ledger Source: Scritture contabili - Imposta(1) Short Name: GLXJETAX_XML DB package: GL_GLXJETAX_XMLP_PKG JA GL 仕訳 - 税金 Imported from BI Publisher Description: 税仕訳レポート Application: General Ledger Source: 仕訳 - 税金 (XML) Short Name: GLXJETAX_XML DB package: GL_GLXJETAX_XMLP_PKG KO GL 분개 - 세금 Imported from BI Publisher Description: 세금 분개 보고서 Application: General Ledger Source: 분개 - 세금(XML) Short Name: GLXJETAX_XML DB package: GL_GLXJETAX_XMLP_PKG PTB GL Lançamentos - Imposto Imported from BI Publisher Description: Relat. de Lançam. de Impostos Application: General Ledger Source: Lançamentos - Imposto (XML) Short Name: GLXJETAX_XML DB package: GL_GLXJETAX_XMLP_PKG RU GL Журналы - налоговые Imported from BI Publisher Description: Отчет по налоговым журналам Application: Главная книга Source: Журналы - налоговые (XML) Short Name: GLXJETAX_XML DB package: GL_GLXJETAX_XMLP_PKG S GL Verifikationer - Moms Imported from BI Publisher Description: Momsverifikationsrapport Application: General Ledger Source: Verifikationer - Moms (XML) Short Name: GLXJETAX_XML DB package: GL_GLXJETAX_XMLP_PKG TR GL Fişler - Vergi Imported from BI Publisher Description: Vergi Fişleri Raporu Application: Genel Muhasebe Source: Fişler - Vergi (XML) Short Name: GLXJETAX_XML DB package: GL_GLXJETAX_XMLP_PKG US GL Journals - Tax Imported from BI Publisher Description: Tax Journals Report Application: General Ledger Source: Journals - Tax (XML) Short Name: GLXJETAX_XML DB package: GL_GLXJETAX_XMLP_PKG ZHS GL 日记账 - 税务 Imported from BI Publisher Description: 税务日记账报表 Application: 总帐管理系统 Source: 日记账 - 税务 (XML) Short Name: GLXJETAX_XML DB package: GL_GLXJETAX_XMLP_PKG BI Publisher &p_bal_segment &p_tax_acc_segment &p_taxable_acc_segment &p_where_bal_segment &p_where_das &p_where_posting_status &p_where_tax :c_gross_cr :c_gross_dr :c_jou_accounted_cr :c_jou_accounted_dr :c_jou_gross_cr :c_jou_gross_dr :c_jou_taxable_acc_cr :c_jou_taxable_acc_dr :c_old_groups :c_old_header_id :c_run_accounted_cr :c_run_accounted_dr :cp_end_date :cp_start_date :h_access_set_name :h_currency_code :h_ledger_name :h_posting_meaning :p_access_set_id :p_bal_segment :p_chart_of_accounts_id :p_conc_request_id :p_end_date :p_high_bal_seg :p_ledger_id :p_low_bal_seg :p_posting_status :p_start_date :p_tax_acc_segment :p_tax_code :p_tax_type :p_taxable_acc_segment :p_where_bal_segment :p_where_das :p_where_posting_status :p_where_tax 1 -30 :p_access_set_id Number fnd_profile.value('GL_ACCESS_SET_ID') Y AR معرف مجموعة الوصول للبيانات معرف مجموعة الوصول للبيانات D Kennung DatenzugriffsSet Kennung DatenzugriffsSet E Id Juego de Accesos a Datos Id juego de accesos a datos F ID jeu d'accès aux données ID jeu d'accès aux données I Id serie di accesso dati Id della serie di accesso ai dati JA データ・アクセス・セットID データ・アクセス・セットID KO 데이터 액세스 세트 ID 데이터 액세스 세트 ID PTB Id do Conjunto de Acesso a Dados Id do Conjunto de Acesso a Dados RU Идент. набора доступа к данным Идент. набора доступа к данным S Id för dataåtkomstuppsättning Id för dataåtkomstuppsättning TR Veri Erişim Kümesi No Veri Erişim Kümesi No US Data Access Set Id Data Access Set Id ZHS 数据访问权限集标识 数据访问权限集标识 2 -20 :p_chart_of_accounts_id Number SELECT chart_of_accounts_id FROM gl_access_sets WHERE access_set_id = fnd_profile.value('GL_ACCESS_SET_ID') Y AR معرف جدول تصنيف الحسابات معرف جدول تصنيف الحسابات D Kontenplankennung Kontenplankennung E Id Plan de Cuentas Id Plan de Cuentas F ID plan de comptes ID plan de comptes I Id piano dei conti Id piano dei conti JA 勘定体系ID 勘定体系ID KO 계정 코드집 ID 계정 코드집 ID PTB Id do Plano de Contas Id do Plano de Contas RU Идент. плана счетов Идент. плана счетов S Kontoplans-id Kontoplans-id TR Hesap Planı No Hesap Planı No US Chart of Accounts Id Chart of Accounts Id ZHS 科目表标识 科目表标识 3 10 :p_ledger_id LOV Oracle GL_SRS_LEDGER_FULL Y select l.ledger_id id, l.name value, l.description description from gl_access_set_ledgers ac,gl_ledgers l where ac.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and ac.access_privilege_code='F' and l.ledger_id=ac.ledger_id order by value,description select name from gl_ledgers where ledger_id = gl_access_set_security_pkg.get_default_ledger_id(fnd_profile.value('GL_ACCESS_SET_ID'), 'F') Y AR الأستاذ معرف الأستاذ D Buch Buchkennung E Libro Mayor Id Libro Mayor F Livre ID livre I Libro contabile Id sezionale JA 元帳 元帳ID KO 원장 원장 ID PTB Razão Id do Razão RU Книга Идентификатор книги S Huvudbok Huvudboks-id TR Defter Defter No US Ledger Ledger Id ZHS 分类账 分类账标识 4 20 :p_low_bal_seg Char Y AR من مقطع الترصيد من مقطع الترصيد D Von Buchungskreis Von Buchungskreis E De Segmento de Balance De Segmento de Balance F Du segment d'équilibrage Du segment d'équilibrage I Segmento di quadratura - Da Segmento di quadratura - Da JA 貸借一致セグメント:自 貸借一致セグメント:自 KO 잔액 조정 세그먼트: 부터 잔액 조정 세그먼트: 부터 PTB Segmento Balanceador - De Segmento Balanceador - De RU Балансирующий сегмент с Балансирующий сегмент с S Från balanssegment Från balanssegment TR İlk Dengeleme Segmenti İlk Dengeleme Segmenti US From Balancing Segment From Balancing Segment ZHS 起始平衡段 起始平衡段 5 30 :p_high_bal_seg Char Y AR إلى مقطع الترصيد إلى مقطع الترصيد D Bis Buchungskreis Bis Buchungskreis E A Segmento de Balance A Segmento de Balance F Segment d'équilibrage - A Segment d'équilibrage - A I Segmento di quadratura - A Segmento di quadratura - A JA 貸借一致セグメント:至 貸借一致セグメント:至 KO 잔액조정 세그먼트: 까지 잔액조정 세그먼트: 까지 PTB Segmento Balanceador - Até Segmento Balanceador - Até RU Балансирующий сегмент по Балансирующий сегмент по S Till balanssegment Till balanssegment TR Son Dengeleme Segmenti Son Dengeleme Segmenti US To Balancing Segment To Balancing Segment ZHS 终止平衡段 终止平衡段 6 40 :p_tax_type LOV Oracle GL_TAX_TYPE Y select lookup_code id, meaning value, null description from gl_lookups where lookup_type='TAX_TYPE' and lookup_code!='N' order by value,description AR نوع الضريبة نوع الضريبة D Steuerart Steuerart E Clase de Impuesto Clase de Impuesto F Type de taxe Type de taxe I Tipo di 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 税种 税种 7 50 :p_tax_code LOV Oracle GL_SRS_TAX_CODES Y select tax_code id, tax_code value, description description from gl_tax_codes_v gtc1 where tax_type_code=:$flex$.gl_tax_type and tax_code_id=(select max(tax_code_id) from gl_tax_codes_v gtc2 where gtc2.tax_code=gtc1.tax_code and gtc2.tax_type_code=gtc1.tax_type_code) order by tax_code AR رمز ضريبة رمز ضريبة D Steuerschlüssel Steuerschlüssel E Código de Impuesto Código de Impuesto F Code taxe Code taxe I Codice imposta Codice dell'imposta JA 税金コード 税金コード KO 세금 코드 세금 코드 PTB Cód. Imposto Cód. Imposto RU Код налога Код налога S Momskod Momskod TR Vergi Kodu Vergi Kodu US Tax Code Tax Code ZHS 税码 税码 8 60 :p_start_date Date Y AR من تاريخ الفعالية من تاريخ الفعالية D Von Gültigkeitsdatum Von Gültigkeitsdatum E De Fecha en Vigor De Fecha en Vigor F De la date de validité De la date de validité I Data effettiva - Da Data effettiva - Da JA 有効日:自 有効日:自 KO 유효 일자: 부터 유효 일자: 부터 PTB Data de Efetivação - De Data de Efetivação - De RU Дата действия с Дата действия с S Från giltighetsdatum Från giltighetsdatum TR İlk Geçerlilik Tarihi İlk Geçerlilik Tarihi US From Effective Date From Effective Date ZHS 起始有效日期 起始有效日期 9 70 :p_end_date Date Y AR إلى تاريخ الفعالية إلى تاريخ الفعالية D Bis Gültigkeitsdatum Bis Gültigkeitsdatum E A Fecha en Vigor A Fecha en Vigor F Date de validité - A Date de validité - A I Data effettiva - A Data effettiva - A JA 有効日:至 有効日:至 KO 유효 일자: 까지 유효 일자: 까지 PTB Data de Efetivação - Até Data de Efetivação - Até RU Дата действия по Дата действия по S Till bokfört datum Till bokfört datum TR Son Geçerlilik Tarihi Son Geçerlilik Tarihi US To Effective Date To Effective Date ZHS 有效终止日期 有效终止日期 10 80 :p_posting_status LOV Oracle GL_SRS_JOURNAL_TYPE Y select lookup_code id, meaning value, description description from gl_lookups where lookup_type='JOURNAL_REPORT_TYPE' order by (meaning) Y AR موقف الترحيل موقف الترحيل D Verbuchungsstatus Verbuchungsstatus E Estado de Contabilización Estado de contabilización F Statut d'imputation Statut d'imputation I Stato contabilizzazione Stato della contabilizzazione JA 転記ステータス 転記ステータス KO 전기 상태 전기 상태 PTB Status da Contabilização Status da Contabilização RU Статус проводки Статус проводки S Postningsstatus Postningsstatus TR Muhasebeleşme Statüsü Muhasebeleşme Statüsü US Posting Status Posting Status ZHS 过账状态 过账状态