ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472DE51A9E05362FB09050512 SELECT DET.LEDGER_ID C_LEDGER_ID, DET.LEDGER_NAME C_LEDGER_NAME, DET.FUNCTIONAL_CURRENCY_CODE C_FUNC_CURRENCY_CODE, CON.REP_CONTEXT_ENTITY_NAME C_ORGANIZATION_UNIT_NAME, CON.TAXPAYER_ID C_Taxpayer_ID, 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, CON.REP_CONTEXT_ENTITY_CITY C_REP_CONTEXT_CITY, DET.TERRITORY_SHORT_NAME C_TERRITORY_SHORT_NAME, CON.REP_CONTEXT_ENTITY_POSTAL_CODE C_REP_CONTEXT_POSTAL_CODE, CON.REP_CONTEXT_ENTITY_PROVINCE C_REP_CONTEXT_PROVINCE, CON.LEGAL_CONTACT_PARTY_NAME C_TAXABLE_PERSON, CON.ACTIVITY_CODE C_SERVICE_TYPE, CON.LEGAL_CONTACT_PARTY_NAME C_LEGAL_REPRESENTATIVE, CON.LEGAL_CONTACT_PARTY_NUM C_REPRESENTATIVE_TAX_ID, DET.BILLING_TP_NUMBER C_CUSTOMER_TAXPAYER_ID, DET.BILLING_TP_NAME C_CUST_NAME, DET.BILLING_TP_TAXPAYER_ID C_BILLING_TP_TAXPAYER_ID, DET.BILLING_TP_TAX_REG_NUM C_BILLING_TP_TAX_REG_NUM, EXT.GDF_RA_CUST_BILL_ATT12 C_GDF_RA_CUST_BILL_ATT12, EXT.GDF_RA_CUST_BILL_ATT10 C_CUST_TAX_ID_TYPE, EXT.ATTRIBUTE8 C_CUST_VAT_REC_CODE, EXT.ATTRIBUTE7 C_DGI_CUST_CONDITION_CODE, DET.TRX_ID C_TRANSACTION_ID, DET.EXTRACT_SOURCE_LEDGER C_EXTRACT_SOURCE_LEDGER, DET.TRX_NUMBER C_TRX_NUMBER, DET.TRX_CURRENCY_CODE C_TRX_CURRENCY_CODE, nvl(DET.CURRENCY_CONVERSION_RATE,1) C_EXCHANGE_RATE, substrb(DOCUMENT_SUB_TYPE, 10,2) C_DOCUMENT_SUB_TYPE, DET.APPLIED_TO_TRX_NUMBER C_APPLIED_TO_TRX_NUMBER, DET.TRX_BATCH_SOURCE_NAME C_TRX_BATCH_SOURCE_NAME, decode(:P_TRX_SOURCE_NAME,NULL,NULL,DET.TRX_BATCH_SOURCE_NAME) C_PAR_TRX_BATCH_SRC_NAME, DET.DOC_EVENT_STATUS C_DOC_EVENT_STATUS, EXT.GDF_RA_CUST_TRX_ATT9 C_ORIGINAL_TRX_NUMBER, DET.TRX_TYPE_MNG C_TRX_TYPE_MEANING, to_char(DET.TRX_DATE,'YYYY-MM-DD') C_TRX_DATE, to_char(DET.TRX_DUE_DATE,'YYYY-MM-DD') C_TRX_SHIPPING_DATE, DET.EVENT_CLASS_CODE C_TRX_CLASS_CODE, DET.trx_line_id C_TRANSACTION_LINE, DET.DOC_SEQ_NAME C_DOC_SEQ_NAME, DET.DOC_SEQ_VALUE C_DOC_SEQ_VALUE, EXT.GDF_RA_CUST_TRX_ATT19 C_GDF_RA_CUST_TRX_ATT19, EXT.GDF_RA_CUST_TRX_TYPES_ATT5 C_GDF_RA_CUST_TRX_TYPES_ATT5, 0 C_VOID_AMOUNT, 0 C_VOID_RATE, EXT.ATTRIBUTE4 C_EXPORT_METHOD, EXT.ATTRIBUTE5 C_EXPORT_NAME, EXT.ATTRIBUTE6 C_EXPORT_TYPE, EXT.GDF_RA_CUST_TRX_ATT8 C_EXPORT_DATE, EXT.GDF_RA_CUST_TRX_ATT4 C_EXPORT_NUMBER, DET.TRX_BUSINESS_CATEGORY C_TRX_BUSINESS_CATEGORY, decode(substrb(DET.TRX_BUSINESS_CATEGORY,1,14), 'EXPENSE_REPORT', substrb(DET.TRX_BUSINESS_CATEGORY, 32), 'PURCHASE_PREPA', substrb(DET.TRX_BUSINESS_CATEGORY, 48), 'PURCHASE_TRANS', substrb(DET.TRX_BUSINESS_CATEGORY, 38), 'SALES_TRANSACT', substrb(DET.TRX_BUSINESS_CATEGORY, 19) ) C_DEDUCTIBLE_CODE, EXT.TRX_BUSINESS_CATEGORY_MNG C_DEDUCTIBLE_CODE_MEAN, DET.PRODUCT_FISC_CLASSIFICATION C_PRODUCT_FC, DET.GDF_FND_CURRENCIES_ATT1 C_GDF_FND_CURRENCIES_ATT1, EXT.ATTRIBUTE10 C_DGI_TAX_TYPE_CODE, EXT.GDF_RA_CUST_BILL_ATT10 C_GDF_RA_CUST_BILL_ATT10, EXT.ATTRIBUTE4 C_DGI_TRX_TYPE_CODE, EXT.ATTRIBUTE11 C_DGI_CODE, DET.TAX_REGIME_CODE C_DGI_TAX_REGIME_CODE, EXT.GDF_PARTY_SITES_BILL_ATT8 C_DGI_RESP_TYPE_CODE, DET.TRX_BATCH_SOURCE_ID C_BATCH_SOURCE_ID, EXT.GDF_RA_BATCH_SOURCES_ATT7 C_FISCAL_PRINTER, DET.SUPPLIER_TAX_INVOICE_NUMBER C_CAI, to_char(DET.SUPPLIER_TAX_INVOICE_DATE,'YYYY-MM-DD') C_CAI_DUE_DATE, DET.TRX_LINE_QUANTITY C_TAXABLE_QUANTITY, DET.UOM_CODE C_TAXAB_QUANTITY_UOM_CODE, DET.TRX_QUANTITY_UOM_MNG C_TAXAB_QUAN_UOM_MEANING, EXT.GDF_RA_BATCH_SOURCES_ATT1 C_BATCH_SOURCES_ATT1, EXT.GDF_RA_BATCH_SOURCES_ATT2 C_INITIAL_TRX_NUM, EXT.GDF_RA_BATCH_SOURCES_ATT3 C_INVOICE_WORD, EXT.GDF_RA_BATCH_SOURCES_ATT4 C_FINAL_TRX_NUM, DET.TAX_TYPE_CODE C_TAX_TYPE, DET.TAX_RATE_ID C_TAX_CODE_ID, DET.TAX_RATE_CODE C_TAX_CODE, DET.TAX_RATE_CODE_DESCRIPTION C_TAX_CODE_DESC, DET.TAX_RATE C_TAX_CODE_RATE, EXT.GDF_PARTY_SITES_BILL_ATT9 C_USE_SITE_PROF, EXT.ATTRIBUTE8 C_VAT_REG_STATUS_CODE, DET.TAX_STATUS_CODE C_TAX_STATUS_CODE, EXT.TAX_STATUS_MNG C_GOV_TAX_TYPE_MEAN, NULL C_TAX_CATEGORY_ID, EXT.ATTRIBUTE5 C_GL_ACCT_TO_DEB, EXT.ATTRIBUTE1 C_JL_TURNOVER_JURIS_CODE, EXT.ATTRIBUTE3 C_JL_MUNICIPAL_JURIS_CODE, EXT.ATTRIBUTE1 C_TW_WINE_CIGARETTE, DET.POSTED_FLAG C_POSTED_FLAG, DET.TAXABLE_AMT C_TAXABLE_AMT, DET.TAX_AMT C_TAX_AMT, nvl(DET.TAXABLE_AMT_FUNCL_CURR,det.taxable_amt) C_TAXABLE_ACCOUNTED_AMOUNT, DET.TAXABLE_AMT C_TAXABLE_ENTERED_AMOUNT, nvl(DET.TAX_AMT_FUNCL_CURR ,det.tax_amt) C_TAX_ACCOUNTED_AMOUNT, DET.TAX_AMT C_TAX_ENTERED_AMOUNT, EXT.NUMERIC12 C_EXTENDED_AMOUNT, EXT.NUMERIC14 C_EXEMPT_ACCTD_AMOUNT, EXT.NUMERIC1 C_JL_NOT_REGIST_TAX_AMOUNT, EXT.NUMERIC2 C_JL_VAT_EXEMPT_AMOUNT, EXT.NUMERIC3 C_JL_VAT_PERCEP_AMOUNT, EXT.NUMERIC4 C_JL_PROV_PRECEP_AMOUNT, EXT.NUMERIC5 C_JL_MUNIC_PERCEP_AMOUNT, EXT.NUMERIC6 C_JL_EXCISE_AMOUNT, EXT.NUMERIC7 C_JL_OTHER_TAX_AMOUNT, EXT.NUMERIC8 C_JL_NON_TAXABLE_AMOUNT, EXT.NUMERIC9 C_JL_VAT_AMOUNT, EXT.NUMERIC10 C_JL_TAXABLE_AMOUNT, EXT.NUMERIC11 C_JL_VAT_ADDITIONAL_AMOUNT, EXT.NUMERIC11 C_AR_REC_COUNT, EXT.NUMERIC13 C_AR_VAT_OR_NONVAT_COUNT, EXT.NUMERIC1 C_TW_CNT_TAXABLE_AMOUNT, EXT.NUMERIC12 C_JL_TOTAL_DOCUMENT_AMOUNT, EXT.NUMERIC15 C_JL_TOTAL_AMT, nvl(EXT.NUMERIC2,0) + nvl(EXT.NUMERIC10,0) + nvl(EXT.NUMERIC9,0) + nvl(EXT.NUMERIC7,0) C_JL_TOTAL_AMOUNT_CLRSL, DET.TAX_LINE_USER_CATEGORY C_TAX_CATEGORY, EXT.ATTRIBUTE1 C_TAX_CATEGORY_DESC , ACT. ACCOUNT_FLEXFIELD C_TAX_ACCOUNT , DET.BILLING_TP_SITE_NAME C_BILLING_TP_SITE_NAME, DET.TRX_LINE_NUMBER C_TRX_LINE_NUMBER , DET.TAX_LINE_NUMBER C_TAX_LINE_NUMBER , DET.TAX_AMT + DET.TAXABLE_AMT C_TOT_AMOUNT , DET.TRX_LINE_AMT - DET.TAXABLE_AMT C_EXEMPT_ENTERED_AMOUNT , DET.TRX_LINE_AMT C_LINE_AMOUNT , DECODE(DET.application_doc_status,'VD','Yes','No') C_VOID, to_char(to_date(EXT.ATTRIBUTE15,'DD-MON-YYYY'),'RRRR/MM/DD') C_TRX_TW_DATE, nvl(DET.TAXABLE_AMT_FUNCL_CURR,det.taxable_amt) + nvl(nvl(DET.TAX_AMT_FUNCL_CURR,det.tax_amt),0) C_TOT_ACCOUNTED_AMOUNT, NULL C_TAX_CLASS, EXT.GDF_RA_CUST_TRX_ATT5 C_TW_EXPORT_NAME, EXT.GDF_RA_CUST_TRX_ATT6 C_TW_EXPORT_METHOD, EXT.GDF_RA_CUST_TRX_ATT7 C_TW_EXPORT_TYPE, DET.RELATED_DOC_NUMBER C_RELATED_DOC_NUMBER, DET.TAX_EXEMPT_REASON_MNG C_EXEMPT_REASON, DET.EXEMPT_CERTIFICATE_NUMBER C_EXEMPT_CERTIFICATE_NUMBER, DET.TRX_LINE_DESCRIPTION C_TRX_LINE_DESC, DET.TRX_LINE_CLASS C_TRX_TYPE, DET.BILLING_TP_COUNTY C_BILLING_TP_COUNTY, DET.BILLING_TP_CITY C_BILLING_TP_CITY, DET.BILLING_TP_STATE C_BILLING_TP_STATE, EXT.NUMERIC2 C_AMOUNT_RECEIVED, EXT.NUMERIC1 C_TAX_AMOUNT_RECEIVED, DET.ADJUSTED_DOC_NUMBER C_ADJUSTED_DOC_NUMBER, nvl(DET.TAXABLE_AMT_FUNCL_CURR,det.taxable_amt) + nvl(nvl(DET.TAX_AMT_FUNCL_CURR,det.tax_amt),0) C_TOT_FUNC_AMT, ACT.TRX_TAXABLE_BALANCING_SEGMENT C_COMPANY, ACT.TRX_TAXABLE_BALSEG_DESC C_COMPANY_DESC, ACT.ACTG_LINE_CCID C_CCID, ACT.ACCOUNT_FLEXFIELD C_FLEXFIELD, ACT.ACCOUNT_DESCRIPTION C_FLEXDATA_DESC, DET.GL_DATE C_GL_DATE, DET.SHIPPING_TP_ADDRESS1||DET.SHIPPING_TP_ADDRESS2||DET.SHIPPING_TP_ADDRESS2 C_SHIP_ADDRESS, EXT.NUMERIC1 C_GL_ACTIVITY_DISP, NULL C_SUM_COMP_GL_ACT_DISP, EXT.ATTRIBUTE1 C_BAL_SEGMENT_PROMPT, DET.HQ_ESTB_REG_NUMBER C_FIRST_PARTY_TAX_REG_NUM, EXT.DOCUMENT_SUB_TYPE_MNG C_DOCUMENT_SUB_TYPE_MNG, CON.ORG_INFORMATION2 C_ORG_INFORMATION2, DECODE(SUBSTRB(DET.DOCUMENT_SUB_TYPE, 10,2), '31', DET.TRX_NUMBER, '32', DET.TRX_NUMBER, '33', DET.APPLIED_TO_TRX_NUMBER, '34', DET.APPLIED_TO_TRX_NUMBER, '35', DET.TRX_NUMBER, '36', DET.TRX_NUMBER, '37', DET.TRX_NUMBER, DET.TRX_NUMBER, NULL, '**********') C_TW_GUI_NUMBER, 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_TRX_DATE, DET.TAX_TYPE_MNG C_TAX_RATE_CODE_TYPE_MEANING, ZX_ZXARRECV_XMLP_PKG.cf_tw_export_dateformula(EXT.GDF_RA_CUST_TRX_ATT8) CF_TW_EXPORT_DATE, ZX_ZXARRECV_XMLP_PKG.cf_taxable_acc_amtformula(DET.TRX_ID, DET.trx_line_id) CF_TAXABLE_ACC_AMT, ZX_ZXARRECV_XMLP_PKG.cf_taxable_amtformula(DET.TRX_ID, DET.trx_line_id) CF_TAXABLE_AMT, ZX_ZXARRECV_XMLP_PKG.CF_TOT_FUNC_AMT_p CF_TOT_FUNC_AMT, ZX_ZXARRECV_XMLP_PKG.CF_TOT_AMOUNT_p CF_TOT_AMOUNT, ZX_ZXARRECV_XMLP_PKG.CP_TRX_LINE_ID_p CP_TRX_LINE_ID, ZX_ZXARRECV_XMLP_PKG.CP_TRX_ID_p CP_TRX_ID, ZX_ZXARRECV_XMLP_PKG.CP_TRX_ID_ACC_p CP_TRX_ID_ACC, ZX_ZXARRECV_XMLP_PKG.CP_TRX_LINE_ID_ACC_p CP_TRX_LINE_ID_ACC FROM ZX_REP_TRX_JX_EXT_T EXT, ZX_REP_CONTEXT_T CON, ZX_REP_TRX_DETAIL_T DET, 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 ZXTWRZTR_XML AR ZX تقرير ضريبة بمعدل صفري للمقبوضات في تايوان (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: تقرير ضريبة بمعدل صفري للمقبوضات التايوانية Application: الضرائب في E-Business Source: تقرير ضريبة بمعدل صفري للمقبوضات في تايوان (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: ZXTWRZTR_XML DB package: ZX_ZXARRECV_XMLP_PKG D ZX Debitoren - Nullsteuersatz- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Taiwan: Debitorenauswertung "Nullsteuersatz" Application: E-Business Tax Source: Taiwan: Debitoren - Nullsteuersatz (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: ZXTWRZTR_XML DB package: ZX_ZXARRECV_XMLP_PKG E ZX Taiwán - Informe de Tipo Impositivo Cero de Cuentas a Cobrar: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Taiwán - tipo impositivo cero de cuentas a cobrar Application: E-Business Tax Source: Taiwán - Informe de Tipo Impositivo Cero de Cuentas a Cobrar (XML): No Admitido, Reservado para Uso Futuro Short Name: ZXTWRZTR_XML DB package: ZX_ZXARRECV_XMLP_PKG F ZX Taiwan - Receivables - Etat des taxes de taux zéro- Non pris en charge : réservé pour une utilisation ultérieure Imported from BI Publisher Description: Taiwan - Receivables - Etat des taxes de taux zéro Application: E-Business Tax Source: Taiwan - Receivables - Etat des taxes de taux zéro (XML) - Non pris en charge : réservé pour une utilisation ultérieure Short Name: ZXTWRZTR_XML DB package: ZX_ZXARRECV_XMLP_PKG I ZX Taiwan - rapporto Imposta aliquota zero Receivables- non supportato: riservato per usi futuri Imported from BI Publisher Description: Taiwan - rapporto Imposta aliquota zero Receivables Application: E-Business Tax Source: Taiwan - rapporto Imposta aliquota zero Receivables (XML) - non supportato: riservato per usi futuri Short Name: ZXTWRZTR_XML DB package: ZX_ZXARRECV_XMLP_PKG JA ZX Taiwanese Receivables Zero-Rate Tax Report- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: Taiwanese Receivables Zero-Rate Tax Report Application: E-Business Tax Source: Taiwanese Receivables Zero-Rate Tax Report (XML) - 未サポート: 将来の使用のために予約 Short Name: ZXTWRZTR_XML DB package: ZX_ZXARRECV_XMLP_PKG KO ZX 대만 AR 0 세율 세금 보고서- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 대만 AR 0 세율 세금 보고서 Application: E-Business Tax Source: 대만 AR 0 세율 세금 보고서(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: ZXTWRZTR_XML DB package: ZX_ZXARRECV_XMLP_PKG PTB ZX Relatório de Impostos com Taxa Zero do Receivables - Taiwan- Não Suportado: Reservado para Uso Futuro Imported from BI Publisher Description: Relatório de Imposto com Taxa Zero do Contas a Receber - Taiwan Application: E-Business Tax Source: Relatório de Impostos com Taxa Zero do Receivables - Taiwan (XML) - Não Suportado: Reservado para Uso Futuro Short Name: ZXTWRZTR_XML DB package: ZX_ZXARRECV_XMLP_PKG RU ZX отчет о налогах с нулевой ставкой (Тайвань)- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Отчет о налогах с нулевой ставкой при расчетах с дебиторами (Тайвань) Application: Налоги для электронного бизнеса Source: Дебиторы: отчет о налогах с нулевой ставкой (Тайвань) (XML) - не поддерживается: зарезервировано для будущего использования Short Name: ZXTWRZTR_XML DB package: ZX_ZXARRECV_XMLP_PKG S ZX Rapport över skattebefrielse i taiwanesisk Kundreskontra- stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Rapport över skattebefrielse i taiwanesisk Kundreskontra Application: E-Business Tax Source: Rapport över skattebefrielse i taiwanesisk Kundreskontra (XML) - stöds inte: Reserverad för framtida bruk Short Name: ZXTWRZTR_XML DB package: ZX_ZXARRECV_XMLP_PKG TR ZX Tayvan Alacaklar Muhasebesi Sıfır Oranlı Vergi- Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Imported from BI Publisher Description: Tayvan Alacaklar Muhasebesi Sıfır Oranlı Vergi Raporu Application: eİş Vergi Yönetimi Source: Tayvan Alacaklar Muhasebesi Sıfır Oranlı Vergi (XML) - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Short Name: ZXTWRZTR_XML DB package: ZX_ZXARRECV_XMLP_PKG US ZX Taiwanese Receivables Zero-Rate Tax Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Taiwanese Receivables Zero Rate Tax Report Application: E-Business Tax Source: Taiwanese Receivables Zero-Rate Tax Report (XML) - Not Supported: Reserved For Future Use Short Name: ZXTWRZTR_XML DB package: ZX_ZXARRECV_XMLP_PKG ZHS ZX 台湾应收款系统零税率税务报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 台湾应收款系统零税率税务报表 Application: Oracle E-Business Tax Source: 台湾应收款系统零税率税务报表 (XML) - 不支持：已保留供将来使用 Short Name: ZXTWRZTR_XML DB package: ZX_ZXARRECV_XMLP_PKG BI Publisher :cf_tot_amount :cf_tot_func_amt :cnt :cp_detail_level_mng :cp_end_of_report :cp_include_trx_type :cp_nls_no :cp_nls_yes :cp_no_data_found :cp_report_title :cp_reporting_entity_name :cp_reporting_level_name :cp_tax_category_desc :cp_trl_row_count :cp_trx_id :cp_trx_id_acc :cp_trx_line_id :cp_trx_line_id_acc :lp_acct_period_from :lp_acct_period_to :lp_cm_batch_source_name :lp_cm_trx_number :lp_doc_sequence_order :lp_extended_amount :lp_from_clause :lp_missing_seq :lp_missing_seq_final :lp_missing_sequence_final :lp_report_where :lp_tax_account :lp_void :p_accounting_status :p_acct_period_from :p_acct_period_to :p_adjusted_doc_from :p_adjusted_doc_to :p_application_date :p_base_report_name :p_coa_id :p_company_name :p_company_name_desc :p_conc_request_id :p_cust_name :p_customer_id :p_date4_format :p_detail_level :p_exc_tax_category :p_exc_tax_category_id :p_exp_method :p_export_date_from :p_export_date_high :p_export_date_low :p_export_date_to :p_export_method :p_format :p_functional :p_gl_activity_display_flag :p_gl_date_high :p_gl_date_low :p_include :p_include_accounting_segments :p_include_ar_adj_trx_class :p_include_ar_appl_trx_class :p_include_ar_br_trx_class :p_include_ar_inv_trx_class :p_include_ar_misc_trx_class :p_include_discounts :p_include_gl_manual_lines :p_include_referenced_source :p_ledger_id :p_mun_tax_categ_regime :p_order_by :p_org_id :p_org_trx_number_from :p_org_trx_number_to :p_period_end_date :p_period_start_date :p_posting_status :p_print_company :p_product :p_rep_context_entity_name :p_rep_context_lvl_mng :p_report_level :p_report_name :p_reporting_entity_id :p_reporting_level :p_responsibility_name :p_self_wh_tax_categ :p_state_high :p_state_low :p_tax_account_from :p_tax_account_to :p_tax_categ_regime :p_tax_code :p_tax_rate_code :p_tax_regime :p_tax_register_type :p_tax_type :p_trx_date_high :p_trx_date_low :p_trx_letter_from :p_trx_letter_to :p_trx_source_name :p_tw_export_date_high :p_tw_export_date_low :p_tw_gl_date_from :p_tw_gl_date_high :p_tw_gl_date_low :p_tw_gl_date_to :p_tw_trx_date_high :p_tw_trx_date_low :p_user_name :p_vat_addit_tax_category :p_vat_addit_tax_category_id :p_vat_non_taxab_tax_categ :p_vat_non_taxab_tax_categ_id :p_vat_not_categ_tax_categ :p_vat_not_categ_tax_categ_id :p_vat_perc_tax_category :p_vat_perc_tax_category_id :p_vat_tax_category :p_vat_tax_category_id 1 -90 :p_report_name Char ZXTWRZTR 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 -80 :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 -70 :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 = 'AR' US P_PRODUCT P_PRODUCT 4 -60 :p_include_ar_inv_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_AR_INV_TRX_CLASS P_INCLUDE_AR_INV_TRX_CLASS 5 -50 :p_include_ar_appl_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_AR_APPL_TRX_CLASS P_INCLUDE_AR_APPL_TRX_CLASS 6 -40 :p_include_ar_adj_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_AR_ADJ_TRX_CLASS P_INCLUDE_AR_ADJ_TRX_CLASS 7 -30 :p_include_ar_misc_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_AR_MISC_TRX_CLASS P_INCLUDE_AR_MISC_TRX_CLASS 8 -20 :p_include_ar_br_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_AR_BR_TRX_CLASS P_INCLUDE_AR_BR_TRX_CLASS 9 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 申报级别 申报级别 10 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 申报环境 申报环境 11 30 :p_company_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 Mandant für ein bestimmtes Buch E Nombre de Compañía Entidad jurídica de 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 o 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 given Ledger ZHS 公司名称 指定分类帐的法人主体 12 40 :p_gl_date_low Date Y AR تاريخ الأستاذ العام من تاريخ الأستاذ العام من D Von Buchungsdatum Von Buchungsdatum E De Fecha Contable De fecha contable F Date GL - Du Date GL - Du I Data GL - Da Data GL - Da JA GL記帳日: 自 GL記帳日: 自 KO GL 시작 일자 GL 시작 일자 PTB Data GL - De Data GL - De RU Дата ГК с Дата ГК с S Från bokf.datum Från bokf.datum TR GL Başlangıç Tarihi GL Başlangıç Tarihi US GL Date From GL Date From ZHS GL 日期自 GL 日期自 13 50 :p_gl_date_high Date Y AR تاريخ الأستاذ العام إلى تاريخ الأستاذ العام إلى D Bis Buchungsdatum Bis Buchungsdatum E A Fecha Contable A fecha contable F Date GL - Au Date GL - Au I Data GL - A Data GL - A JA GL記帳日: 至 GL記帳日: 至 KO GL 종료 일자 GL 종료 일자 PTB Data GL - Até Data GL - Até RU Дата ГК по Дата ГК по S Till bokf.datum Till bokf.datum TR GL Bitiş Tarihi GL Bitiş Tarihi US GL Date To GL Date To ZHS GL 日期至 GL 日期至 14 60 :p_trx_date_low Date AR تاريخ الحركة من تاريخ الحركة من D Von Transaktionsdatum Von Transaktionsdatum E De Fecha de Transacción De fecha de transacción F Date du mouvement - De Date du mouvement - De I Data transazione - Da Data transazione - Da JA 取引日: 自 取引日: 自 KO 거래 시작 일자 거래 시작 일자 PTB Data da Transação - De Data da Transação - De RU Дата транзакции с Дата транзакции с S Från transaktionsdatum Från transaktionsdatum TR İşlem Başlangıç Tarihi İşlem Başlangıç Tarihi US Transaction Date From Transaction Date From ZHS 事务处理起始日期 事务处理起始日期 15 70 :p_trx_date_high Date AR تاريخ الحركة إلى تاريخ الحركة إلى D Bis Transaktionsdatum Bis Transaktionsdatum E A Fecha de Transacción A fecha de transacción F Date de mouvement - Au Date de mouvement - Au I Data transazione - A Data transazione - A JA 取引日: 至 取引日: 至 KO 거래 종료 일자 거래 종료 일자 PTB Data da Transação - Até Data da Transação - Até RU Дата транзакции по Дата транзакции по S Till transaktionsdatum Till transaktionsdatum TR İşlem Bitiş Tarihi İşlem Bitiş Tarihi US Transaction Date To Transaction Date To ZHS 事务处理日期至 事务处理日期至 16 80 :p_exp_cert_date_from Date AR تاريخ التصدير من تاريخ التصدير من D Von Exportdatum Von Exportdatum E De Fecha de Exportación De fecha de exportación F Date d'exportation - Du Date d'exportation - Du I Data esportazione - Da Data esportazione - Da JA 輸出日: 自 輸出日: 自 KO 수출 시작 일자 수출 시작 일자 PTB Data de Exportação - De Data de Exportação - De RU Дата экспорта c Дата экспорта c S Från exportdatum Från exportdatum TR İlk Dışa Aktarım Tarihi İlk Dışa Aktarım Tarihi US Export Date From Export Date From ZHS 出口日期自 出口日期自 17 90 :p_exp_cert_date_to Date AR تاريخ التصدير إلى تاريخ التصدير إلى D Bis Exportdatum Bis Exportdatum E A Fecha de Exportación A fecha de exportación F Date d'exportation - Au Date d'exportation - Au I Data esportazione - A Data esportazione - A JA 輸出日: 至 輸出日: 至 KO 수출 종료 일자 수출 종료 일자 PTB Data de Exportação - Até Data de Exportação - Até RU Дата экспорта по Дата экспорта по S Till exportdatum Till exportdatum TR Son Dışa Aktarım Tarihi Son Dışa Aktarım Tarihi US Export Date To Export Date To ZHS 出口日期至 出口日期至 18 100 :p_exp_method LOV Oracle JATW_AR_EXPORT_METHOD Y select lookup_code id, meaning value, null description from ja_lookups where lookup_type='JATW_EXPORT_METHOD' order by value,description AR طريقة التصدير طريقة التصدير D Exportverfahren Exportverfahren E Método de Exportación Método de exportación F Méthode d'exportation Méthode d'exportation I Metodo di esportazione Metodo di esportazione JA 輸出方法 輸出方法 KO 수출 방법 수출 방법 PTB Método de Exportação Método de Exportação RU Метод экспорта Метод экспорта S Exportmetod Exportmetod TR Dışa Aktarma Yöntemi Dışa Aktarma Yöntemi US Export Method Export Method ZHS 出口方法 出口方法