ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4721851A9E05362FB09050512 SELECT invoice_payment.pay_doc_type inv_pay_doc_type ,invoice_payment.pay_acct_num inv_pay_acct_num ,invoice_payment.pay_header_id inv_pay_header_id ,invoice_payment.pay_line_num inv_pay_line_num ,invoice_payment.pay_check_id inv_pay_check_id ,invoice_payment.pay_doc_num inv_pay_doc_num ,invoice_payment.pay_payment_date inv_pay_payment_date ,invoice_payment.pay_gl_date inv_pay_gl_date ,invoice_payment.liability_account inv_liability_account ,SUM(invoice_payment.pay_hed_ent_dr) inv_pay_hed_ent_dr ,SUM(invoice_payment.pay_hed_acct_dr) inv_pay_hed_acct_dr ,SUM(invoice_payment.pay_detail_ent_cr) inv_pay_detail_ent_cr ,SUM(invoice_payment.pay_detail_ent_dr) inv_pay_detail_ent_dr ,SUM(invoice_payment.pay_detail_acct_cr) inv_pay_detail_acct_cr ,SUM(invoice_payment.pay_detail_acct_dr) inv_pay_detail_acct_dr ,invoice_payment.pay_dist_type inv_pay_dist_type ,invoice_payment.pay_invoice_id inv_invoice_id FROM (SELECT DECODE(xal.accounting_class_code,'LIABILITY' ,'Payment/'||alc.displayed_field ,INITCAP(xal.accounting_class_code)) pay_doc_type ,DECODE(xal.accounting_class_code,'LIABILITY',1,2) pay_acct_num ,xal.ae_header_id pay_header_id ,xal.ae_line_num pay_line_num ,ac.check_id pay_check_id ,ac.check_number pay_doc_num ,ac.check_date pay_payment_date ,ac.cleared_date pay_gl_date ,fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_acct', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'N', 'VALUE') liability_account ,DECODE(xal.accounting_class_code,'LIABILITY',(NVL(xdl.unrounded_entered_dr,0)- NVL(xdl.unrounded_entered_cr,0)),0) pay_hed_ent_dr ,DECODE(xal.accounting_class_code,'LIABILITY',(NVL(xdl.unrounded_accounted_dr,0) - NVL(xdl.unrounded_accounted_cr,0)),0) pay_hed_acct_dr ,DECODE(xal.accounting_class_code,'LIABILITY',0,DECODE(xah.event_type_code,'PAYMENT UNCLEARED' ,-1*(NVL(xdl.unrounded_entered_dr,0)),'PAYMENT CANCELLED' ,-1*(NVL(xdl.unrounded_entered_dr,0)),(NVL(xdl.unrounded_entered_cr,0)))) pay_detail_ent_cr ,DECODE(xal.accounting_class_code,'LIABILITY',0,DECODE(xah.event_type_code,'PAYMENT UNCLEARED' ,-1*(NVL(xdl.unrounded_entered_cr,0)),'PAYMENT CANCELLED' ,-1*(NVL(xdl.unrounded_entered_cr,0)),(NVL(xdl.unrounded_entered_dr,0)))) pay_detail_ent_dr ,DECODE(xal.accounting_class_code,'LIABILITY',0,DECODE(xah.event_type_code,'PAYMENT UNCLEARED' ,-1*(NVL(xdl.unrounded_accounted_dr,0)),'PAYMENT CANCELLED' ,-1*(NVL(xdl.unrounded_accounted_dr,0)),(NVL(xdl.unrounded_accounted_cr,0)))) pay_detail_acct_cr ,DECODE(xal.accounting_class_code,'LIABILITY',0,DECODE(xah.event_type_code,'PAYMENT UNCLEARED' ,-1*(NVL(xdl.unrounded_accounted_cr,0)),'PAYMENT CANCELLED' ,-1*(NVL(xdl.unrounded_accounted_cr,0)),(NVL(xdl.unrounded_accounted_dr,0)))) pay_detail_acct_dr ,alc.displayed_field pay_dist_type ,aia.invoice_id pay_invoice_id FROM ap_invoices aia ,ap_invoice_payments aip ,ap_checks ac ,ap_payment_history aph ,ap_lookup_codes alc ,ap_system_parameters asps ,xla_events xe ,xla_distribution_links xdl ,xla_ae_lines xal ,xla_ae_headers xah ,gl_code_combinations gcc WHERE aia.vendor_id = :SUP_ID AND aia.org_id = :ORGANIZATION_ID AND aia.vendor_site_id = :SUP_SITE_ID AND aia.invoice_currency_code = :CURRENCY AND aia.invoice_id = aip.invoice_id AND aia.gl_date BETWEEN :PERIOD_START_DATE_PARAM AND :PERIOD_END_DATE_PARAM AND aip.check_id = ac.check_id AND ac.check_id = aph.check_id AND alc.lookup_type = 'PAYMENT TYPE' AND asps.org_id = aia.org_id AND alc.lookup_code = ac.payment_type_flag AND xe.application_id = 200 AND aph.accounting_event_id = xe.event_id AND xah.application_id = xe.application_id AND xe.event_id = xah.event_id AND xah.ledger_id = :LEDGER_ID_PARAM AND xal.application_id = xe.application_id AND xah.ae_header_id = xal.ae_header_id AND xdl.application_id = xe.application_id AND xah.ae_header_id = xdl.ae_header_id AND xal.ae_line_num = xdl.ae_line_num AND xdl.source_distribution_type = 'AP_PMT_DIST' AND (xdl.applied_to_source_id_num_1 = aia.invoice_id OR xdl.applied_to_source_id_num_1 = aip.check_id) AND xdl.accounting_line_code NOT IN ('AP_LIAB_AWT_PMT') AND gcc.code_combination_id = xal.code_combination_id AND ((:PRPMT_PROCESSING_PARAM = 2) OR (:PRPMT_PROCESSING_PARAM = 1 AND (aia.invoice_type_lookup_code IN ('CREDIT','DEBIT','STANDARD','AWT','EXPENSE REPORT','MIXED') OR (aia.invoice_type_lookup_code = 'PREPAYMENT' AND (CASE WHEN asps.recon_accounting_flag='Y' THEN ac.cleared_date WHEN asps.recon_accounting_flag='N' THEN ac.check_date END) IS NOT NULL)))) AND ((xal.accounting_class_code = 'LIABILITY' AND gcc.code_combination_id = :ACCOUNT_ID) OR(xal.accounting_class_code <> 'LIABILITY')) GROUP BY 'Payment/'||alc.displayed_field ,DECODE(xal.accounting_class_code,'LIABILITY',1,2) ,xal.ae_header_id ,xal.ae_line_num ,ac.check_id ,ac.check_number ,ac.check_date ,ac.cleared_date ,alc.displayed_field ,aia.invoice_id ,xal.accounting_class_code ,xdl.unrounded_entered_dr ,xdl.unrounded_entered_cr ,xdl.unrounded_accounted_dr ,xdl.unrounded_accounted_cr ,xah.event_type_code ,fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_acct', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'N', 'VALUE') ORDER BY 6,3,2)invoice_payment GROUP BY invoice_payment.pay_doc_type ,invoice_payment.pay_acct_num ,invoice_payment.pay_header_id ,invoice_payment.pay_line_num ,invoice_payment.pay_check_id ,invoice_payment.pay_doc_num ,invoice_payment.pay_payment_date ,invoice_payment.pay_gl_date ,invoice_payment.liability_account ,invoice_payment.pay_dist_type ,invoice_payment.pay_invoice_id ORDER BY 6,3,2 Y SQLAP APTURNOVERRPT AR AP حساب المدفوعات - تقرير معدل الدوران Imported from BI Publisher Application: المدفوعات Source: حساب المدفوعات - تقرير معدل الدوران Short Name: APTURNOVERRPT DB package: AP_TURNOVER_RPT_PKG D AP KR Umsatzauswertung Imported from BI Publisher Application: Kreditoren Source: KR Umsatzauswertung Short Name: APTURNOVERRPT DB package: AP_TURNOVER_RPT_PKG E AP Informe de rotación de AP Imported from BI Publisher Application: Payables Source: Informe de rotación de AP Short Name: APTURNOVERRPT DB package: AP_TURNOVER_RPT_PKG F AP - Etat du chiffre d'affaires Imported from BI Publisher Application: Payables Source: AP - Etat du chiffre d'affaires Short Name: APTURNOVERRPT DB package: AP_TURNOVER_RPT_PKG I AP Rapporto Fatturato AP Imported from BI Publisher Application: Payables Source: Rapporto Fatturato AP Short Name: APTURNOVERRPT DB package: AP_TURNOVER_RPT_PKG JA AP AP回転率レポート Imported from BI Publisher Application: Payables Source: AP回転率レポート Short Name: APTURNOVERRPT DB package: AP_TURNOVER_RPT_PKG KO AP 회전율 보고서 Imported from BI Publisher Application: Payables Source: AP 회전율 보고서 Short Name: APTURNOVERRPT DB package: AP_TURNOVER_RPT_PKG PTB AP - Relatório de Movimentação Imported from BI Publisher Application: Payables Source: AP - Relatório de Movimentação Short Name: APTURNOVERRPT DB package: AP_TURNOVER_RPT_PKG RU AP Отчет об оборотах КР Imported from BI Publisher Application: Кредиторы Source: Отчет об оборотах КР Short Name: APTURNOVERRPT DB package: AP_TURNOVER_RPT_PKG S AP Omsättning - rapport Imported from BI Publisher Application: Payables Source: AP: Omsättning - rapport Short Name: APTURNOVERRPT DB package: AP_TURNOVER_RPT_PKG TR AP Ciro Raporu Imported from BI Publisher Application: Borçlar Muhasebesi Source: AP Ciro Raporu Short Name: APTURNOVERRPT DB package: AP_TURNOVER_RPT_PKG US AP Turnover Imported from BI Publisher Application: Payables Source: AP Turnover Report Short Name: APTURNOVERRPT DB package: AP_TURNOVER_RPT_PKG ZHS AP 营业额报表 Imported from BI Publisher Application: 应付帐款 Source: AP 营业额报表 Short Name: APTURNOVERRPT DB package: AP_TURNOVER_RPT_PKG BI Publisher :account_id :acct_from_param :acct_to_param :coa_id_param :coa_id_sumry_mask_param :currency :currency_param :dummy_report_level_param :dummy_report_type_param :g_open_balance :gc_currency_where :gc_ledger_name :gc_operunit_where :gc_orderby :gc_prepay_invoice_from :gc_prepay_invoice_select :gc_prepay_invoice_where :gc_prepay_where :gc_supplier_where :gn_open_invoice_balance :gn_open_payment_balance :ledger_id_param :ledger_name_param :organization_id :ou_from_param :ou_to_param :period_end_date_param :period_start_date_param :prpmt_processing_param :report_level_param :report_type_param :show_op_currency_param :summary_mask_param :sup_id :sup_site_id :supplier_from_param :supplier_to_param 1 -50 :ledger_name_param Char SELECT :$flex$.ledger_name.VALUE FROM DUAL AR قيمة اسم دفتر الأستاذ العام قيمة اسم دفتر الأستاذ العام D Wert Buchbezeichnung Wert Buchbezeichnung E Valor de Nombre de Libro Mayor Valor de Nombre de Libro Mayor F Valeur de nom de livre Valeur de nom de livre I Valore nome libro contabile Valore del nome libro contabile JA 元帳名の値 元帳名の値 KO 원장명 값 원장명 값 PTB Valor do Nome do Razão Valor do Nome do Razão RU Значение имени книги Значение имени книги S Värde för namn på huvudbok Värde för namn på huvudbok TR Defter Adı Değeri Defter Adı Değeri US Ledger Name Value Ledger Name Value ZHS 分类帐名称值 分类帐名称值 2 -40 :coa_id_param Number SELECT chart_of_accounts_id FROM gl_ledgers WHERE ledger_id = :$flex$.ledger_name Y AR معرف جدول تصنيف الحسابات معرف جدول تصنيف الحسابات D Kennung Kontenplan Kennung Kontenplan E Id Plan de Cuentas Identificador de 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 -30 :dummy_report_type_param Char SELECT ffvv.description FROM fnd_flex_values_vl ffvv,fnd_flex_value_sets ffvs WHERE ffvv.flex_value_set_id = ffvs.flex_value_set_id AND ffvs.flex_value_set_name = 'AP_SRS_TURNOVER_REPORT_TYPE' AND ffvv.flex_value = :$flex$.report_type AR نوع التقرير الافتراضي نوع التقرير الافتراضي D Dummy - Auswertungsart Dummy - Auswertungsart E Tipo de Informe Ficticio Tipo de informe ficticio F Type d'état fictif Type d'état fictif I Tipo di rapporto (fittizio) Tipo di rapporto (fittizio) JA ダミー・レポート・タイプ ダミー・レポート・タイプ KO Dummy 보고서 유형 Dummy 보고서 유형 PTB Tipo de Relatório Fictício Tipo de Relatório Fictício RU Фиктивный тип отчета Фиктивный тип отчета S Dummy-rapporttyp Dummy-rapporttyp TR Sözde Rapor Tipi Sözde Rapor Tipi US Dummy Report Type Dummy Report Type ZHS 虚拟报表类型 虚拟报表类型 4 -20 :dummy_report_level_param Char SELECT ffvv.description FROM fnd_flex_values_vl ffvv ,fnd_flex_value_sets ffvs WHERE ffvv.flex_value_set_id = ffvs.flex_value_set_id AND ffvs.flex_value_set_name = 'AP_SRS_TURNOVER_RPT_LEVEL' AND ffvv.flex_value =:$flex$.reporting_level AR مستوى التقرير الافتراضي مستوى التقرير الافتراضي D Dummy-Auswertungsebene Dummy-Auswertungsebene E Nivel de Informe Ficticio Nivel de Informe Ficticio F Niveau de reporting fictif Niveau de reporting fictif I Livello generazione rapporti (fittizio) Livello di generazione rapporti (fittizio) JA ダミー・レポート・レベル ダミー・レポート・レベル KO Dummy 보고 레벨 Dummy 보고 레벨 PTB Nível de Emissão de Relatórios Fictícios Nível de Emissão de Relatórios Fictícios RU Фиктивный уровень отчетности Фиктивный уровень отчетности S Dummy-rapporteringsnivå Dummy-rapporteringsnivå TR Sözde Raporlama Düzeyi Sözde Raporlama Düzeyi US Dummy Reporting Level Dummy Reporting Level ZHS 虚拟报告层 虚拟报告层 5 -10 :coa_id_sumry_mask_param Number SELECT fifs.id_flex_num FROM fnd_id_flex_structures fifs WHERE fifs.id_flex_structure_code = 'CLE_APTRNOVER_' || ( SELECT SUBSTR ( fifs1.id_flex_structure_code , 1 , 16 ) FROM fnd_id_flex_structures fifs1 WHERE fifs1.id_flex_num = :$flex$.chart_of_accounts_id AND fifs1.id_flex_code = 'GL#' ) AND fifs.id_flex_code = 'GL#' Y AR معرف جدول تصنيف الحسابات لقناع الإجمالي معرف دليل الحسابات لقناع الإجمالي D Kontenplankennung für Übersicht Kontenplankennung für Übersicht E Id de Plan de Cuentas para Máscara Resumen Identificador de plan de cuentas para máscara resumen F ID plan de comptes pour masque de synthèse ID plan de comptes pour masque de synthèse I Id piano dei conti per maschera sintetico Id piano dei conti per maschera sintetico JA 要約マスクのCOA ID 要約マスクの勘定体系ID KO 요약 마스크용 계정 코드집 ID 요약 마스크용 계정코드집 ID PTB ID do COA Para Máscara de Resumo ID do Plano De Contas Para Máscara de Resumo RU Идент. плана счетов для маски сводки Идентификатор плана счетов для маски сводки S Kontoplan: Id för summeringsmask Kontoplan: Id för summeringsmask TR Özet Filtre için HP No Özet Filtre için Hesap Planı No US COA ID For Summary Mask Chart Of Account ID For Summary Mask ZHS 摘要样式的 COA 标识 摘要样式的科目表标识 6 10 :ledger_id_param LOV Oracle AP_SRS_LEDGER Y select ledger_id id, name value, null description from gl_ledgers where ledger_id in (select distinct(gl.ledger_id) from gl_ledgers gl,hr_operating_units hou where hou.set_of_books_id=gl.ledger_id and mo_global.check_access (hou.organization_id)='Y') order by value,description Y AR اسم دفتر الأستاذ اسم دفتر الأستاذ D Buchbezeichnung Buchbezeichnung E Nombre de Libro Mayor Nombre de libro mayor F Nom du livre Nom du livre I Nome libro contabile Nome libro contabile JA 元帳名 元帳名 KO 원장명 원장명 PTB Nome do Razão Nome do Razão RU Имя книги Имя книги S Huvudbok Huvudbok TR Defter Adı Defter Adı US Ledger Name Ledger Name ZHS 分类帐名称 分类帐名称 7 20 :report_type_param LOV Oracle AP_SRS_TURNOVER_REPORT_TYPE Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=1023723 order by ffvv.flex_value 1 Y AR نوع التقرير نوع التقرير D Auswertungsart Auswertungsart E Tipo de Informe Tipo de informe F Type d'état Type d'état I Tipo rapporto Tipo di rapporto JA レポート・タイプ レポート・タイプ KO 보고서 유형 보고서 유형 PTB Tipo de Relatório Tipo de Relatório RU Тип отчета Тип отчета S Rapporttyp Rapporttyp TR Rapor Tipi Rapor Tipi US Report Type Report Type ZHS 报表类型 报表类型 8 30 :ou_from_param LOV Oracle AP_SRS_OU_NAME_LEDGER Y select hou.name id, hou.name value, null description from hr_operating_units hou where hou.set_of_books_id=:$flex$.ap_srs_ledger and mo_global.check_access (hou.organization_id)='Y' order by value,description Y AR وحدة التشغيل من الحد الأدنى لوحدة التشغيل D Von Betriebseinheit Unteres Limit für Betriebseinheit E De Unidad Operativa Límite inferior para unidad operativa F Unité opérationnelle - De Limite inférieure pour l'unité opérationnelle I Unità operativa - Da Limite inferiore per unità operativa JA 営業単位:自 営業単位の下限 KO 운영 단위: 부터 운영 단위 하한 PTB Unidade Operacional - De Limite Inferior da Unidade Operacional RU Операционная единица с Нижний предел для операционной единицы S Från operativ enhet Undre gräns för operativ enhet TR Faaliyet Birimi, İlk Faaliyet Birimi için Alt Limit US Operating Unit From Lower Limit For Operating Unit ZHS 业务实体自 业务实体的下限 9 40 :ou_to_param LOV Oracle AP_SRS_OU_NAME_LEDGER Y select hou.name id, hou.name value, null description from hr_operating_units hou where hou.set_of_books_id=:$flex$.ap_srs_ledger and mo_global.check_access (hou.organization_id)='Y' order by value,description Y AR وحدة التشغيل إلى الحد الأقصى لوحدة التشغيل D Bis Betriebseinheit Oberes Limit für Betriebseinheit E A Unidad Operativa Límite superior para unidad operativa F Unité opérationnelle - A Limite supérieure pour l'unité opérationnelle I Unità operativa - A Limite superiore per unità operativa JA 営業単位:至 営業単位の上限 KO 운영 단위: 까지 운영 단위 상한 PTB Unidade Operacional - Até Limite Superior da Unidade Operacional RU Операционная единица по Верхний предел для операционной единицы S Till operativ enhet Övre gräns för operativ enhet TR Faaliyet Birimi, Son Faaliyet Birimi için Üst Limit US Operating Unit To Upper Limit For Operating Unit ZHS 业务实体至 业务实体的上限 10 50 :period_start_date_param Date Y AR تاريخ بداية الفترة تاريخ بداية الفترة D Startdatum Periode Startdatum Periode E Fecha de Inicio de Período Fecha de Inicio de Período F Date de début de la période Date de début de la période I Data inizio periodo Data di inizio periodo JA 期間開始日 期間開始日 KO 기간 시작 일자 기간 시작 일자 PTB Data Inicial do Período Data Inicial do Período RU Дата начала периода Дата начала периода S Startdatum för period Startdatum för period TR Dönem Başlangıç Tarihi Dönem Başlangıç Tarihi US Period Start Date Period Start Date ZHS 期间起始日期 期间起始日期 11 60 :period_end_date_param Date Y AR تاريخ نهاية الفترة تاريخ نهاية الفترة D Enddatum Periode Enddatum Periode E Fecha de Finalización de Período Fecha de Finalización del Período F Date de fin de la période Date de fin de la période I Data fine periodo Data di fine periodo JA 期間終了日 期間終了日 KO 기간 종료 일자 기간 종료 일자 PTB Data Final do Período Data Final do Período RU Дата окончания периода Дата окончания периода S Slutdatum för period Slutdatum för period TR Dönem Bitiş Tarihi Dönem Bitiş Tarihi US Period End Date Period End Date ZHS 期间终止日期 期间终止日期 12 70 :supplier_from_param LOV Oracle AP_SRS_VENDOR_NAME_CHAR Y select po.vendor_name id, po.vendor_name value, null description from po_vendors po where po.vendor_id= (select max(po2.vendor_id) from po_vendors po2 where po2.vendor_name=po.vendor_name) order by po.vendor_name AR مورد من مورد من D Von Lieferant Von Lieferant E De Proveedor De Proveedor F Fournisseur - De Fournisseur - De I Fornitore - Da Fornitore - Da JA 仕入先:自 仕入先:自 KO 공급자: 부터 공급자: 부터 PTB Fornecedor - De Fornecedor - De RU Поставщик с Поставщик с S Från leverantör Från leverantör TR İlk Tedarikçi İlk Tedarikçi US Supplier From Supplier From ZHS 供应商自 供应商自 13 80 :supplier_to_param LOV Oracle AP_SRS_VENDOR_NAME_CHAR Y select po.vendor_name id, po.vendor_name value, null description from po_vendors po where po.vendor_id= (select max(po2.vendor_id) from po_vendors po2 where po2.vendor_name=po.vendor_name) order by po.vendor_name AR مورد إلى مورد إلى D Bis Lieferant Bis Lieferant E A Proveedor A Proveedor F Fournisseur - A Fournisseur - A I Fornitore - A Fornitore - A JA 仕入先:至 仕入先:至 KO 공급자: 까지 공급자: 까지 PTB Fornecedor - Até Fornecedor - Até RU Поставщик по Поставщик по S Till leverantör Till leverantör TR Son Tedarikçi Son Tedarikçi US Supplier To Supplier To ZHS 供应商至 供应商至 14 90 :acct_from_param Char AR حساب الخصوم من حساب الخصوم من D Von Verbindlichkeitskonto Von Verbindlichkeitskonto E De Cuenta de Pasivo De Cuenta de Pasivo F Compte fournisseur - De Compte fournisseur - De I Conto passività - Da Conto passività - Da JA 負債勘定:自 負債勘定:自 KO 부채 계정: 부터 부채 계정: 부터 PTB Conta do Passivo - De Conta do Passivo - De RU Счет пассива с Счет пассива с S Skuldkonto från Skuldkonto från TR İlk Borç Hesabı Borç Hesabı, İlk US Liability Account From Liability Account From ZHS 负债帐户自 负债帐户自 15 100 :acct_to_param Char AR حساب الخصوم إلى حساب الخصوم إلى D Bis Verbindlichkeitskonto Bis Verbindlichkeitskonto E A Cuenta de Pasivo A Cuenta de Pasivo F Compte fournisseur - A Compte fournisseur - A I Conto passività - A Conto passività - A JA 負債勘定:至 負債勘定:至 KO 부채 계정: 까지 부채 계정: 까지 PTB Conta do Passivo - Até Conta do Passivo - Até RU Счет пассива по Счет пассива по S Skuldkonto till Skuldkonto till TR Son Borç Hesabı Borç Hesabı, Son US Liability Account To Liability Account To ZHS 负债帐户至 负债帐户至 16 110 :currency_param LOV Oracle AP_SRS_CURRENCY Y select currency_code id, currency_code value, description description from fnd_currencies_vl where currency_flag='Y' and enabled_flag in ('Y','N') order by currency_code AR العملة العملة D Währung Währung E Divisa Divisa F Devise Devise I Divisa Divisa JA 通貨 通貨 KO 통화 통화 PTB Moeda Moeda RU Валюта Валюта S Valuta Valuta TR Para Birimi Para Birimi US Currency Currency ZHS 币种 币种 17 120 :show_op_currency_param LOV Oracle AP_SRS_YES_NO_MAND Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'YES_NO' AND lookup_code='N' Y AR إظهار عملة التشغيل إظهار عملة التشغيل D Währung Betriebseinheit anzeigen Währung Betriebseinheit anzeigen E Mostrar Divisa Operativa Mostrar Divisa Operativa F Afficher la devise de travail Afficher la devise de travail I Mostra divisa operativa Mostra la divisa operativa JA 営業通貨の表示 営業通貨の表示 KO 운영 통화 표시 운영 통화 표시 PTB Mostrar Moeda Operacional Mostrar Moeda Operacional RU Показать операционную валюту Показать операционную валюту S Visa operativ valuta Visa operativ valuta TR Faaliyet Para Birimini Göster Faaliyet Para Birimini Göster US Show Operating Currency Show Operating Currency ZHS 显示营业币种 显示营业币种 18 130 :report_level_param LOV Oracle AP_SRS_TURNOVER_RPT_LEVEL Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=1023725 order by ffvv.flex_value 1 Y AR مستوى إعداد التقرير مستوى إعداد التقرير D Auswertungsebene Auswertungsebene E Nivel de Informe Nivel de Informe F Niveau de reporting Niveau de reporting I Livello generazione rapporti Livello di generazione rapporti JA レポート・レベル レポート・レベル KO 보고 레벨 보고 레벨 PTB Nível de Emissão do Relatório Nível de Emissão do Relatório RU Уровень отчетности Уровень отчетности S Rapporteringsnivå Rapporteringsnivå TR Raporlama Düzeyi Raporlama Düzeyi US Reporting Level Reporting Level ZHS 报告层 报告层 19 140 :prpmt_processing_param LOV Oracle AP_SRS_TURNOVER_PMT_PROCESSING Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=1023726 order by ffvv.flex_value 2 Y AR معالجة الدفعات المقدمة معالجة الدفعات المقدمة D Verarbeitung Vorauszahlung Verarbeitung Vorauszahlung E Proceso de Anticipo Proceso de Anticipo F Traitement de l'acompte Traitement de l'acompte I Processo relativo agli anticipi Processo relativo agli anticipi JA 前払金処理 前払金処理 KO 선급금 처리 선급금 처리 PTB Processamento de Pagamento Antecipado Processamento de Pagamento Antecipado RU Обработка предоплаты Обработка предоплаты S Förskottsutbetalningsbearbetning Förskottsutbetalningsbearbetning TR Ön Ödeme İşleme Ön Ödeme İşleme US Prepayment Processing Prepayment Processing ZHS 预付款处理 预付款处理 20 150 :summary_mask_param Char AR قناع الإجمالي قناع الإجمالي D Übersicht Übersicht E Máscara Resumen Máscara Resumen F Masque de synthèse Masque de synthèse I Maschera sintetico Maschera sintetico JA 要約マスク 要約マスク KO 요약 마스크 요약 마스크 PTB Máscara de Resumo Máscara de Resumo RU Маска сводки Маска сводки S Summeringsmask Summeringsmask TR Özet Filtresi Özet Filtresi US Summary Mask Summary Mask ZHS 摘要样式 摘要样式 :$flex$.ap_srs_ledger Ledger Name Operating Unit From :$flex$.ap_srs_ledger Ledger Name Operating Unit To :$flex$.chart_of_accounts_id Chart of Accounts ID COA ID For Summary Mask :$flex$.ledger_name Ledger Name Chart of Accounts ID :$flex$.ledger_name.VALUE Ledger Name Ledger Name Value value :$flex$.report_type Report Type Dummy Report Type :$flex$.reporting_level Reporting Level Dummy Reporting Level