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）限制的操作单元。 35D3229F490D856DE06362FB09054CBC select y.* &invoice_amounts &il_reg_columns &il_columns_amt &il_columns_rate &il_columns_rec &il_columns_tp from ( 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 ,to_date(x.gl_date,'YYYY-MM-DD') 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 invoice_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_1 supplier_name ,x.transaction_number invoice_number ,trunc(to_date(x.transaction_date,'YYYY-MM-DD"T"hh:mi:ss')) invoice_date ,x.user_trx_identifier_value_10 invoice_description ,to_number(x.user_trx_identifier_value_4) invoice_amount -- other gl specific data ,x.gl_default_effective_date ,x.gl_batch_status ,to_date(x.posted_date,'YYYY-MM-DD') 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 ,trunc(to_date(x.gl_transfer_date,'YYYY-MM-DD"T"hh:mi:ss')) gl_transfer_date ,x.reference_date ,trunc(to_date(x.completed_date,'YYYY-MM-DD"T"hh:mi:ss')) 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_id sla_event_id ,to_date(x.event_date,'YYYY-MM-DD') 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 ,to_date(x.period_start_date,'YYYY-MM-DD') period_start_date ,to_date(x.period_end_date,'YYYY-MM-DD') period_end_date ,to_date(x.period_year_start_date,'YYYY-MM-DD') period_year_start_date ,to_date(x.period_year_end_date,'YYYY-MM-DD') 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 ,(select xte.source_id_int_1 from xla_transaction_entities xte, xla_ae_headers xah, xla_events xe where xah.event_id=xe.event_id and xe.application_id=xah.application_id and xe.event_id=x.event_id and xah.ledger_id=x.ledger_id and xah.ae_header_id=x.s_header_id and xte.entity_id=xah.entity_id and xe.application_id=nvl(fnd_profile.value('XLA_APPL_ID'),fnd_global.resp_appl_id) and xte.application_id=xah.application_id) invoice_id -- sla or gl audit colummns ,x.created_by ,trunc(to_date(x.creation_date,'YYYY-MM-DD"T"hh:mi:ss')) creation_date ,to_date(x.last_update_date,'YYYY-MM-DD') last_update_date -- ,x.accounting_code_combination || ' (' || x.code_combination_description || ')' 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 &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 &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 &il_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 1=1 &p_trx_id_filter &p_le_join &p_other_join &il_where ) x ) y Y SQLAP APXPOINV #,##0.000;[Red]-#,##0.000 CECD4823A6665281E05362FB09059328 (: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) US AP Posted Invoice Register(GST) Application: Payables Description: Payables Posted Invoice Register This report provides equivalent functionality to the Oracle standard Payables Posted Invoice 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, Invoice Currency Equivalent to standard report in Summarize Report = Yes Mode - Pivot: Summary by Account, Batch, Invoice Currency Equivalent to standard report in Summarize=No Order By=Journal Entry Batch - Pivot: Summary by Account, Invoice Currency, Batch Equivalent to standard report in Summarize=No Order By=Entered Currency - Detail Provides detail listing of the posted invoices Additional data fields are available. Run the report without a template to see full list available fields Source: Payables Posted Invoice Register Short Name: APXPOINV 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 GST Reports &il_columns_amt &il_columns_rate &il_columns_rec &il_columns_tp &il_from &il_reg_columns &il_where &invoice_amounts &lp_init_sql &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_id_filter &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_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 -110 1=1 :India_Localization=:India_Localization Char Y xxen_util.jai_installed US India Localization 2 &il_from ,(select s.party_id vendor_id, s.party_site_id vendor_site_id, s.gstin gstin_or_secondary, nvl(s.pan_site,nvl(s.sec_pan_site,nvl(h.pan_hdr,h.sec_pan_hdr))) pan_number, nvl(s.tan_site,nvl(s.sec_tan_site,nvl(h.tan_hdr,h.sec_tan_hdr))) tan_number from (select jpr.party_id, jpr.party_site_id, max(decode(jprl.registration_type_code,'GSTIN',nvl(jprl.registration_number,jprl.secondary_registration_number))) gstin, max(decode(jprl.registration_type_code,'PAN',jprl.registration_number)) pan_site, max(decode(jprl.registration_type_code,'TAN',jprl.registration_number)) tan_site, max(decode(jprl.sec_registration_type_code,'PAN',jprl.secondary_registration_number)) sec_pan_site, max(decode(jprl.sec_registration_type_code,'TAN',jprl.secondary_registration_number)) sec_tan_site from jai_party_regs_v jpr, jai_party_reg_lines_v jprl where jpr.party_reg_id=jprl.party_reg_id and jpr.party_type_code='THIRD_PARTY_SITE' and jprl.effective_from<=sysdate and (jprl.effective_to is null or jprl.effective_to>=sysdate) group by jpr.party_id, jpr.party_site_id) s, (select jpr.party_id, max(decode(jprl.registration_type_code,'PAN',jprl.registration_number)) pan_hdr, max(decode(jprl.registration_type_code,'TAN',jprl.registration_number)) tan_hdr, max(decode(jprl.sec_registration_type_code,'PAN',jprl.secondary_registration_number)) sec_pan_hdr, max(decode(jprl.sec_registration_type_code,'TAN',jprl.secondary_registration_number)) sec_tan_hdr from jai_party_regs_v jpr, jai_party_reg_lines_v jprl where jpr.party_reg_id=jprl.party_reg_id and jpr.party_type_code='THIRD_PARTY' and jprl.effective_from<=sysdate and (jprl.effective_to is null or jprl.effective_to>=sysdate) group by jpr.party_id) h where s.party_id=h.party_id(+) ) il_reg ,(select jtlv.trx_id, jtlv.trx_line_id, sum(decode(jrav.reporting_code,'CGST',jtlv.rounded_tax_amt_trx_curr)) cgst_amount, sum(decode(jrav.reporting_code,'SGST',jtlv.rounded_tax_amt_trx_curr)) sgst_amount, sum(decode(jrav.reporting_code,'IGST',jtlv.rounded_tax_amt_trx_curr)) igst_amount, sum(decode(jrav.reporting_code,'CESS',jtlv.rounded_tax_amt_trx_curr)) cess_amount, max(decode(jrav.reporting_code,'CGST',jtlv.tax_rate_code)) cgst_tax_rate, max(decode(jrav.reporting_code,'SGST',jtlv.tax_rate_code)) sgst_tax_rate, max(decode(jrav.reporting_code,'IGST',jtlv.tax_rate_code)) igst_tax_rate, max(decode(jrav.reporting_code,'CESS',jtlv.tax_rate_code)) cess_tax_rate, sum(decode(jrav.reporting_code,'CGST',jtlv.rec_tax_amt_trx_curr)) cgst_rec_amount, sum(decode(jrav.reporting_code,'CGST',jtlv.nrec_tax_amt_trx_curr)) cgst_nrec_amount, sum(decode(jrav.reporting_code,'SGST',jtlv.rec_tax_amt_trx_curr)) sgst_rec_amount, sum(decode(jrav.reporting_code,'SGST',jtlv.nrec_tax_amt_trx_curr)) sgst_nrec_amount, sum(decode(jrav.reporting_code,'IGST',jtlv.rec_tax_amt_trx_curr)) igst_rec_amount, sum(decode(jrav.reporting_code,'IGST',jtlv.nrec_tax_amt_trx_curr)) igst_nrec_amount, max(jtlv.self_assessed_flag) reverse_charge_flag from jai_tax_lines_v jtlv, jai_reporting_associations_v jrav where jrav.entity_id(+)=jtlv.tax_type_id and jrav.entity_code(+)='TAX_TYPE' and jrav.reporting_type_code(+)='TAX_TYPES_CLASSIFICATION' and jtlv.application_id=200 group by jtlv.trx_id, jtlv.trx_line_id ) il_tax Y US India Localization 3 &il_reg_columns il_reg.gstin_or_secondary gst_registration_no, il_reg.pan_number gst_pan_no, il_reg.tan_number gst_tan_no, Y US India Localization 4 &il_where and aia.vendor_id=il_reg.vendor_id(+) and aia.vendor_site_id=il_reg.vendor_site_id(+) and y.invoice_id=il_tax.trx_id(+) Y US India Localization 5 -50 &invoice_amounts select ',((case when trim(translate(y.user_trx_identifier_value_4, ''0123456789-.'','' '')) is null then to_number(y.user_trx_identifier_value_4) else to_number(null) end)-nvl((select aia.total_tax_amount from ap_invoices_all aia where aia.invoice_id=y.invoice_id),0)) total_line_amount, (select aia.total_tax_amount from ap_invoices_all aia where aia.invoice_id=y.invoice_id) total_tax_amount' from dual Char Y US Show Total Invoice Line and Tax Columns 6 -40 :p_report_code Char APXPOINV F Code du rapport US Report Code 7 -30 &lp_template_columns select ' 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' from dual where :p_template_flag = 'Y' and :run_id is null Char Y F Colonnes du modèle US Template Columns 8 -20 &lp_template_table select 'dual ' from dual where :p_template_flag = 'Y' and :run_id is null Char Y F Tableau des modèles US Template Table 9 -10 &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 10 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 D Betriebseinheit Betriebseinheit F Unité d'exploitation Unité opérationnelle I Unità operativa Unità operativa US Operating Unit Operating Unit ZHS 业务实体 业务实体 11 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 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 分类帐/分类帐集 分类帐或分类帐集的内部标识 12 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 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 期间自 附加至分类帐或分类帐集的日历起始期间 13 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 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 期间至 附加至分类帐或分类帐集的日历终止期间 14 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 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 日记帐分录来源名称 15 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 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 包括金额为零的行 用于指明金额为零的行是否要报告的标志 16 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 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 帐户弹性域自 会计科目弹性域范围的起始值 17 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 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 帐户弹性域至 会计科目弹性域范围的终止值 18 90 :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 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 100 :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 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 110 :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 120 :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