ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472D651A9E05362FB09050512 SELECT CON.REP_CONTEXT_LVL_MNG C_REP_CONTEXT_LVL_MNG, DET.LEDGER_ID C_Ledger_ID, DET.LEDGER_NAME C_Ledger_Name, CON.REP_CONTEXT_ENTITY_NAME C_Rep_Context_Entity_Name, DET.CHART_OF_ACCOUNTS_ID C_Chart_Of_Accounts_ID, DET.FUNCTIONAL_CURRENCY_CODE C_Functional_Currency_Code, DET.CURRENCY_CODE_DESC C_Func_Currency_Description, DET.BANK_ACCOUNT_NUM C_Bank_Account_Num, CON.TAXPAYER_ID C_Taxpayer_ID, CON.ACTIVITY_CODE C_Activity_Code, CON.REP_CONTEXT_ENTITY_NAME C_Organization_Unit_Name, CON.REP_CONTEXT_ENTITY_ADDRESS1 C_Rep_Context_Address1, CON.REP_CONTEXT_ENTITY_ADDRESS2 C_Rep_Context_Address2, CON.REP_CONTEXT_ENTITY_ADDRESS3 C_Rep_Context_Address3, DET.TERRITORY_SHORT_NAME C_Territory_Short_Name, CON.REP_CONTEXT_ENTITY_COUNTRY C_Rep_Context_Country, CON.REP_CONTEXT_ENTITY_CITY C_Rep_Context_City, CON.REP_CONTEXT_ENTITY_POSTAL_CODE C_Rep_Context_Postal_Code, CON.LEGAL_CONTACT_PARTY_NAME C_Taxable_Person, CON.LEGAL_CONTACT_TITLE C_Designation, CON.LEGAL_CONTACT_PRE_NAME_ADJUNCT C_Title, DET.BANK_BRANCH_ID C_Branch_Code, DET.EXTRACT_SOURCE_LEDGER C_Extract_Source_Legder, DET.TRX_ID C_Invoice_ID, DET.TRX_NUMBER C_Invoice_Number, DET.APPLIED_TO_TRX_NUMBER C_Original_Number, DET.APPLIED_TO_TRX_NUMBER C_Applied_to_Trx_number, TO_CHAR(DET.TRX_DATE,'YYYY-MM-DD') C_Invoice_Date, DET.EVENT_CLASS_CODE C_Invoice_Type, DET.TRX_CURRENCY_CODE C_Trx_Currency_Code, DET.BILLING_TP_NUMBER C_Supplier_Number, DET.BILLING_TRADING_PARTNER_ID C_Supplier_ID, DET.BILLING_TP_NAME C_Supplier_Name, DET.BILLING_TP_SITE_NAME C_Supplier_Site_Name, DET.BILLING_TP_TAXPAYER_ID C_Supplier_Taxpayer_ID, DET.BILLING_TP_TAX_REG_NUM C_Supplier_Tax_Reg_Num, DET.BILLING_TP_ADDRESS1 C_Supplier_Address1, DET.BILLING_TP_ADDRESS2 C_Supplier_Address2, DET.BILLING_TP_ADDRESS3 C_Supplier_Address3, DET.BILLING_TP_PROVINCE C_Supplier_Province, DET.BILLING_TP_CITY C_Supplier_City, DET.REGISTRATION_STATUS_CODE C_Supplier_VAT_Reg_Status_Code, substrb(DET.DOCUMENT_SUB_TYPE,10,2) C_GUI_Type, EXT.DOCUMENT_SUB_TYPE_MNG C_GUI_Type_Description, EXT.TAX_STATUS_MNG C_Government_Tax_Type, EXT.TRX_BUSINESS_CATEGORY_MNG C_Deductible_Type, DET.SUPPLIER_EXCHANGE_RATE C_Supplier_Exchange_Rate, TO_CHAR(DET.TAX_INVOICE_DATE,'YYYY-MM-DD') C_Custom_Doc_Date, DET.TAX_INVOICE_NUMBER C_Custom_Doc_Number, DET.SUPPLIER_TAX_INVOICE_NUMBER C_Supplier_Tax_Invoice_Number, TO_CHAR(DET.SUPPLIER_TAX_INVOICE_DATE,'YYYY-MM-DD') C_Supplier_Tax_Invoice_Date, EXT.ATTRIBUTE16 C_CL_Order_by_Doc_Type, substrb(DET.DOCUMENT_SUB_TYPE,15) C_CL_DOCUMENT_SUB_TYPE, EXT.DOCUMENT_SUB_TYPE_MNG C_CL_DOC_TYPE_MEANING, DET.PRODUCT_DESCRIPTION C_Item, to_number(det.trx_line_quantity) C_Quantity, TO_CHAR(DET.CANCELLED_DATE,'YYYY-MM-DD') C_Cancelled_Date, nvl(DET.CURRENCY_CONVERSION_RATE,1) C_Exchange_Rate, DET.PORT_OF_ENTRY_CODE C_Port_of_Entry_Code, DET.LINE_INTENDED_USE C_Line_Intended_Use, EXT.GDF_AP_INVOICES_ATT11 C_GDF_AP_INVOICES_ATT11, EXT.GDF_AP_INVOICES_ATT12 C_GDF_AP_INVOICES_ATT12, EXT.GDF_AP_INVOICES_ATT13 C_GDF_AP_INVOICES_ATT13, DET.TAX_RATE_ID C_Tax_ID, DET.TAX_RATE_CODE C_Tax_Code, DET.TAX_RATE_CODE_NAME C_Tax_Code_Name, nvl(DET.TAX_RATE,0) C_Tax_Rate, DET.TAX_TYPE_CODE C_Tax_Rate_Code_Type_Code, DET.TAX_TYPE_MNG C_Tax_Rate_Code_Type_Meaning, EXT.ATTRIBUTE4 C_DGI_Trans_Code, DET.TAX_REGIME_CODE C_DGI_Tax_Regime_Code, DET.TRX_LINE_TYPE C_Taxable_Line_Type, nvl(NVL(DET.TAXABLE_AMT_FUNCL_CURR,DET.TAXABLE_AMT),0) C_Taxable_Accounted_Amount, DET.TAXABLE_AMT C_Taxable_Entered_Amount, nvl(NVL(DET.TAX_AMT_FUNCL_CURR,DET.TAX_AMT),0) C_Tax_Accounted_Amount, nvl(DET.TAX_AMT,0) C_Tax_Entered_Amount, EXT.NUMERIC12 C_JA_Invoice_Amount, EXT.NUMERIC1 C_SG_Inhouse_Inv_Amount, EXT.NUMERIC2 C_SG_Supplier_Inv_Amount, EXT.NUMERIC3 C_SG_Inhouse_Tax_Amount, EXT.NUMERIC4 C_SG_Supplier_Tax_Amount, EXT.NUMERIC5 C_SG_Taxable_GainLoss, EXT.NUMERIC6 C_SG_GainLoss, EXT.NUMERIC2 C_JL_VAT_Exempt_Amount_Total, EXT.NUMERIC3 C_JL_Perc_Tax_Amount_Total, EXT.NUMERIC4 C_JL_Prov_Tax_Amount_Total, EXT.NUMERIC5 C_JL_Muni_Tax_Amount_Total, EXT.NUMERIC6 C_JL_Excise_Tax_Amount_Total, EXT.NUMERIC7 C_JL_Other_Tax_Total, EXT.NUMERIC8 C_JL_Non_Taxable_Amount_Total, EXT.NUMERIC9 C_JL_VAT_Tax_Amount_Total, EXT.NUMERIC10 C_JL_Taxable_Amount_Total, EXT.NUMERIC14 C_JL_Exempt_VAT_Accted_Amount, 0 C_JL_Other_Fed_Perc_Tax, EXT.NUMERIC1 C_AR_Number_of_Rate_by_Invoice, EXT.NUMERIC14 C_AR_Number_of_Rates, EXT.numeric2 C_JL_EXEMPT_AMT, EXT.numeric10 C_JL_EFFECTIVE_AMT, EXT.numeric9 C_JL_VAT_AMT, EXT.numeric7 C_JL_OTHER_TAX_AMT, EXT.NUMERIC1 C_JL_TOTAL_DOC_AMT, EXT.NUMERIC1 C_CL_Net_Amount, EXT.NUMERIC3 C_CL_Number_of_Invoice, EXT.NUMERIC4 C_CL_Total_Exempt_by_Doc_Type, EXT.NUMERIC5 C_CL_Total_Effect_by_Doc_Type, EXT.NUMERIC6 C_CL_Total_VAT_by_Doc_Type, EXT.NUMERIC11 C_CL_Total_Other_by_Doc_Type, EXT.NUMERIC8 C_CL_Total_Amount_by_Doc_Type, DET.GDF_FND_CURRENCIES_ATT1 C_DGI_Currency_Code, EXT.ATTRIBUTE16 C_Fiscal_Printer, DET.PRECISION C_Precision_1, DET.MINIMUM_ACCOUNTABLE_UNIT C_Min_Acct_Units, EXT.GDF_AP_INVOICES_ATT4 C_Print_Date , nvl(DET.TAX_AMT,0) + nvl(DET.TAXABLE_AMT,0) C_TOT_AMOUNT , nvl(nvl(DET.TAX_AMT_FUNCL_CURR,DET.TAX_AMT),0) + nvl(NVL(DET.TAXABLE_AMT_FUNCL_CURR,DET.TAXABLE_AMT),0) C_TOT_FUNC_AMT, ACT.PERIOD_NAME C_PERIOD_NAME , EXT.ATTRIBUTE9 C_TRX_CURRENCY_DESC , EXT.ATTRIBUTE8 C_BATCH_NAME , DET.TRX_DESCRIPTION C_TRX_DESCRIPTION , EXT.ATTRIBUTE3 C_ALTERNATE_TERRITORY_CODE , EXT.ATTRIBUTE7 C_ATTRIBUTE3 , DET.OFFSET_FLAG C_OFFSET_FLAG , EXT.ATTRIBUTE6 C_CREATED_BY, ACT.ACCOUNT_FLEXFIELD C_TAX_ACCT_FLEXFIELD, EXT.ATTRIBUTE1 C_HOLD, EXT.ATTRIBUTE5 C_MATCH, DET.HQ_ESTB_REG_NUMBER C_FIRST_PARTY_TAX_REG_NUM, EXT.ATTRIBUTE1 C_ATTRIBUTE1, DET.UNIT_PRICE C_UNIT_PRICE, TO_CHAR(TO_NUMBER(SUBSTRB(fnd_date.date_to_canonical(det.trx_date),1,4)) - 1911) || '/' || SUBSTRB(fnd_date.date_to_canonical(det.trx_date),6,5) C_TW_INVOICE_DATE, CON.ORG_INFORMATION2 C_ORG_INFORMATION2, EXT.ATTRIBUTE28 C_SG_BANK_ID, EXT.ATTRIBUTE29 C_SG_BRANCH_CODE, EXT.ATTRIBUTE30 C_SG_ACCOUNT_NUM, DET.TRX_LINE_ID C_TRANSACTION_LINE, DET.ADJUSTED_DOC_NUMBER C_ADJUSTED_DOC_NUMBER, ZX_ZXAPJAJL_XMLP_PKG.CF_TAXABLE_ACC_AMTFormula(DET.TRX_ID, DET.TRX_LINE_ID) CF_TAXABLE_ACC_AMT, ZX_ZXAPJAJL_XMLP_PKG.CF_TAXABLE_AMTFormula(DET.TRX_ID, DET.TRX_LINE_ID) CF_TAXABLE_AMT, ZX_ZXAPJAJL_XMLP_PKG.CF_TOT_AMOUNT_P CF_TOT_AMOUNT, ZX_ZXAPJAJL_XMLP_PKG.CF_TOT_FUNC_AMT_P CF_TOT_FUNC_AMT, ZX_ZXAPJAJL_XMLP_PKG.CP_TRX_ID_P CP_TRX_ID, ZX_ZXAPJAJL_XMLP_PKG.CP_TRX_ID_ACC_P CP_TRX_ID_ACC, ZX_ZXAPJAJL_XMLP_PKG.CP_TRX_LINE_ID_P CP_TRX_LINE_ID, ZX_ZXAPJAJL_XMLP_PKG.CP_TRX_LINE_ID_ACC_P CP_TRX_LINE_ID_ACC FROM ZX_REP_CONTEXT_T CON, ZX_REP_TRX_DETAIL_T DET, ZX_REP_TRX_JX_EXT_T EXT, ZX_REP_ACTG_EXT_T ACT WHERE DET.REQUEST_ID = :P_CONC_REQUEST_ID AND DET.REQUEST_ID = CON.REQUEST_ID AND NVL(DET.REP_CONTEXT_ID,CON.REP_CONTEXT_ID) = CON.REP_CONTEXT_ID and ACT.DETAIL_TAX_LINE_ID(+) = DET.DETAIL_TAX_LINE_ID AND EXT.DETAIL_TAX_LINE_ID(+) = DET.DETAIL_TAX_LINE_ID ORDER BY DET.TRX_ID,DET.TRX_LINE_ID Y ZX ZXSGAGAL_XML AR ZX تقرير ربح/خسارة ضرائب المدخلات في سنغافورة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: تقرير ربح/خسارة ضرائب المدخلات لسنغافورة Application: الضرائب في E-Business Source: تقرير ربح/خسارة ضرائب المدخلات في سنغافورة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: ZXSGAGAL_XML DB package: ZX_ZXAPJAJL_XMLP_PKG D ZX Vorsteuergewinn/-verlust- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Auswertung "Vorsteuergewinn/-verlust" (Singapur) Application: E-Business Tax Source: Singapur: Vorsteuergewinn/-verlust (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: ZXSGAGAL_XML DB package: ZX_ZXAPJAJL_XMLP_PKG E ZX Singapur - Informe de Pérdidas/Ganancias de IVA Devengado: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Singapur - Informe Pérdidas/Ganancias de IVA Devengado Application: E-Business Tax Source: Singapur - Informe de Pérdidas/Ganancias de IVA Devengado (XML): No Admitido, Reservado para Uso Futuro Short Name: ZXSGAGAL_XML DB package: ZX_ZXAPJAJL_XMLP_PKG F ZX Singapour - Etat des écarts de change sur les taxes- Non pris en charge : réservé pour une utilisation ultérieure Imported from BI Publisher Description: Singapour - Etat des écarts de change sur les taxes Application: E-Business Tax Source: Singapour - Etat des écarts de change sur les taxes (XML) - Non pris en charge : réservé pour une utilisation ultérieure Short Name: ZXSGAGAL_XML DB package: ZX_ZXAPJAJL_XMLP_PKG I ZX Singapore - rapporto Utile/perdita imposte a credito- non supportato: riservato per usi futuri Imported from BI Publisher Description: Singapore - rapporto Utili/perdite imposte a credito Application: E-Business Tax Source: Singapore - rapporto Utile/perdita imposte a credito (XML) - non supportato: riservato per usi futuri Short Name: ZXSGAGAL_XML DB package: ZX_ZXAPJAJL_XMLP_PKG JA ZX Singaporean Input Taxes Gain/Loss Report- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: Singaporean Input Taxes Gain/Loss Report Application: E-Business Tax Source: Singaporean Input Taxes Gain/Loss Report (XML) - 未サポート: 将来の使用のために予約 Short Name: ZXSGAGAL_XML DB package: ZX_ZXAPJAJL_XMLP_PKG KO ZX 싱가포르 매입세 손익 보고서- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 싱가포르 매입세 손익 보고서 Application: E-Business Tax Source: 싱가포르 매입세 손익 보고서(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: ZXSGAGAL_XML DB package: ZX_ZXAPJAJL_XMLP_PKG PTB ZX Relatório de Ganho/Perda sobre Impostos de Entrada - Cingapura- Não Suportado: Reservado para Uso Futuro Imported from BI Publisher Description: Relatório de Ganho/Perda sobre Impostos de Entrada - Cingapura Application: E-Business Tax Source: Relatório de Ganho/Perda sobre Impostos de Entrada - Cingapura (XML) - Não Suportado: Reservado para Uso Futuro Short Name: ZXSGAGAL_XML DB package: ZX_ZXAPJAJL_XMLP_PKG RU ZX Отчет о прибылях и убытках по уплаченному налогу (Сингапур)- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Отчет о прибылях и убытках по уплаченному налогу (Сингапур) Application: Налоги для электронного бизнеса Source: Отчет о прибылях и убытках по уплаченному налогу (Сингапур) (XML) - не поддерживается: зарезервировано для будущего использования Short Name: ZXSGAGAL_XML DB package: ZX_ZXAPJAJL_XMLP_PKG S ZX Singaporeansk vinst-/förlustrapport över inkommande moms- stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Singaporeansk vinst-/förlustrapport över inkommande moms Application: E-Business Tax Source: Singaporeansk vinst-/förlustrapport över inkommande moms (XML) - stöds inte: Reserverad för framtida bruk Short Name: ZXSGAGAL_XML DB package: ZX_ZXAPJAJL_XMLP_PKG TR ZX Singapur Girdi Vergileri Kar/Zarar Raporu- Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Imported from BI Publisher Description: Singapur Girdi Vergileri Kar/Zarar Raporu Application: eİş Vergi Yönetimi Source: Singapur Girdi Vergileri Kar/Zarar Raporu (XML) - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Short Name: ZXSGAGAL_XML DB package: ZX_ZXAPJAJL_XMLP_PKG US ZX Singaporean Input Taxes Gain/Loss Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Singaporean Input Taxes Gain/Loss Report Application: E-Business Tax Source: Singaporean Input Taxes Gain/Loss Report (XML) - Not Supported: Reserved For Future Use Short Name: ZXSGAGAL_XML DB package: ZX_ZXAPJAJL_XMLP_PKG ZHS ZX 新加坡进项税损益报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 新加坡进项税损益报表 Application: Oracle E-Business Tax Source: 新加坡进项税损益报表 (XML) - 不支持：已保留供将来使用 Short Name: ZXSGAGAL_XML DB package: ZX_ZXAPJAJL_XMLP_PKG BI Publisher :cf_tot_amount :cf_tot_func_amt :cp_end_of_report :cp_nls_all :cp_nls_na :cp_nls_no :cp_nls_void :cp_nls_yes :cp_no_data_found :cp_report_title :cp_reporting_entity_name :cp_reporting_level_name :cp_trl_row_count :cp_trx_id :cp_trx_id_acc :cp_trx_line_id :cp_trx_line_id_acc :e :lp_group :lp_product :lp_tax_register_type :p_accounting_status :p_acct_period_from :p_acct_period_to :p_base_report_name :p_batch_date_from :p_batch_date_to :p_batch_name :p_cd_date_from :p_cd_date_to :p_cd_number_from :p_cd_number_to :p_company_name :p_company_name_desc :p_conc_request_id :p_date4_format :p_debug_switch :p_detail_level :p_error_message :p_excise_tax_type_from :p_excise_tax_type_to :p_excluding_trx_letter :p_functional_currency_code :p_gl_date_high :p_gl_date_low :p_gl_period_name_high :p_gl_period_name_low :p_gui_number_from :p_gui_number_to :p_gui_type :p_include_ap_cm_trx_class :p_include_ap_dm_trx_class :p_include_ap_exp_trx_class :p_include_ap_int_trx_class :p_include_ap_mix_trx_class :p_include_ap_prep_trx_class :p_include_ap_std_trx_class :p_include_ar_adj_trx_class :p_include_ar_inv_trx_class :p_include_gl_manual_lines :p_ledger_currency :p_ledger_id :p_muni_tax_type_from :p_muni_tax_type_to :p_non_taxable_type :p_order_by :p_perc_tax_type_from :p_perc_tax_type_to :p_period_end_date :p_period_start_date :p_print_company_info :p_product :p_prov_tax_type_from :p_prov_tax_type_to :p_rep_context_entity_name :p_rep_context_lvl_mng :p_report_name :p_report_ordered_by :p_reporting_entity_id :p_reporting_level :p_reprint :p_responsibility_name :p_sort_by_country :p_standard_vat_rate :p_summarize_report :p_supplier_id :p_supplier_name :p_tax :p_tax_code_high :p_tax_code_low :p_tax_jurisdiction :p_tax_rate_code :p_tax_regime :p_tax_register_type :p_tax_status_code :p_tax_type_high :p_tax_type_low :p_trace_switch :p_trx_date_high :p_trx_date_low :p_trx_letter_from :p_trx_letter_to :p_trx_number_high :p_trx_number_low :p_tw_batch_date_from :p_tw_batch_date_to :p_tw_gl_date_high :p_tw_gl_date_low :p_tw_trx_date_high :p_tw_trx_date_low :p_user_name :p_vat_perc_tax_type :p_vat_tax_type :program_where 1 -110 :p_report_name Char ZXSGAGAL Y AR اسم التقرير اسم التقرير/القالب D Auswertungsbezeichnung Auswertung/Vorlagenbezeichnung E Nombre del Informe Nombre de Plantilla/Informe F Nom de l'état Nom du modèle/de l'état I Nome rapporto Nome del rapporto/modello JA レポート名 レポート/テンプレート名 KO 보고서명 보고서/템플리트명 PTB Nome do Relatório Nome do Relatório/Modelo RU Имя отчета Имя отчета/шаблона S Rapport Namn på rapport/mall TR Rapor Adı Rapor/Şablon Adı US Report Name Report/Template Name ZHS 报表名称 报表/模板名 2 -100 :p_tax_register_type LOV Oracle ZX_TRL_REGISTER_TYPE Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='ZX_TRL_REGISTER_TYPE' order by value,description select meaning from fnd_lookups where lookup_type = 'ZX_TRL_REGISTER_TYPE' and lookup_code = 'ALL' US P_REGISTER_TYPE P_REGISTER_TYPE 3 -90 :p_product LOV Oracle ZX_TRL_PRODUCT_CODE Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='ZX_TRL_PRODUCT_CODE' order by value,description select meaning from fnd_lookups where lookup_type = 'ZX_TRL_PRODUCT_CODE' and lookup_code = 'AP' US P_PRODUCT P_PRODUCT 4 -80 :p_include_ap_std_trx_class LOV Oracle ZX_TRL_YES_NO Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='ZX_TRL_YES_NO' order by meaning select meaning from fnd_lookups where lookup_type = 'ZX_TRL_YES_NO' and lookup_code = 'Y' US P_INCLUDE_AP_STD_TRX_CLASS P_INCLUDE_AP_STD_TRX_CLASS 5 -70 :p_include_ap_dm_trx_class LOV Oracle ZX_TRL_YES_NO Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='ZX_TRL_YES_NO' order by meaning select meaning from fnd_lookups where lookup_type = 'ZX_TRL_YES_NO' and lookup_code = 'Y' US P_INCLUDE_AP_DM_TRX_CLASS P_INCLUDE_AP_DM_TRX_CLASS 6 -60 :p_include_ap_cm_trx_class LOV Oracle ZX_TRL_YES_NO Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='ZX_TRL_YES_NO' order by meaning select meaning from fnd_lookups where lookup_type = 'ZX_TRL_YES_NO' and lookup_code = 'Y' US P_INCLUDE_AP_CM_TRX_CLASS P_INCLUDE_AP_CM_TRX_CLASS 7 -50 :p_include_ap_prep_trx_class LOV Oracle ZX_TRL_YES_NO Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='ZX_TRL_YES_NO' order by meaning select meaning from fnd_lookups where lookup_type = 'ZX_TRL_YES_NO' and lookup_code = 'N' US P_INCLUDE_AP_PREP_TRX_CLASS P_INCLUDE_AP_PREP_TRX_CLASS 8 -40 :p_include_ap_mix_trx_class LOV Oracle ZX_TRL_YES_NO Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='ZX_TRL_YES_NO' order by meaning select meaning from fnd_lookups where lookup_type = 'ZX_TRL_YES_NO' and lookup_code = 'N' US P_INCLUDE_AP_MIX_TRX_CLASS P_INCLUDE_AP_MIX_TRX_CLASS 9 -30 :p_include_ap_exp_trx_class LOV Oracle ZX_TRL_YES_NO Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='ZX_TRL_YES_NO' order by meaning select meaning from fnd_lookups where lookup_type = 'ZX_TRL_YES_NO' and lookup_code = 'N' US P_INCLUDE_AP_EXP_TRX_CLASS P_INCLUDE_AP_EXP_TRX_CLASS 10 -20 :p_include_ap_int_trx_class LOV Oracle ZX_TRL_YES_NO Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='ZX_TRL_YES_NO' order by meaning select meaning from fnd_lookups where lookup_type = 'ZX_TRL_YES_NO' and lookup_code = 'N' US P_INCLUDE_AP_INT_TRX_CLASS P_INCLUDE_AP_INT_TRX_CLASS 11 10 :p_rep_context_lvl_mng LOV Oracle XLE_LEGAL_REPORTING_LEVEL Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='FND_MO_REPORTING_LEVEL' order by value,description Y AR مستوى إعداد التقرير مستوى إعداد التقرير D Auswertungsebene Auswertungsebene E Nivel de Informe Nivel de informe F Niveau de reporting Niveau de reporting I Livello di dichiarazione Livello di dichiarazione JA レポート・レベル レポート・レベル KO 신고 레벨 신고 레벨 PTB Nível do Relatório Nível do Relatório RU Уровень отчетности Уровень отчетности S Rapporteringsnivå Rapporteringsnivå TR Raporlama Düzeyi Raporlama Düzeyi US Reporting Level Reporting Level ZHS 申报级别 申报级别 12 20 :p_rep_context_entity_name LOV Oracle XLE_LEGAL_REPORTING_CONTEXT Y select entity_id id, entity_name value, null description from fnd_mo_reporting_entities_v where reporting_level=:$flex$.xle_legal_reporting_level order by value,description Y AR سياق إعداد التقرير سياق إعداد التقرير D Auswertungskontext Auswertungskontext E Contexto del Informe Contexto del informe F Contexte de reporting Contexte de reporting I Contesto di dichiarazione Contesto di dichiarazione JA レポート・コンテキスト レポート・コンテキスト KO 신고 컨텍스트 신고 컨텍스트 PTB Contexto do Relatório Contexto do Relatório RU Контекст отчетности Контекст отчетности S Rapporteringssammanhang Rapporteringssammanhang TR Raporlama İçeriği Raporlama İçeriği US Reporting Context Reporting Context ZHS 申报环境 申报环境 13 30 :p_compant_name LOV Oracle ZX_COMPANY_NAME Y select legal_entity_id id, legal_entity_name value, null description from gl_ledger_le_v where :$flex$.xle_legal_reporting_level='1000' and ledger_id=:$flex$.xle_legal_reporting_context order by value,description AR اسم الشركة الكيان القانوني لدفتر أستاذ محدد D Firmenname Mandanten für ein bestimmtes Buch E Nombre de Compañía Entidad jurídica para un libro mayor determinado F Nom de la société Entité juridique pour un livre donné I Nome società Persona giuridica per un libro contabile determinato JA 会社名 指定元帳の法的エンティティ KO 회사명 지정된 원장의 법인 PTB Nome da Empresa Pessoa Jurídica para um Razão fornecido RU Название компании Юридическое лицо для данной книги S Företag Juridisk enhet för en angiven bokföringsbok TR Şirket Adı Belirtilen Defter için Tüzel Kişilik US Company Name Legal Entity for a given Ledger ZHS 公司名称 指定分类帐的法人主体 14 40 :p_functional_currency_code LOV Oracle ZX_TRL_CURRENCY Y select currency_code id, currency_code value, name description from fnd_currencies_vl where currency_flag='Y' and enabled_flag in ('Y','N') order by currency_code select currency_code from gl_sets_of_books where set_of_books_id = fnd_profile.value('gl_set_of_bks_id') Y AR عملة دفتر الأستاذ عملة دفتر الأستاذ D Buchwährung Buchwährung E Divisa de Libro Mayor Divisa de Libro Mayor F Devise comptable Devise comptable I Divisa libro contabile Divisa libro contabile JA 元帳通貨 元帳通貨 KO 원장 통화 원장 통화 PTB Moeda do Razão Moeda do Razão RU Валюта книги Валюта книги S Huvudboksvaluta Huvudboksvaluta TR Defter Para Birimi Defter Para Birimi US Ledger Currency Ledger Currency ZHS 分类帐币种 分类帐币种 15 50 :p_acct_period_from LOV Oracle ZX_TRL_AP_PERIOD_NAMES Y select period_name id, period_name value, null description from gl_period_statuses where application_id=200 and set_of_books_id= (select ledger_id from gl_ledger_le_v where legal_entity_id=:$flex$.xle_legal_reporting_context and ledger_category_code='PRIMARY' and :$flex$.xle_legal_reporting_level=2000 union select gl.ledger_id from hr_organization_information o1, hr_organization_information o2, gl_ledgers_public_v gl where o1.organization_id=o2.organization_id and o1.organization_id=:$flex$.xle_legal_reporting_context and ledger_category_code='PRIMARY' and :$flex$.xle_legal_reporting_level=3000 and o1.org_information_context='CLASS' and o2.org_information_context='Operating Unit Information' and o1.org_information1='OPERATING_UNIT' and o1.org_information2='Y' and o2.org_information3=gl.ledger_id union select to_number(:$flex$.xle_legal_reporting_context) from dual where :$flex$.xle_legal_reporting_level=1000 ) order by period_year desc,period_num desc AR بداية الفترة المحاسبية بداية الفترة المحاسبية D Von Buchungsperiode Von Buchungsperiode E De Período Contable De período contable F Période comptable de début Période comptable de début I Periodo contabile iniziale Periodo contabile iniziale JA 会計期間: 自 会計期間: 自 KO 회계 기간 시작 회계 기간 시작 PTB Período Contábil Inicial Período Contábil Inicial RU Начальный учетный период Начальный учетный период S Från redovisningsperiod Från redovisningsperiod TR Muhasebe Dönemi Başlangıcı Muhasebe Dönemi Başlangıcı US Start Accounting Period Start Accounting Period ZHS 起始会计期 起始会计期 16 60 :p_acct_period_to LOV Oracle ZX_TRL_AP_PERIOD_NAMES Y select period_name id, period_name value, null description from gl_period_statuses where application_id=200 and set_of_books_id= (select ledger_id from gl_ledger_le_v where legal_entity_id=:$flex$.xle_legal_reporting_context and ledger_category_code='PRIMARY' and :$flex$.xle_legal_reporting_level=2000 union select gl.ledger_id from hr_organization_information o1, hr_organization_information o2, gl_ledgers_public_v gl where o1.organization_id=o2.organization_id and o1.organization_id=:$flex$.xle_legal_reporting_context and ledger_category_code='PRIMARY' and :$flex$.xle_legal_reporting_level=3000 and o1.org_information_context='CLASS' and o2.org_information_context='Operating Unit Information' and o1.org_information1='OPERATING_UNIT' and o1.org_information2='Y' and o2.org_information3=gl.ledger_id union select to_number(:$flex$.xle_legal_reporting_context) from dual where :$flex$.xle_legal_reporting_level=1000 ) order by period_year desc,period_num desc AR نهاية الفترة المحاسبية نهاية الفترة المحاسبية D Bis Buchungsperiode Bis Buchungsperiode E A Período Contable A período contable F Période comptable de fin Période comptable de fin I Periodo contabile finale Periodo contabile finale JA 会計期間: 至 会計期間: 至 KO 회계 기간 종료 회계 기간 종료 PTB Período Contábil Final Período Contábil Final RU Конечный учетный период Конечный учетный период S Till redovisningsperiod Till redovisningsperiod TR Muhasebe Dönemini Bitişi Muhasebe Dönemini Bitişi US End Accounting Period End Accounting Period ZHS 终止会计期 终止会计期 17 70 :p_tax_regime LOV Oracle ZX_TRL_TAX_REGIME_CODE Y select tax_regime_code id, tax_regime_code value, tax_regime_name description from zx_regimes_vl where has_sub_regime_flag='N' order by value,description AR رمز النظام الضريبي رمز النظام الضريبي D Schlüssel Steuersystem Schlüssel Steuersystem E Código de Régimen Fiscal Código de régimen fiscal F Code régime fiscal Code régime fiscal I Codice regime fiscale Codice regime fiscale JA 税制コード 税制コード KO 조세 제도 코드 조세 제도 코드 PTB Código do Regime Fiscal Código do Regime Fiscal RU Код налогового режима Код налогового режима S Skatteförvaltningskod Skatteförvaltningskod TR Vergi Uygulama Kodu Vergi Uygulama Kodu US Tax Regime Code Tax Regime Code ZHS 税收制度代码 税收制度代码 18 80 :p_tax LOV Oracle ZX_TRL_TAX Y select tax id, tax value, tax_full_name description from zx_taxes_vl where tax_regime_code=:$flex$.zx_trl_tax_regime_code order by value,description AR الضريبة الضريبة D Steuer Steuer E Impuesto Impuesto F Taxe Taxe I Imposta Imposta JA 税金 税金 KO 세금 세금 PTB Imposto Imposto RU Налог Налог S Skatt Skatt TR Vergi Vergi US Tax Tax ZHS 税 税 19 90 :p_tax_jurisdiction LOV Oracle ZX_TRL_TAX_JURISDICTION Y select tax_jurisdiction_code id, tax_jurisdiction_code value, tax_jurisdiction_name description from zx_jurisdictions_vl where tax_regime_code=:$flex$.zx_trl_tax_regime_code and tax=:$flex$.zx_trl_tax order by value,description AR جهة الاختصاص الضريبي جهة الاختصاص الضريبي D Steuerzuständigkeit Steuerzuständigkeit E Jurisdicción Fiscal Jurisdicción fiscal F Juridiction de taxe Juridiction de taxe I Giurisdizione imposta Giurisdizione imposta JA 税管轄区域 税管轄区域 KO 세금 관할 법원 세금 관할 구역 PTB Jurisdição do Imposto Jurisdição do Imposto RU Налоговая юрисдикция Налоговая юрисдикция S Skatteområde Skatteområde TR Vergi Yasası Vergi Yasası US Tax Jurisdiction Tax Jurisdiction ZHS 税务管辖区 税务管辖区 20 100 :p_tax_status_code LOV Oracle ZX_TRL_TAX_STATUS_CODE Y select tax_status_code id, tax_status_code value, tax_status_name description from zx_status_vl where tax_regime_code=:$flex$.zx_trl_tax_regime_code and tax=:$flex$.zx_trl_tax order by value,description AR رمز معدل الضريبة رمز موقف الضريبة D Schlüssel Steuersatz Schlüssel Steuerstatus E Código de Tipo Impositivo Código de estado fiscal F Code taux de taxe Code statut de taxe I Codice aliquota Codice stato imposta JA 税率コード 税金ステータス・コード KO 세율 코드 과세 상태 코드 PTB Código da Alíquota de Imposto Código do Status do Imposto RU Код налоговой ставки Коды налогового статуса S Kod för skattesats Kod för skattestatus TR Vergi Oran Kodu Vergi Statüsü Kodu US Tax Rate Code Tax Status Code ZHS 税率代码 纳税状态代码 21 110 :p_tax_rate_code LOV Oracle ZX_TRL_TAX_RATE_CODE Y select tax_rate_code id, tax_rate_code value, tax_rate_name description from zx_rates_vl where tax_regime_code=:$flex$.zx_trl_tax_regime_code and tax=:$flex$.zx_trl_tax and tax_status_code=:$flex$.zx_trl_tax_status_code and active_flag='Y' order by value,description AR رمز معدل الضريبة 2 رمز معدل الضريبة D Schlüssel Steuersatz 2 Schlüssel Steuersatz E Código de Tipo Impositivo 2 Código de tipo impositivo F Code taux de taxe 2 Code taux de taxe I Codice aliquota 2 Codice aliquota JA 税率コード 2 税率コード KO 세율 코드 2 세율 코드 PTB Código da Alíquota de Imposto 2 Código da Alíquota de Imposto RU Код налоговой ставки 2 Код налоговой ставки S Kod för skattesats 2 Kod för skattesats TR Vergi Oran Kodu 2 Vergi Oran Kodu US Tax Rate Code 2 Tax Rate Code ZHS 税率代码 2 税率代码 22 120 :p_supplier_name LOV Oracle ZX_TRL_AP_SUPPLIERS Y select vendor_id id, vendor_name value, null description from po_vendors order by value,description AR اسم المورد اسم المورد D Lieferantenname Lieferantenname E Nombre de Proveedor Nombre de proveedor F Nom du fournisseur Nom du fournisseur I Nome fornitore Nome fornitore JA 仕入先名 仕入先名 KO 공급자명 공급자명 PTB Nome do Fornecedor Nome do Fornecedor RU Имя поставщика Имя поставщика S Leverantör Leverantör TR Tedarikçi Adı Tedarikçi Adı US Supplier Name Supplier Name ZHS 供应商名称 供应商名称