ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 CED35D87F9C868A0E0530100007FBF46 select x.application_name ,x.ledger_short_name ,x.ledger_description ,x.ledger_name ,x.ledger_currency -- posting account data ,x.accounting_code_combination account ,x.code_combination_description account_description ,x.control_account_flag -- gl data ,x.period_name ,x.gl_date ,x.gl_batch_name ,x.je_source_name gl_journal_source ,x.je_category_name gl_journal_category ,x.gl_je_name gl_journal_name ,x.gl_line_number gl_journal_line_num ,x.header_description ,x.line_description -- amounts ,x.entered_currency payment_currency ,x.entered_dr ,x.entered_cr ,x.unrounded_accounted_dr ,x.unrounded_accounted_cr ,x.accounted_dr ,x.accounted_cr ,x.statistical_amount -- source transaction data ,x.user_trx_identifier_value_10 supplier_name ,x.transaction_number payment_number ,x.transaction_date payment_date ,to_number(x.user_trx_identifier_value_9) payment_amount ,nvl(x.bank_account_num,x.user_trx_identifier_value_3) bank_account_num ,x.bank_account_name ,x.user_trx_identifier_value_5 payment_document -- other gl specific data ,x.gl_default_effective_date ,x.gl_batch_status ,x.posted_date gl_posted_date ,x.external_reference gl_external_reference ,x.reference_1 gl_reference_1 ,x.reference_4 gl_reference_4 ,x.gl_doc_sequence_name ,x.gl_doc_sequence_value -- other date, status, type data ,x.gl_transfer_date ,x.reference_date ,x.completed_date ,x.journal_entry_status ,x.transfer_to_gl_status ,x.balance_type_code ,x.balance_type ,x.budget_name ,x.encumbrance_type ,x.fund_status -- sla specific data ,x.event_date sla_event_date ,x.event_number sla_event_number ,x.event_class_code sla_event_class_code ,x.event_class_name sla_event_class_name ,x.event_type_code sla_event_type_code ,x.event_type_name sla_event_type_name ,nvl2(x.event_id,x.line_number,null) sla_line_number ,x.accounting_class_code sla_accounting_class_code ,x.accounting_class_name sla_accounting_class_name ,x.accounting_sequence_name sla_accounting_seq_name ,x.accounting_sequence_version sla_accounting_seq_version ,x.accounting_sequence_number sla_accounting_seq_number ,x.reporting_sequence_name sla_reporting_seq_name ,x.reporting_sequence_version sla_reporting_seq_version ,x.reporting_sequence_number sla_reporting_seq_number ,x.document_category sla_document_category ,x.document_sequence_name sla_document_seq_name ,x.document_sequence_number sla_document_seq_number -- period data points ,x.period_year ,x.period_number ,x.period_start_date ,x.period_end_date ,x.period_year_start_date ,x.period_year_end_date -- exchange type/rate data ,x.conversion_rate ,x.conversion_rate_date ,x.conversion_rate_type_code ,x.conversion_rate_type ,x.reconciliation_reference ,x.party_type_code ,x.party_type -- sla or gl line attributes ,x.attribute_category ,x.attribute1 ,x.attribute2 ,x.attribute3 ,x.attribute4 ,x.attribute5 ,x.attribute6 ,x.attribute7 ,x.attribute8 ,x.attribute9 ,x.attribute10 -- sla trx identifiers ,x.user_trx_identifier_name_1 ,x.user_trx_identifier_value_1 ,x.user_trx_identifier_name_2 ,x.user_trx_identifier_value_2 ,x.user_trx_identifier_name_3 ,x.user_trx_identifier_value_3 ,x.user_trx_identifier_name_4 ,x.user_trx_identifier_value_4 ,x.user_trx_identifier_name_5 ,x.user_trx_identifier_value_5 ,x.user_trx_identifier_name_6 ,x.user_trx_identifier_value_6 ,x.user_trx_identifier_name_7 ,x.user_trx_identifier_value_7 ,x.user_trx_identifier_name_8 ,x.user_trx_identifier_value_8 ,x.user_trx_identifier_name_9 ,x.user_trx_identifier_value_9 ,x.user_trx_identifier_name_10 ,x.user_trx_identifier_value_10 -- sla or gl audit colummns ,x.created_by ,x.creation_date ,x.last_update_date -- ,x.accounting_code_combination || ' (' || x.code_combination_description || ')' account_pivot_label ,nvl(x.bank_account_num,x.user_trx_identifier_value_3) || ' (' || x.bank_account_name || ')' bank_account_pivot_label from (select &p_main_col_start &p_uti_col &lp_template_columns &lp_init_sql from (&lp_template_table &p_sla_col_1 &p_gl_columns &p_sla_col_2 &p_party_details &p_sla_qualifier_segment &p_sla_col_3 &p_trx_identifiers_1 &p_trx_identifiers_2 &p_trx_identifiers_3 &p_trx_identifiers_4 &p_trx_identifiers_5 &lp_sla_userids2 &p_sla_legal_ent_col &p_sla_from &p_sla_seg_desc_from &p_gl_view &p_sla_legal_ent_from &p_party_from &p_sla_join &p_sla_seg_desc_join &p_other_param_filter &p_gl_join &p_sla_legal_ent_join &p_party_join &p_union_all &p_gl_col_1 &p_gl_party_details &p_gl_qualifier_segment &p_gl_col_2 &lp_gl_userids2 &p_gl_legal_ent_col &p_gl_from &p_gl_seg_desc_from &p_gl_legal_ent_from &p_gl_where &p_gl_seg_desc_join &p_gl_legal_ent_join &p_other_union ) table1 &p_le_from &p_other_from where nvl(:p_operating_unit,'?') = nvl(:p_operating_unit,'?') and nvl(:p_relative_period_from,'?') = nvl(:p_relative_period_from,'?') and nvl(:p_relative_period_to,'?') = nvl(:p_relative_period_to,'?') and nvl(:p_report_code,'?') = nvl(:p_report_code,'?') and nvl(:p_bank_account_num,'?') = nvl(:p_bank_account_num,'?') and 1=1 &p_le_join &p_other_join ) x Y SQLAP APXPOPMT #,##0.00;[Red]-#,##0.00 (:Period_From is not null and :Period_To is not null and :Relative_Period_From is null and :Relative_Period_To is null) or (:Relative_Period_From is not null and :Relative_Period_To is not null and :Period_From is null and :Period_To is null) AR AP سجل سداد المدفوعات المُرحلة Application: Payables Description: Payables Posted Payment Register This report provides equivalent functionality to the Oracle standard Payables Posted Payment Register report. For scheduling the report to run periodically, use the relative period from/to offset parameters. These are the relative period offsets to the current period, so when the current period changes, the included periods will also automatically be updated when the report is re-run. Templates - Pivot: Summary by Account Equivalent to standard report in Summarize Report = Yes Mode - Pivot: Summary by Account, Bank Account, Batch, Payment Currency, Payment Document Equivalent to standard report in Summarize=No Order By=Bank Account - Pivot: Summary by Account, Batch, Bank Account, Payment Currency, Payment Document Equivalent to standard report in Summarize=No Order By=Journal Entry Batch - Detail Provides detail listing of the posted payments Additional data fields are available. Run the report without a template to see full list available fields Source: Payables Posted Payment Register Short Name: APXPOPMT DB package: XLA_JELINES_RPT_PKG Also requires custom package XXEN_XLA package to be installed to initialize the hidden parameters removed from the report to simplify scheduling of the report. D AP Zahlungen - verbucht Application: Payables Description: Payables Posted Payment Register This report provides equivalent functionality to the Oracle standard Payables Posted Payment Register report. For scheduling the report to run periodically, use the relative period from/to offset parameters. These are the relative period offsets to the current period, so when the current period changes, the included periods will also automatically be updated when the report is re-run. Templates - Pivot: Summary by Account Equivalent to standard report in Summarize Report = Yes Mode - Pivot: Summary by Account, Bank Account, Batch, Payment Currency, Payment Document Equivalent to standard report in Summarize=No Order By=Bank Account - Pivot: Summary by Account, Batch, Bank Account, Payment Currency, Payment Document Equivalent to standard report in Summarize=No Order By=Journal Entry Batch - Detail Provides detail listing of the posted payments Additional data fields are available. Run the report without a template to see full list available fields Source: Payables Posted Payment Register Short Name: APXPOPMT DB package: XLA_JELINES_RPT_PKG Also requires custom package XXEN_XLA package to be installed to initialize the hidden parameters removed from the report to simplify scheduling of the report. E AP Registro de Pago Contabilizado de Cuentas a Pagar Application: Payables Description: Payables Posted Payment Register This report provides equivalent functionality to the Oracle standard Payables Posted Payment Register report. For scheduling the report to run periodically, use the relative period from/to offset parameters. These are the relative period offsets to the current period, so when the current period changes, the included periods will also automatically be updated when the report is re-run. Templates - Pivot: Summary by Account Equivalent to standard report in Summarize Report = Yes Mode - Pivot: Summary by Account, Bank Account, Batch, Payment Currency, Payment Document Equivalent to standard report in Summarize=No Order By=Bank Account - Pivot: Summary by Account, Batch, Bank Account, Payment Currency, Payment Document Equivalent to standard report in Summarize=No Order By=Journal Entry Batch - Detail Provides detail listing of the posted payments Additional data fields are available. Run the report without a template to see full list available fields Source: Payables Posted Payment Register Short Name: APXPOPMT DB package: XLA_JELINES_RPT_PKG Also requires custom package XXEN_XLA package to be installed to initialize the hidden parameters removed from the report to simplify scheduling of the report. Please enter either the Period From/To or the Relative Period From/To parameters F AP Payables - Registre des règlements imputés Application: Payables Description: Payables Posted Payment Register This report provides equivalent functionality to the Oracle standard Payables Posted Payment Register report. For scheduling the report to run periodically, use the relative period from/to offset parameters. These are the relative period offsets to the current period, so when the current period changes, the included periods will also automatically be updated when the report is re-run. Templates - Pivot: Summary by Account Equivalent to standard report in Summarize Report = Yes Mode - Pivot: Summary by Account, Bank Account, Batch, Payment Currency, Payment Document Equivalent to standard report in Summarize=No Order By=Bank Account - Pivot: Summary by Account, Batch, Bank Account, Payment Currency, Payment Document Equivalent to standard report in Summarize=No Order By=Journal Entry Batch - Detail Provides detail listing of the posted payments Additional data fields are available. Run the report without a template to see full list available fields Source: Payables Posted Payment Register Short Name: APXPOPMT DB package: XLA_JELINES_RPT_PKG Also requires custom package XXEN_XLA package to be installed to initialize the hidden parameters removed from the report to simplify scheduling of the report. I AP Registro pagamenti contabilizzati conto fornitori Application: Payables Description: Payables Posted Payment Register This report provides equivalent functionality to the Oracle standard Payables Posted Payment Register report. For scheduling the report to run periodically, use the relative period from/to offset parameters. These are the relative period offsets to the current period, so when the current period changes, the included periods will also automatically be updated when the report is re-run. Templates - Pivot: Summary by Account Equivalent to standard report in Summarize Report = Yes Mode - Pivot: Summary by Account, Bank Account, Batch, Payment Currency, Payment Document Equivalent to standard report in Summarize=No Order By=Bank Account - Pivot: Summary by Account, Batch, Bank Account, Payment Currency, Payment Document Equivalent to standard report in Summarize=No Order By=Journal Entry Batch - Detail Provides detail listing of the posted payments Additional data fields are available. Run the report without a template to see full list available fields Source: Payables Posted Payment Register Short Name: APXPOPMT DB package: XLA_JELINES_RPT_PKG Also requires custom package XXEN_XLA package to be installed to initialize the hidden parameters removed from the report to simplify scheduling of the report. JA AP 買掛管理転記済支払台帳 Application: Payables Description: Payables Posted Payment Register This report provides equivalent functionality to the Oracle standard Payables Posted Payment Register report. For scheduling the report to run periodically, use the relative period from/to offset parameters. These are the relative period offsets to the current period, so when the current period changes, the included periods will also automatically be updated when the report is re-run. Templates - Pivot: Summary by Account Equivalent to standard report in Summarize Report = Yes Mode - Pivot: Summary by Account, Bank Account, Batch, Payment Currency, Payment Document Equivalent to standard report in Summarize=No Order By=Bank Account - Pivot: Summary by Account, Batch, Bank Account, Payment Currency, Payment Document Equivalent to standard report in Summarize=No Order By=Journal Entry Batch - Detail Provides detail listing of the posted payments Additional data fields are available. Run the report without a template to see full list available fields Source: Payables Posted Payment Register Short Name: APXPOPMT DB package: XLA_JELINES_RPT_PKG Also requires custom package XXEN_XLA package to be installed to initialize the hidden parameters removed from the report to simplify scheduling of the report. Please enter either the Period From/To or the Relative Period From/To parameters KO AP AP 전기 지급 등록 Application: Payables Description: Payables Posted Payment Register This report provides equivalent functionality to the Oracle standard Payables Posted Payment Register report. For scheduling the report to run periodically, use the relative period from/to offset parameters. These are the relative period offsets to the current period, so when the current period changes, the included periods will also automatically be updated when the report is re-run. Templates - Pivot: Summary by Account Equivalent to standard report in Summarize Report = Yes Mode - Pivot: Summary by Account, Bank Account, Batch, Payment Currency, Payment Document Equivalent to standard report in Summarize=No Order By=Bank Account - Pivot: Summary by Account, Batch, Bank Account, Payment Currency, Payment Document Equivalent to standard report in Summarize=No Order By=Journal Entry Batch - Detail Provides detail listing of the posted payments Additional data fields are available. Run the report without a template to see full list available fields Source: Payables Posted Payment Register Short Name: APXPOPMT DB package: XLA_JELINES_RPT_PKG Also requires custom package XXEN_XLA package to be installed to initialize the hidden parameters removed from the report to simplify scheduling of the report. Please enter either the Period From/To or the Relative Period From/To parameters PTB AP Registro de Pagamento Contabilizado do Payables Application: Payables Description: Payables Posted Payment Register This report provides equivalent functionality to the Oracle standard Payables Posted Payment Register report. For scheduling the report to run periodically, use the relative period from/to offset parameters. These are the relative period offsets to the current period, so when the current period changes, the included periods will also automatically be updated when the report is re-run. Templates - Pivot: Summary by Account Equivalent to standard report in Summarize Report = Yes Mode - Pivot: Summary by Account, Bank Account, Batch, Payment Currency, Payment Document Equivalent to standard report in Summarize=No Order By=Bank Account - Pivot: Summary by Account, Batch, Bank Account, Payment Currency, Payment Document Equivalent to standard report in Summarize=No Order By=Journal Entry Batch - Detail Provides detail listing of the posted payments Additional data fields are available. Run the report without a template to see full list available fields Source: Payables Posted Payment Register Short Name: APXPOPMT DB package: XLA_JELINES_RPT_PKG Also requires custom package XXEN_XLA package to be installed to initialize the hidden parameters removed from the report to simplify scheduling of the report. Please enter either the Period From/To or the Relative Period From/To parameters RU AP Реестр проведенных платежей Кредиторов Application: Payables Description: Payables Posted Payment Register This report provides equivalent functionality to the Oracle standard Payables Posted Payment Register report. For scheduling the report to run periodically, use the relative period from/to offset parameters. These are the relative period offsets to the current period, so when the current period changes, the included periods will also automatically be updated when the report is re-run. Templates - Pivot: Summary by Account Equivalent to standard report in Summarize Report = Yes Mode - Pivot: Summary by Account, Bank Account, Batch, Payment Currency, Payment Document Equivalent to standard report in Summarize=No Order By=Bank Account - Pivot: Summary by Account, Batch, Bank Account, Payment Currency, Payment Document Equivalent to standard report in Summarize=No Order By=Journal Entry Batch - Detail Provides detail listing of the posted payments Additional data fields are available. Run the report without a template to see full list available fields Source: Payables Posted Payment Register Short Name: APXPOPMT DB package: XLA_JELINES_RPT_PKG Also requires custom package XXEN_XLA package to be installed to initialize the hidden parameters removed from the report to simplify scheduling of the report. Please enter either the Period From/To or the Relative Period From/To parameters S AP Register över postade betalningar i leverantörsreskontra Application: Payables Description: Payables Posted Payment Register This report provides equivalent functionality to the Oracle standard Payables Posted Payment Register report. For scheduling the report to run periodically, use the relative period from/to offset parameters. These are the relative period offsets to the current period, so when the current period changes, the included periods will also automatically be updated when the report is re-run. Templates - Pivot: Summary by Account Equivalent to standard report in Summarize Report = Yes Mode - Pivot: Summary by Account, Bank Account, Batch, Payment Currency, Payment Document Equivalent to standard report in Summarize=No Order By=Bank Account - Pivot: Summary by Account, Batch, Bank Account, Payment Currency, Payment Document Equivalent to standard report in Summarize=No Order By=Journal Entry Batch - Detail Provides detail listing of the posted payments Additional data fields are available. Run the report without a template to see full list available fields Source: Payables Posted Payment Register Short Name: APXPOPMT DB package: XLA_JELINES_RPT_PKG Also requires custom package XXEN_XLA package to be installed to initialize the hidden parameters removed from the report to simplify scheduling of the report. Please enter either the Period From/To or the Relative Period From/To parameters TR AP Borçlar Muhasebesi Muhasebeleşmiş Ödeme Kaydı Application: Payables Description: Payables Posted Payment Register This report provides equivalent functionality to the Oracle standard Payables Posted Payment Register report. For scheduling the report to run periodically, use the relative period from/to offset parameters. These are the relative period offsets to the current period, so when the current period changes, the included periods will also automatically be updated when the report is re-run. Templates - Pivot: Summary by Account Equivalent to standard report in Summarize Report = Yes Mode - Pivot: Summary by Account, Bank Account, Batch, Payment Currency, Payment Document Equivalent to standard report in Summarize=No Order By=Bank Account - Pivot: Summary by Account, Batch, Bank Account, Payment Currency, Payment Document Equivalent to standard report in Summarize=No Order By=Journal Entry Batch - Detail Provides detail listing of the posted payments Additional data fields are available. Run the report without a template to see full list available fields Source: Payables Posted Payment Register Short Name: APXPOPMT DB package: XLA_JELINES_RPT_PKG Also requires custom package XXEN_XLA package to be installed to initialize the hidden parameters removed from the report to simplify scheduling of the report. Please enter either the Period From/To or the Relative Period From/To parameters US AP Posted Payment Register Application: Payables Description: Payables Posted Payment Register This report provides equivalent functionality to the Oracle standard Payables Posted Payment Register report. For scheduling the report to run periodically, use the relative period from/to offset parameters. These are the relative period offsets to the current period, so when the current period changes, the included periods will also automatically be updated when the report is re-run. Templates - Pivot: Summary by Account Equivalent to standard report in Summarize Report = Yes Mode - Pivot: Summary by Account, Bank Account, Batch, Payment Currency, Payment Document Equivalent to standard report in Summarize=No Order By=Bank Account - Pivot: Summary by Account, Batch, Bank Account, Payment Currency, Payment Document Equivalent to standard report in Summarize=No Order By=Journal Entry Batch - Detail Provides detail listing of the posted payments Additional data fields are available. Run the report without a template to see full list available fields Source: Payables Posted Payment Register Short Name: APXPOPMT DB package: XLA_JELINES_RPT_PKG Also requires custom package XXEN_XLA package to be installed to initialize the hidden parameters removed from the report to simplify scheduling of the report. Please enter either the Period From/To or the Relative Period From/To parameters ZHS AP 应付帐款过帐付款登记表 Application: Payables Description: Payables Posted Payment Register This report provides equivalent functionality to the Oracle standard Payables Posted Payment Register report. For scheduling the report to run periodically, use the relative period from/to offset parameters. These are the relative period offsets to the current period, so when the current period changes, the included periods will also automatically be updated when the report is re-run. Templates - Pivot: Summary by Account Equivalent to standard report in Summarize Report = Yes Mode - Pivot: Summary by Account, Bank Account, Batch, Payment Currency, Payment Document Equivalent to standard report in Summarize=No Order By=Bank Account - Pivot: Summary by Account, Batch, Bank Account, Payment Currency, Payment Document Equivalent to standard report in Summarize=No Order By=Journal Entry Batch - Detail Provides detail listing of the posted payments Additional data fields are available. Run the report without a template to see full list available fields Source: Payables Posted Payment Register Short Name: APXPOPMT DB package: XLA_JELINES_RPT_PKG Also requires custom package XXEN_XLA package to be installed to initialize the hidden parameters removed from the report to simplify scheduling of the report. Enginatics R12 only &lp_gl_userids2 &lp_init_sql &lp_sla_userids2 &lp_template_columns &lp_template_table &p_gl_col_1 &p_gl_col_2 &p_gl_columns &p_gl_from &p_gl_join &p_gl_legal_ent_col &p_gl_legal_ent_from &p_gl_legal_ent_join &p_gl_party_details &p_gl_qualifier_segment &p_gl_seg_desc_from &p_gl_seg_desc_join &p_gl_view &p_gl_where &p_le_from &p_le_join &p_main_col_start &p_other_from &p_other_join &p_other_param_filter &p_other_union &p_party_details &p_party_from &p_party_join &p_sla_col_1 &p_sla_col_2 &p_sla_col_3 &p_sla_from &p_sla_join &p_sla_legal_ent_col &p_sla_legal_ent_from &p_sla_legal_ent_join &p_sla_qualifier_segment &p_sla_seg_desc_from &p_sla_seg_desc_join &p_trx_identifiers_1 &p_trx_identifiers_2 &p_trx_identifiers_3 &p_trx_identifiers_4 &p_trx_identifiers_5 &p_union_all &p_uti_col 1=1 :p_account_flexfield_from :p_account_flexfield_to :p_account_segment_from :p_account_segment_to :p_accounted_amount_from :p_accounted_amount_to :p_acct_sequence_name :p_acct_sequence_num_from :p_acct_sequence_num_to :p_acct_sequence_version :p_approved_query :p_balance_type :p_balance_type_code :p_balancing_segment_from :p_balancing_segment_to :p_bank_account_num :p_budget_name :p_budget_version_id :p_coa_id :p_commercial_query :p_created_query :p_creation_date_from :p_creation_date_to :p_custom_header_query :p_custom_line_query :p_custom_parameter_1 :p_custom_parameter_10 :p_custom_parameter_11 :p_custom_parameter_12 :p_custom_parameter_13 :p_custom_parameter_14 :p_custom_parameter_15 :p_custom_parameter_16 :p_custom_parameter_17 :p_custom_parameter_18 :p_custom_parameter_19 :p_custom_parameter_2 :p_custom_parameter_20 :p_custom_parameter_21 :p_custom_parameter_22 :p_custom_parameter_23 :p_custom_parameter_24 :p_custom_parameter_25 :p_custom_parameter_26 :p_custom_parameter_27 :p_custom_parameter_28 :p_custom_parameter_29 :p_custom_parameter_3 :p_custom_parameter_30 :p_custom_parameter_4 :p_custom_parameter_5 :p_custom_parameter_6 :p_custom_parameter_7 :p_custom_parameter_8 :p_custom_parameter_9 :p_custom_query_flag :p_doc_seq_name :p_doc_sequence_name :p_doc_sequence_num_from :p_doc_sequence_num_to :p_dummy_event_class :p_encumbrance_type :p_encumbrance_type_id :p_entered_currency :p_event_class :p_event_class_rowid :p_fetch_from_gl :p_gl_batch_name :p_gl_col_1 :p_gl_col_2 :p_gl_columns :p_gl_date_from :p_gl_date_to :p_gl_from :p_gl_join :p_gl_legal_ent_col :p_gl_legal_ent_from :p_gl_legal_ent_join :p_gl_party_details :p_gl_qualifier_segment :p_gl_seg_desc_from :p_gl_seg_desc_join :p_gl_view :p_gl_where :p_include_le_info_flag :p_include_legal_entity_info :p_include_tax_details :p_include_tax_details_flag :p_include_user_trx_id_flag :p_include_user_trx_identifiers :p_include_zero_amount_flag :p_include_zero_amount_lines :p_je_category :p_je_category_name :p_je_source :p_je_source_name :p_je_status :p_je_status_code :p_le_col :p_le_from :p_le_join :p_ledger :p_ledger_id :p_legal_audit_flag :p_legal_entity :p_legal_entity_id :p_long_report :p_main_col_end :p_main_col_start :p_operating_unit :p_order_by :p_order_by_clause :p_other_from :p_other_join :p_other_param_filter :p_other_union :p_party_details :p_party_details_col :p_party_from :p_party_id :p_party_join :p_party_name :p_party_number_from :p_party_number_to :p_party_type :p_party_type_code :p_period_from :p_period_to :p_period_type :p_post_accounting_program :p_post_acct_program_rowid :p_posted_query :p_posting_status :p_posting_status_code :p_process_category :p_process_category_rowid :p_relative_period_from :p_relative_period_to :p_report_code :p_resp_application_id :p_rpt_sequence_name :p_rpt_sequence_num_from :p_rpt_sequence_num_to :p_rpt_sequence_version :p_security_id_char_1 :p_security_id_char_2 :p_security_id_char_3 :p_security_id_int_1 :p_security_id_int_2 :p_security_id_int_3 :p_segment_col :p_show_adj_periods :p_side :p_side_code :p_sla_col_1 :p_sla_col_2 :p_sla_col_3 :p_sla_from :p_sla_join :p_sla_legal_ent_col :p_sla_legal_ent_from :p_sla_legal_ent_join :p_sla_qualifier_segment :p_sla_seg_desc_from :p_sla_seg_desc_join :p_tax_query :p_transaction_date_from :p_transaction_date_to :p_transaction_view :p_trx_id_filter :p_trx_identifiers :p_trx_identifiers_1 :p_trx_identifiers_2 :p_trx_identifiers_3 :p_trx_identifiers_4 :p_trx_identifiers_5 :p_trx_legal_entity :p_trx_legal_entity_id :p_trx_num_from :p_trx_num_to :p_union_all :p_user_trx_id_column_1 :p_user_trx_id_column_2 :p_user_trx_id_column_3 :p_user_trx_id_column_4 :p_user_trx_id_column_5 :p_user_trx_id_value_1 :p_user_trx_id_value_2 :p_user_trx_id_value_3 :p_user_trx_id_value_4 :p_user_trx_id_value_5 :p_uti_col :p_valuation_method :p_vat_registration_query :p_ytd_carriedfwd :p_ytd_carriedfwd_flag :p_ytd_carriedfwd_info 1 -70 :p_report_code Char APXPOPMT F Code du rapport US Report Code 2 -60 &lp_template_columns select case when :p_template_flag = 'Y' and :run_id is null then ' to_date(null) gl_date ,to_number(null) created_by ,to_date(null) creation_date ,to_date(null) last_update_date ,to_date(null) gl_transfer_date ,to_date(null) reference_date ,to_date(null) completed_date ,null external_reference ,null reference_1 ,null reference_4 ,to_number(null) period_year ,to_date(null) period_year_start_date ,to_date(null) period_year_end_date ,to_number(null) period_number ,null period_name ,to_date(null) period_start_date ,to_date(null) period_end_date ,null transaction_number ,to_date(null) transaction_date ,null accounting_sequence_name ,to_number(null) accounting_sequence_version ,to_number(null) accounting_sequence_number ,null reporting_sequence_name ,to_number(null) reporting_sequence_version ,to_number(null) reporting_sequence_number ,null document_category ,null document_sequence_name ,to_number(null) document_sequence_number ,to_number(null) application_id ,null application_name ,to_number(null) ledger_id ,null ledger_short_name ,null ledger_description ,null ledger_name ,null ledger_currency ,to_number(null) header_id ,to_number(null) s_header_id ,null header_description ,null journal_entry_status ,null transfer_to_gl_status ,null balance_type_code ,null balance_type ,null budget_name ,null encumbrance_type ,null fund_status ,null je_category_name ,null je_source_name ,null gl_batch_name ,to_date(null) gl_default_effective_date ,null gl_batch_status ,to_date(null) posted_date ,null gl_je_name ,null gl_doc_sequence_name ,to_number(null) gl_doc_sequence_value ,to_number(null) gl_line_number ,to_number(null) event_id ,to_date(null) event_date ,to_number(null) event_number ,null event_class_code ,null event_class_name ,null event_type_code ,null event_type_name ,to_number(null) line_number ,null accounting_class_code ,null accounting_class_name ,null line_description ,to_number(null) code_combination_id ,null accounting_code_combination ,null code_combination_description ,null control_account_flag ,null entered_currency ,to_number(null) conversion_rate ,to_date(null) conversion_rate_date ,null conversion_rate_type_code ,null conversion_rate_type ,to_number(null) entered_dr ,to_number(null) entered_cr ,to_number(null) unrounded_accounted_dr ,to_number(null) unrounded_accounted_cr ,to_number(null) accounted_dr ,to_number(null) accounted_cr ,to_number(null) statistical_amount ,null reconciliation_reference ,null attribute_category ,null attribute1 ,null attribute2 ,null attribute3 ,null attribute4 ,null attribute5 ,null attribute6 ,null attribute7 ,null attribute8 ,null attribute9 ,null attribute10 ,null party_type_code ,null party_type ,null user_trx_identifier_name_1 ,null user_trx_identifier_value_1 ,null user_trx_identifier_name_2 ,null user_trx_identifier_value_2 ,null user_trx_identifier_name_3 ,null user_trx_identifier_value_3 ,null user_trx_identifier_name_4 ,null user_trx_identifier_value_4 ,null user_trx_identifier_name_5 ,null user_trx_identifier_value_5 ,null user_trx_identifier_name_6 ,null user_trx_identifier_value_6 ,null user_trx_identifier_name_7 ,null user_trx_identifier_value_7 ,null user_trx_identifier_name_8 ,null user_trx_identifier_value_8 ,null user_trx_identifier_name_9 ,null user_trx_identifier_value_9 ,null user_trx_identifier_name_10 ,null user_trx_identifier_value_10 ,null bank_account_id ,null bank_account_num ,null bank_account_name' else ' ,substr(userids2,1,instr(userids2,''|'',1,1)-1) bank_account_id ,substr(userids2,instr(userids2,''|'',1,1)+1,(instr(userids2,''|'',1,2)-1-instr(userids2,''|'',1,1))) bank_account_num ,substr(userids2,instr(userids2,''|'',1,2)+1,(length(userids2)-instr(userids2,''|'',1,2))) bank_account_name' end from dual Char Y F Colonnes du modèle US Template Columns 3 -50 &lp_template_table select 'select null userids, null userids2 from dual ' from dual where :p_template_flag = 'Y' and :run_id is null Char Y F Tableau des modèles US Template Table 4 -40 &lp_init_sql select xxen_xla.xla_je_lines_rpt_pkg_init (:p_dummy ,:p_report_code ,:p_operating_unit ,:p_ledger ,:p_period_from ,:p_period_to ,:p_relative_period_from ,:p_relative_period_to ,:p_je_source_name ,:p_include_zero_amount_flag ,:p_account_flexfield_from ,:p_account_flexfield_to ,:p_gl_batch_name ,:p_fetch_from_gl ) from dual Char Y US Init SQL 5 -30 1=1 :p_ba_yn=:p_ba_yn and (:p_user_trx_id_value_3 is null or substr(userids2,1,instr(userids2,'|',1,1)-1) = to_char(:p_user_trx_id_value_3)) Char Y select nvl( (select 'Y' from user_tab_cols where table_name = 'AP_SLA_PAYMENTS_TRANSACTION_V' and column_name = 'BANK_ACCOUNT_ID' and rownum=1),'N') from dual F La colonne "Bank Acct ID" existe US Bank Acct ID Column Exists 6 1=1 :p_ba_yn=:p_ba_yn and (:p_user_trx_id_value_3 is null or substr(userids,instr(userids,'|',1,5)+1,(instr(userids,'|',1,6)-1-instr(userids,'|',1,5))) =ce_bank_and_account_util.get_masked_bank_acct_num(:p_user_trx_id_value_3)) N F La colonne "Bank Acct ID" existe US Bank Acct ID Column Exists 7 -20 &lp_sla_userids2 select case when :p_template_flag = 'Y' and :run_id is null then '' else case when :p_ba_yn = 'Y' then ', (select asptv.bank_account_id ||''|''|| cba.masked_account_num ||''|''|| cba.bank_account_name from ap_sla_payments_transaction_v asptv, ce_bank_accounts cba where cba.bank_account_id = asptv.bank_account_id and asptv.check_id = ent.source_id_int_1 ) userids2' else ', null userids2' end end from dual Char Y US SLA Userids2 8 -10 &lp_gl_userids2 select case when :p_template_flag = 'Y' and :run_id is null then '' when nvl(:p_fetch_from_gl,'N')='N' then '' else ', null userids2' end from dual Char Y US GL Userids2 9 10 :p_operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name AR وحدة التشغيل وحدة التشغيل D Betriebseinheit Betriebseinheit F Unité d'exploitation Unité opérationnelle I Unità operativa Unità operativa US Operating Unit Operating Unit ZHS 业务实体 业务实体 10 20 :p_ledger LOV custom Y select name value, description description from gl_ledgers a where (nvl(fnd_profile.value('XLA_USE_LEDGER_SECURITY'),'N')='N' or exists (select 1 from gl_access_set_ledgers b where b.ledger_id=a.ledger_id and b.access_set_id in (decode (nvl(fnd_profile.value('XLA_APPL_ID'),fnd_global.resp_appl_id) ,101 ,null ,decode (fnd_profile.value('XLA_USE_LEDGER_SECURITY') ,'Y' ,fnd_profile.value('XLA_GL_SECONDARY_ACCESS_SET_ID') ,null ) ) ,decode (nvl(fnd_profile.value('XLA_APPL_ID'),fnd_global.resp_appl_id) ,101 ,fnd_profile.value('GL_ACCESS_SET_ID') ,decode (fnd_profile.value('XLA_USE_LEDGER_SECURITY') ,'Y' ,fnd_profile.value('GL_ACCESS_SET_ID') ,b.access_set_id ) ) ) ) ) and exists (select 1 from gl_ledger_relationships c where decode(a.ledger_category_code,'NONE',c.target_ledger_id,a.ledger_id)=c.target_ledger_id and ((decode(a.ledger_category_code,'NONE','PRIMARY',c.target_ledger_category_code)='PRIMARY' and decode(a.ledger_category_code,'NONE','NONE',c.relationship_type_code)='NONE') or(c.target_ledger_category_code in ('SECONDARY','ALC') and c.relationship_type_code='SUBLEDGER') ) ) order by value,description Y AR دفتر الأستاذ/مجموعة دفاتر الأستاذ المعرف الداخلي لدفتر الأستاذ أو مجموعة دفاتر الأستاذ D Buch/BuchSet Interne Kennung für das Buch oder BuchSet F Grand livre/ensemble de grands livres Identifiant interne pour le livre ou le jeu de livres I Libro contabile/serie libri contabili Identificativo interno per il libro contabile o la serie di libri contabili US Ledger/Ledger Set Identifier for the ledger or ledger set ZHS 分类帐/分类帐集 分类帐或分类帐集的内部标识 11 30 :p_period_from LOV custom Y select period_name value, null description from gl_ledgers gl,gl_periods glp where gl.name=:$flex$.ledger_ledger_set and gl.period_set_name=glp.period_set_name and gl.accounted_period_type=glp.period_type and glp.adjustment_period_flag='N' order by glp.period_year desc,glp.period_num desc AR الفترة من فترة البداية من التقويم المرفق بدفتر الأستاذ أو مجموعة دفاتر الأستاذ D Von Periode Startperiode des Kalenders, der dem Buch oder BuchSet zugeordnet ist F Période du Période de début du calendrier associé au livre ou au jeu de livres I Periodo - Da Periodo iniziale del calendario associato al libro contabile o alla serie di libri contabili US Period From Start period from the calendar attached to the ledger or ledger set ZHS 期间自 附加至分类帐或分类帐集的日历起始期间 12 40 :p_period_to LOV custom Y select period_name value, null description from gl_ledgers gl,gl_periods glp where glp.adjustment_period_flag='N' and gl.name=:$flex$.ledger_ledger_set and gl.period_set_name=glp.period_set_name and gl.accounted_period_type=glp.period_type and glp.period_year= (select glp2.period_year from gl_periods glp2 where glp2.period_set_name=glp.period_set_name and glp2.period_type=glp.period_type and glp2.period_name=:$flex$.period_from ) and glp.period_num>= (select glp2.period_num from gl_periods glp2 where glp2.period_set_name=glp.period_set_name and glp2.period_type=glp.period_type and glp2.period_name=:$flex$.period_from ) order by glp.period_year desc,glp.period_num desc :$flex$.period_from AR الفترة إلى فترة النهاية من التقويم المرفق بدفتر الأستاذ أو مجموعة دفاتر الأستاذ D Bis Periode Endperiode des Kalenders, der dem Buch oder BuchSet zugeordnet ist F Période à Période de fin du calendrier associé au livre ou au jeu de livres I Periodo - A Periodo finale del calendario associato al libro contabile o alla serie di libri contabili US Period To End period from the calendar attached to the ledger or ledger set ZHS 期间至 附加至分类帐或分类帐集的日历终止期间 13 50 :p_je_source_name LOV custom Y select user_je_source_name value, null description from (select user_je_source_name,je_source_name from gl_je_sources union all select meaning,'#ALL#' from xla_lookups where lookup_type='XLA_ALL') a where exists (select 1 from xla_subledgers b where b.je_source_name= decode ((select 1 from xla_subledgers where application_id=nvl(fnd_profile.value('XLA_APPL_ID'),fnd_global.resp_appl_id)) ,1,a.je_source_name ,b.je_source_name ) and b.application_id= decode ((select 1 from xla_subledgers where application_id=nvl(fnd_profile.value('XLA_APPL_ID'),fnd_global.resp_appl_id)) ,1,nvl(fnd_profile.value('XLA_APPL_ID'),fnd_global.resp_appl_id) ,b.application_id ) ) or (fnd_profile.value('XLA_JE_SOURCE_ALLOW_OVERRIDE')='Y' and a.je_source_name='#ALL#' ) order by upper(user_je_source_name) SELECT gjs.user_je_source_name FROM xla_subledgers xls, gl_je_sources gjs WHERE xls.application_id = nvl(fnd_profile.value('XLA_APPL_ID'),fnd_global.resp_appl_id) AND gjs.je_source_name = xls.je_source_name AR P_JE_SOURCE اسم مصدر قيد اليومية D P_JE_SOURCE Bezeichnung Belegherkunft F Source du journal Nom pour l'origine de la pièce I P_JE_SOURCE Nome origine della scrittura contabile US Journal Source Journal Entry Source name ZHS P_JE_SOURCE 日记帐分录来源名称 14 60 :p_include_zero_amount_flag LOV Oracle XLA_SRS_YES_NO Y select lookup_code id, meaning value, null description from xla_lookups where lookup_type='XLA_YES_NO' order by value,description N AR تضمين سطور بمبالغ صفرية علامة للإشارة إلى ما إذا كان سيتم التبليغ بسطور المبالغ الصفرية أم لا D Mit Null-Betragspositionen Kennzeichen, das angibt, ob Betragspositionen von Null ausgewertet werden F Inclure les lignes de montant nul Indicateur signalant si les lignes de montant nul doivent être éditées I Includi linee a importo zero Flag per indicare se le linee a importo zero devono essere inserite nel rapporto oppure no US Include Zero Amount Lines Flag to indicate if zero amount lines are to be reported or not ZHS 包括金额为零的行 用于指明金额为零的行是否要报告的标志 15 70 :p_account_flexfield_from LOV custom Y Y select gcck.concatenated_segments value, xxen_util.segments_description(gcck.code_combination_id) description from gl_code_combinations_kfv gcck where gcck.chart_of_accounts_id = (select gl.chart_of_accounts_id from gl_ledgers gl where gl.name = :$flex$.ledger_ledger_set) and gcck.detail_posting_allowed = 'Y' and gcck.enabled_flag = 'Y' and gcck.summary_flag = 'N' order by gcck.concatenated_segments AR الحقل المحاسبي المرن من بداية مدى الحقل المحاسبي المرن D Von Konto-FlexFeld Start des Bereichs für das Konto-FlexFeld F Compte Flexfield de Début de la fourchette pour la clé comptable flexible I Flexfield contabile - Da Inizio dell'intervallo per il flexfield contabile US Account Flexfield From Start of the range for the accounting flexfield ZHS 帐户弹性域自 会计科目弹性域范围的起始值 16 80 :p_account_flexfield_to LOV custom Y Y select gcck.concatenated_segments value, xxen_util.segments_description(gcck.code_combination_id) description from gl_code_combinations_kfv gcck where gcck.chart_of_accounts_id = (select gl.chart_of_accounts_id from gl_ledgers gl where gl.name = :$flex$.ledger_ledger_set) and gcck.detail_posting_allowed = 'Y' and gcck.enabled_flag = 'Y' and gcck.summary_flag = 'N' order by gcck.concatenated_segments :$flex$.Account_Flexfield_From AR الحقل المحاسبي المرن إلى نهاية مدى الحقل المحاسبي المرن D Bis Konto-FlexFeld Ende des Bereichs für das Konto-FlexFeld F Compte Flexfield à Fin de la fourchette pour la clé comptable flexible I Flexfield contabile - A Fine dell'intervallo per il flexfield contabile US Account Flexfield To End of the range for the accounting flexfield ZHS 帐户弹性域至 会计科目弹性域范围的终止值 17 90 :p_user_trx_id_value_3 LOV Oracle AP_SRS_BANK_ACCT_NUM_ID Y select bank_account_id id, bank_account_num value, bank_account_name description from ce_bank_accounts order by bank_account_id F Compte bancaire US Bank Account 18 100 :p_gl_batch_name LOV custom Y select gjb.name value, gjb.name description from gl_je_batches gjb where gjb.chart_of_accounts_id= (select gl.chart_of_accounts_id from gl_ledgers gl where gl.name = :$flex$.ledger_ledger_set) and gjb.actual_flag='A' and gjb.je_batch_id in (select gjh.je_batch_id from gl_je_headers gjh, gl_ledgers gl, gl_period_statuses gps1, gl_period_statuses gps2 where gl.name=:$flex$.ledger_ledger_set and gjh.ledger_id=gl.ledger_id and gps1.set_of_books_id=gjh.ledger_id and gps1.period_name= nvl(:$flex$.period_from, ( select x.period_name from ( select 1-rank() over (order by ((glp.period_year * 100000) + glp.period_num) desc) relative_period, glp.period_name from gl_ledgers gl, gl_periods glp, gl_periods glpc where gl.name=:$flex$.ledger_ledger_set and gl.period_set_name=glp.period_set_name and gl.accounted_period_type=glp.period_type and glp.adjustment_period_flag='N' and gl.period_set_name=glpc.period_set_name and gl.accounted_period_type=glpc.period_type and glpc.adjustment_period_flag='N' and trunc(sysdate) between glpc.start_date and glpc.end_date and glp.start_date <= glpc.start_date ) x where x.relative_period = to_number(:$flex$.relative_period_from) ) ) and gps2.set_of_books_id=gjh.ledger_id and gps2.period_name= nvl(:$flex$.period_to, ( select x.period_name from ( select 1-rank() over (order by ((glp.period_year * 100000) + glp.period_num) desc) relative_period, glp.period_name from gl_ledgers gl, gl_periods glp, gl_periods glpc where gl.name=:$flex$.ledger_ledger_set and gl.period_set_name=glp.period_set_name and gl.accounted_period_type=glp.period_type and glp.adjustment_period_flag='N' and gl.period_set_name=glpc.period_set_name and gl.accounted_period_type=glpc.period_type and glpc.adjustment_period_flag='N' and trunc(sysdate) between glpc.start_date and glpc.end_date and glp.start_date <= glpc.start_date ) x where x.relative_period = to_number(:$flex$.relative_period_to) ) ) and gjh.default_effective_date between gps1.start_date and gps2.end_date and gjh.je_source='Payables' ) order by gjb.default_effective_date AR اسم مجموعة الأستاذ العام اسم مجموعة الأستاذ العام D Bezeichnung Buchungsstapel Bezeichnung Buchungsstapel F Nom du lot GL Nom du lot GL I Nome batch GL Nome del batch GL US GL Batch Name GL Batch Name ZHS GL 批名 GL 批名 19 110 :p_fetch_from_gl LOV Oracle XLA_SRS_YES_NO Y select lookup_code id, meaning value, null description from xla_lookups where lookup_type='XLA_YES_NO' order by value,description Y Y AR تضمين القيود اليدوية من الأستاذ العام تضمين القيود اليدوية من الأستاذ العام D Mit manuellen Buchungen aus RW Mit manuellen Buchungen aus RW F Inclure les écritures manuelles du GL Inclure les saisies manuelles de GL I Includi scritture contabili da GL Include le scritture contabili da GL US Include Manual Entries from GL Include Manual Entries from GL ZHS 包括来自 GL 的人工录入 包括来自 GL 的人工录入 20 120 :p_relative_period_from LOV custom Y select to_char(x.relative_period) value, 'Current Period' || decode(x.relative_period,0,null,' ' || to_char(x.relative_period) || ' ' || x.period_type) || ' (' || x.period_name || ')' description from ( select 1-rank() over (order by ((glp.period_year * 100000) + glp.period_num) desc) relative_period, glp.period_name, glp.period_type from gl_ledgers gl ,gl_periods glp ,gl_periods glpc where gl.name=:$flex$.ledger_ledger_set and gl.period_set_name=glp.period_set_name and gl.accounted_period_type=glp.period_type and glp.adjustment_period_flag='N' and gl.period_set_name=glpc.period_set_name and gl.accounted_period_type=glpc.period_type and glpc.adjustment_period_flag='N' and trunc(sysdate-1) between glpc.start_date and glpc.end_date and glp.start_date <= glpc.start_date ) x order by x.relative_period desc F Période relative de Start period offset from the current period of the calendar attached to the ledger or ledger set US Relative Period From Start period offset from the current period of the calendar attached to the ledger or ledger set 21 130 :p_relative_period_to LOV custom Y select to_char(x.relative_period) value, 'Current Period' || decode(x.relative_period,0,null,' ' || to_char(x.relative_period) || ' ' || x.period_type) || ' (' || x.period_name || ')' description from ( select 1-rank() over (order by ((glp.period_year * 100000) + glp.period_num) desc) relative_period, glp.period_name, glp.period_type, glp.period_year, glp.period_num from gl_ledgers gl ,gl_periods glp ,gl_periods glpc where gl.name=:$flex$.ledger_ledger_set and gl.period_set_name=glp.period_set_name and gl.accounted_period_type=glp.period_type and glp.adjustment_period_flag='N' and gl.period_set_name=glpc.period_set_name and gl.accounted_period_type=glpc.period_type and glpc.adjustment_period_flag='N' and trunc(sysdate-1) between glpc.start_date and glpc.end_date and glp.start_date <= glpc.start_date ) x where exists ( select null from ( select 1-rank() over (order by ((glp.period_year * 100000) + glp.period_num) desc) relative_period, glp.period_name, glp.period_year, glp.period_num from gl_ledgers gl, gl_periods glp, gl_periods glpc where gl.name=:$flex$.ledger_ledger_set and gl.period_set_name=glp.period_set_name and gl.accounted_period_type=glp.period_type and glp.adjustment_period_flag='N' and gl.period_set_name=glpc.period_set_name and gl.accounted_period_type=glpc.period_type and glpc.adjustment_period_flag='N' and trunc(sysdate-1) between glpc.start_date and glpc.end_date and glp.start_date <= glpc.start_date ) x2 where x2.relative_period = to_number(:$flex$.relative_period_from) and x2.period_year = x.period_year and x2.period_num <= x.period_num ) order by x.relative_period desc :$flex$.relative_period_from F Période relative à End period offset from the current period of the calendar attached to the ledger or ledger set US Relative Period To End period offset from the current period of the calendar attached to the ledger or ledger set :$flex$.Account_Flexfield_From Account Flexfield From Account Flexfield To :$flex$.ledger_ledger_set Ledger/Ledger Set Account Flexfield From :$flex$.ledger_ledger_set Ledger/Ledger Set Account Flexfield To :$flex$.ledger_ledger_set Ledger/Ledger Set GL Batch Name :$flex$.ledger_ledger_set Ledger/Ledger Set Period From :$flex$.ledger_ledger_set Ledger/Ledger Set Period To :$flex$.ledger_ledger_set Ledger/Ledger Set Relative Period From :$flex$.ledger_ledger_set Ledger/Ledger Set Relative Period To :$flex$.period_from Period From GL Batch Name :$flex$.period_from Period From Period To :$flex$.period_to Period To GL Batch Name :$flex$.relative_period_from Relative Period From GL Batch Name :$flex$.relative_period_from Relative Period From Relative Period To :$flex$.relative_period_to Relative Period To GL Batch Name CE020444DAB804460EB375E67EA9B125 Detail Y Detail Template SYSADMIN 3 ACCOUNT 2 18 ACCOUNTED_CR 17 ACCOUNTED_DR 4 ACCOUNT_DESCRIPTION 20 BANK_ACCOUNT_NAME 19 BANK_ACCOUNT_NUM 37 CONVERSION_RATE 36 CONVERSION_RATE_DATE 35 CONVERSION_RATE_TYPE_CODE 16 ENTERED_CR 15 ENTERED_DR 8 GL_BATCH_NAME 3 9 GL_BATCH_STATUS 6 GL_DATE 6 12 GL_JOURNAL_CATEGORY 13 GL_JOURNAL_LINE_NUM 5 10 GL_JOURNAL_NAME 4 11 GL_JOURNAL_SOURCE 7 GL_POSTED_DATE 33 GL_TRANSFER_DATE 34 JOURNAL_ENTRY_STATUS 2 LEDGER_CURRENCY 1 LEDGER_NAME 1 14 LINE_DESCRIPTION 26 PAYMENT_AMOUNT 21 PAYMENT_CURRENCY 24 PAYMENT_DATE 22 PAYMENT_DOCUMENT 7 23 PAYMENT_NUMBER 9 5 PERIOD_NAME 29 SLA_EVENT_CLASS_NAME 28 SLA_EVENT_DATE 27 SLA_EVENT_NUMBER 30 SLA_EVENT_TYPE_NAME 31 SLA_LINE_NUMBER 25 SUPPLIER_NAME 8 32 TRANSFER_TO_GL_STATUS S Site 0F3C3CBA8FEBE238F7ED8288EDF72215 Pivot: Summary by Account Y Pivot: Summary by Account SYSADMIN 6 ACCOUNT 2 112 ACCOUNTED_CR 111 ACCOUNTED_DR 7 ACCOUNT_DESCRIPTION 116 ACCOUNT_PIVOT_LABEL 1 APPLICATION_NAME 70 ATTRIBUTE1 79 ATTRIBUTE10 71 ATTRIBUTE2 72 ATTRIBUTE3 73 ATTRIBUTE4 74 ATTRIBUTE5 75 ATTRIBUTE6 76 ATTRIBUTE7 77 ATTRIBUTE8 78 ATTRIBUTE9 69 ATTRIBUTE_CATEGORY 34 BALANCE_TYPE 33 BALANCE_TYPE_CODE 10 BANK_ACCOUNT_NAME 9 BANK_ACCOUNT_NUM 3 117 BANK_ACCOUNT_PIVOT_LABEL 35 BUDGET_NAME 30 COMPLETED_DATE 8 CONTROL_ACCOUNT_FLAG 62 CONVERSION_RATE 63 CONVERSION_RATE_DATE 65 CONVERSION_RATE_TYPE 64 CONVERSION_RATE_TYPE_CODE 100 CREATED_BY 101 CREATION_DATE 36 ENCUMBRANCE_TYPE 108 ENTERED_CR 107 ENTERED_DR 37 FUND_STATUS 11 GL_BATCH_NAME 4 21 GL_BATCH_STATUS 115 GL_DATE 20 GL_DEFAULT_EFFECTIVE_DATE 26 GL_DOC_SEQUENCE_NAME 27 GL_DOC_SEQUENCE_VALUE 23 GL_EXTERNAL_REFERENCE 13 GL_JOURNAL_CATEGORY 15 GL_JOURNAL_LINE_NUM 14 GL_JOURNAL_NAME 12 GL_JOURNAL_SOURCE 22 GL_POSTED_DATE 24 GL_REFERENCE_1 25 GL_REFERENCE_4 28 GL_TRANSFER_DATE 16 HEADER_DESCRIPTION 31 JOURNAL_ENTRY_STATUS 102 LAST_UPDATE_DATE 5 LEDGER_CURRENCY 3 LEDGER_DESCRIPTION 4 LEDGER_NAME 1 2 LEDGER_SHORT_NAME 17 LINE_DESCRIPTION 68 PARTY_TYPE 67 PARTY_TYPE_CODE 106 PAYMENT_AMOUNT 18 PAYMENT_CURRENCY 5 104 PAYMENT_DATE 19 PAYMENT_DOCUMENT 6 103 PAYMENT_NUMBER 8 59 PERIOD_END_DATE 114 PERIOD_NAME 57 PERIOD_NUMBER 58 PERIOD_START_DATE 56 PERIOD_YEAR 61 PERIOD_YEAR_END_DATE 60 PERIOD_YEAR_START_DATE 66 RECONCILIATION_REFERENCE 29 REFERENCE_DATE 45 SLA_ACCOUNTING_CLASS_CODE 46 SLA_ACCOUNTING_CLASS_NAME 47 SLA_ACCOUNTING_SEQ_NAME 49 SLA_ACCOUNTING_SEQ_NUMBER 48 SLA_ACCOUNTING_SEQ_VERSION 53 SLA_DOCUMENT_CATEGORY 54 SLA_DOCUMENT_SEQ_NAME 55 SLA_DOCUMENT_SEQ_NUMBER 40 SLA_EVENT_CLASS_CODE 41 SLA_EVENT_CLASS_NAME 38 SLA_EVENT_DATE 39 SLA_EVENT_NUMBER 42 SLA_EVENT_TYPE_CODE 43 SLA_EVENT_TYPE_NAME 44 SLA_LINE_NUMBER 50 SLA_REPORTING_SEQ_NAME 52 SLA_REPORTING_SEQ_NUMBER 51 SLA_REPORTING_SEQ_VERSION 113 STATISTICAL_AMOUNT 105 SUPPLIER_NAME 7 32 TRANSFER_TO_GL_STATUS 110 UNROUNDED_ACCOUNTED_CR 109 UNROUNDED_ACCOUNTED_DR 80 USER_TRX_IDENTIFIER_NAME_1 98 USER_TRX_IDENTIFIER_NAME_10 82 USER_TRX_IDENTIFIER_NAME_2 84 USER_TRX_IDENTIFIER_NAME_3 86 USER_TRX_IDENTIFIER_NAME_4 88 USER_TRX_IDENTIFIER_NAME_5 90 USER_TRX_IDENTIFIER_NAME_6 92 USER_TRX_IDENTIFIER_NAME_7 94 USER_TRX_IDENTIFIER_NAME_8 96 USER_TRX_IDENTIFIER_NAME_9 81 USER_TRX_IDENTIFIER_VALUE_1 99 USER_TRX_IDENTIFIER_VALUE_10 83 USER_TRX_IDENTIFIER_VALUE_2 85 USER_TRX_IDENTIFIER_VALUE_3 87 USER_TRX_IDENTIFIER_VALUE_4 89 USER_TRX_IDENTIFIER_VALUE_5 91 USER_TRX_IDENTIFIER_VALUE_6 93 USER_TRX_IDENTIFIER_VALUE_7 95 USER_TRX_IDENTIFIER_VALUE_8 97 USER_TRX_IDENTIFIER_VALUE_9 ACCOUNTED_CR VALUE 2 SUM ACCOUNTED_DR VALUE 1 SUM ACCOUNT_PIVOT_LABEL ROW 1 BANK_ACCOUNT_NAME FILTER 4 BANK_ACCOUNT_NUM FILTER 3 GL_BATCH_NAME FILTER 9 LEDGER_CURRENCY FILTER 1 LEDGER_NAME FILTER 2 PAYMENT_CURRENCY FILTER 5 PAYMENT_DOCUMENT FILTER 6 PERIOD_NAME FILTER 8 SUPPLIER_NAME FILTER 7 S Site 0F769F654AC69AC9F1436BB4F1CC89C4 Pivot: Summary by Account, Bank Account, Batch, Payment Currency, Payment Document Y Pivot: Summary by Account, Bank Account, Batch, Payment Currency, Payment Document SYSADMIN 3 ACCOUNT 2 17 ACCOUNTED_CR 16 ACCOUNTED_DR 4 ACCOUNT_DESCRIPTION 19 ACCOUNT_PIVOT_LABEL 6 BANK_ACCOUNT_NAME 5 BANK_ACCOUNT_NUM 3 20 BANK_ACCOUNT_PIVOT_LABEL 15 ENTERED_CR 14 ENTERED_DR 7 GL_BATCH_NAME 4 2 LEDGER_CURRENCY 1 LEDGER_NAME 1 13 PAYMENT_AMOUNT 8 PAYMENT_CURRENCY 5 11 PAYMENT_DATE 9 PAYMENT_DOCUMENT 6 10 PAYMENT_NUMBER 8 18 PERIOD_NAME 12 SUPPLIER_NAME 7 ACCOUNTED_CR VALUE 4 SUM ACCOUNTED_DR VALUE 3 SUM ACCOUNT_PIVOT_LABEL ROW 1 BANK_ACCOUNT_PIVOT_LABEL ROW 2 ENTERED_CR VALUE 2 SUM ENTERED_DR VALUE 1 SUM GL_BATCH_NAME ROW 3 LEDGER_CURRENCY FILTER 2 LEDGER_NAME FILTER 1 PAYMENT_CURRENCY ROW 4 PAYMENT_DOCUMENT ROW 5 PERIOD_NAME FILTER 4 SUPPLIER_NAME FILTER 3 S Site A9AC87016D74C6AE10F2140C35180852 Pivot: Summary by Account, Batch, Bank Account, Payment Currency, Payment Document Y Pivot: Summary by Account, Batch, Bank Account, Payment Currency, Payment Document SYSADMIN 6 ACCOUNT 2 112 ACCOUNTED_CR 111 ACCOUNTED_DR 7 ACCOUNT_DESCRIPTION 116 ACCOUNT_PIVOT_LABEL 1 APPLICATION_NAME 70 ATTRIBUTE1 79 ATTRIBUTE10 71 ATTRIBUTE2 72 ATTRIBUTE3 73 ATTRIBUTE4 74 ATTRIBUTE5 75 ATTRIBUTE6 76 ATTRIBUTE7 77 ATTRIBUTE8 78 ATTRIBUTE9 69 ATTRIBUTE_CATEGORY 34 BALANCE_TYPE 33 BALANCE_TYPE_CODE 10 BANK_ACCOUNT_NAME 9 BANK_ACCOUNT_NUM 117 BANK_ACCOUNT_PIVOT_LABEL 35 BUDGET_NAME 30 COMPLETED_DATE 8 CONTROL_ACCOUNT_FLAG 62 CONVERSION_RATE 63 CONVERSION_RATE_DATE 65 CONVERSION_RATE_TYPE 64 CONVERSION_RATE_TYPE_CODE 100 CREATED_BY 101 CREATION_DATE 36 ENCUMBRANCE_TYPE 108 ENTERED_CR 107 ENTERED_DR 37 FUND_STATUS 11 GL_BATCH_NAME 3 21 GL_BATCH_STATUS 115 GL_DATE 20 GL_DEFAULT_EFFECTIVE_DATE 26 GL_DOC_SEQUENCE_NAME 27 GL_DOC_SEQUENCE_VALUE 23 GL_EXTERNAL_REFERENCE 13 GL_JOURNAL_CATEGORY 15 GL_JOURNAL_LINE_NUM 14 GL_JOURNAL_NAME 12 GL_JOURNAL_SOURCE 22 GL_POSTED_DATE 24 GL_REFERENCE_1 25 GL_REFERENCE_4 28 GL_TRANSFER_DATE 16 HEADER_DESCRIPTION 31 JOURNAL_ENTRY_STATUS 102 LAST_UPDATE_DATE 5 LEDGER_CURRENCY 3 LEDGER_DESCRIPTION 4 LEDGER_NAME 1 2 LEDGER_SHORT_NAME 17 LINE_DESCRIPTION 68 PARTY_TYPE 67 PARTY_TYPE_CODE 106 PAYMENT_AMOUNT 18 PAYMENT_CURRENCY 5 104 PAYMENT_DATE 19 PAYMENT_DOCUMENT 103 PAYMENT_NUMBER 7 59 PERIOD_END_DATE 114 PERIOD_NAME 57 PERIOD_NUMBER 58 PERIOD_START_DATE 56 PERIOD_YEAR 61 PERIOD_YEAR_END_DATE 60 PERIOD_YEAR_START_DATE 66 RECONCILIATION_REFERENCE 29 REFERENCE_DATE 45 SLA_ACCOUNTING_CLASS_CODE 46 SLA_ACCOUNTING_CLASS_NAME 47 SLA_ACCOUNTING_SEQ_NAME 49 SLA_ACCOUNTING_SEQ_NUMBER 48 SLA_ACCOUNTING_SEQ_VERSION 53 SLA_DOCUMENT_CATEGORY 54 SLA_DOCUMENT_SEQ_NAME 55 SLA_DOCUMENT_SEQ_NUMBER 40 SLA_EVENT_CLASS_CODE 41 SLA_EVENT_CLASS_NAME 38 SLA_EVENT_DATE 39 SLA_EVENT_NUMBER 42 SLA_EVENT_TYPE_CODE 43 SLA_EVENT_TYPE_NAME 44 SLA_LINE_NUMBER 50 SLA_REPORTING_SEQ_NAME 52 SLA_REPORTING_SEQ_NUMBER 51 SLA_REPORTING_SEQ_VERSION 113 STATISTICAL_AMOUNT 105 SUPPLIER_NAME 6 32 TRANSFER_TO_GL_STATUS 110 UNROUNDED_ACCOUNTED_CR 109 UNROUNDED_ACCOUNTED_DR 80 USER_TRX_IDENTIFIER_NAME_1 98 USER_TRX_IDENTIFIER_NAME_10 82 USER_TRX_IDENTIFIER_NAME_2 84 USER_TRX_IDENTIFIER_NAME_3 86 USER_TRX_IDENTIFIER_NAME_4 88 USER_TRX_IDENTIFIER_NAME_5 90 USER_TRX_IDENTIFIER_NAME_6 92 USER_TRX_IDENTIFIER_NAME_7 94 USER_TRX_IDENTIFIER_NAME_8 96 USER_TRX_IDENTIFIER_NAME_9 81 USER_TRX_IDENTIFIER_VALUE_1 99 USER_TRX_IDENTIFIER_VALUE_10 83 USER_TRX_IDENTIFIER_VALUE_2 85 USER_TRX_IDENTIFIER_VALUE_3 87 USER_TRX_IDENTIFIER_VALUE_4 89 USER_TRX_IDENTIFIER_VALUE_5 91 USER_TRX_IDENTIFIER_VALUE_6 93 USER_TRX_IDENTIFIER_VALUE_7 95 USER_TRX_IDENTIFIER_VALUE_8 97 USER_TRX_IDENTIFIER_VALUE_9 ACCOUNTED_CR VALUE 4 SUM ACCOUNTED_DR VALUE 3 SUM ACCOUNT_PIVOT_LABEL ROW 1 BANK_ACCOUNT_PIVOT_LABEL ROW 3 ENTERED_CR VALUE 2 SUM ENTERED_DR VALUE 1 SUM GL_BATCH_NAME ROW 2 LEDGER_CURRENCY FILTER 2 LEDGER_NAME FILTER 1 PAYMENT_CURRENCY ROW 4 PAYMENT_DOCUMENT ROW 5 PERIOD_NAME FILTER 4 SUPPLIER_NAME FILTER 3 S Site SYSADMIN A9AC87016D74C6AE10F2140C35180852 ALEXANDER.PAVLIK A9AC87016D74C6AE10F2140C35180852 0F3C3CBA8FEBE238F7ED8288EDF72215