ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 41D6D8E6DBFCCFA3E06362FB090507E0 SELECT /*+ index(xdl, XLA_DISTRIBUTION_LINKS_N3) */ zxr.tax_regime_name TAX_REGIME_NAME ,zxl.tax_regime_code TAX_REGIME_CODE ,zxl.tax TAX ,ztt.tax_full_name TAX_NAME ,zst.tax_status_name TAX_STATUS_NAME ,zxl.tax_status_code TAX_STATUSC_CODE ,zrt.tax_rate_name TAX_RATE_NAME ,zxl.tax_rate TAX_RATE ,zxl.tax_type_code TAX_TYPE_CODE ,zxl.tax_rate_code TAX_RATE_CODE FROM xla_distribution_links xdl ,zx_lines zxl ,zx_regimes_tl zxr ,zx_taxes_tl ztt ,zx_status_tl zst ,zx_rates_tl zrt WHERE :p_include_tax_details_flag = 'Y' AND zxr.tax_regime_id(+) = zxl.tax_regime_id AND zxr.language(+) = USERENV('LANG') AND ztt.tax_id(+) = zxl.tax_id AND ztt.language(+) = USERENV('LANG') AND zst.tax_status_id(+) = zxl.tax_status_id AND zst.language(+) = USERENV('LANG') AND zrt.tax_rate_id(+) = zxl.tax_rate_id AND zrt.language(+) = USERENV('LANG') AND xdl.application_id = :APPLICATION_ID AND xdl.ae_header_id = :HEADER_ID AND xdl.ae_line_num = :ORIG_LINE_NUMBER AND xdl.tax_line_ref_id = zxl.tax_line_id AND :ACCOUNTING_CLASS_CODE in ('TAX','RTAX','NRTAX') UNION ALL SELECT /*+ index(xdl, XLA_DISTRIBUTION_LINKS_N3) */ zxr.tax_regime_name TAX_REGIME_NAME ,zxl.tax_regime_code TAX_REGIME_CODE ,zxl.tax TAX ,ztt.tax_full_name TAX_NAME ,zst.tax_status_name TAX_STATUS_NAME ,zxl.tax_status_code TAX_STATUSC_CODE ,zrt.tax_rate_name TAX_RATE_NAME ,zxl.tax_rate TAX_RATE ,zxl.tax_type_code TAX_TYPE_CODE ,zxl.tax_rate_code TAX_RATE_CODE FROM xla_distribution_links xdl ,zx_lines zxl ,zx_regimes_tl zxr ,zx_taxes_tl ztt ,zx_status_tl zst ,zx_rates_tl zrt ,ra_cust_trx_line_gl_dist_all rd WHERE :p_include_tax_details_flag = 'Y' AND zxr.tax_regime_id(+) = zxl.tax_regime_id AND zxr.language(+) = USERENV('LANG') AND ztt.tax_id(+) = zxl.tax_id AND ztt.language(+) = USERENV('LANG') AND zst.tax_status_id(+) = zxl.tax_status_id AND zst.language(+) = USERENV('LANG') AND zrt.tax_rate_id(+) = zxl.tax_rate_id AND zrt.language(+) = USERENV('LANG') AND xdl.application_id = 222 --:APPLICATION_ID AND xdl.ae_header_id = :HEADER_ID AND xdl.ae_line_num = :ORIG_LINE_NUMBER AND xdl.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL' AND rd.cust_trx_line_gl_dist_id=xdl.source_distribution_id_num_1 AND rd.customer_trx_line_id = zxl.trx_line_id AND rd.customer_trx_id = zxl.trx_id AND zxl.application_id =222 AND :ACCOUNTING_CLASS_CODE in ('REVENUE','SUSPENSE','UNBILL','UNEARNED_REVENUE') UNION ALL SELECT /*+ index(xdl, XLA_DISTRIBUTION_LINKS_N3) */ zxr.tax_regime_name TAX_REGIME_NAME ,zxl.tax_regime_code TAX_REGIME_CODE ,zxl.tax TAX ,ztt.tax_full_name TAX_NAME ,zst.tax_status_name TAX_STATUS_NAME ,zxl.tax_status_code TAX_STATUSC_CODE ,zrt.tax_rate_name TAX_RATE_NAME ,zxl.tax_rate TAX_RATE ,zxl.tax_type_code TAX_TYPE_CODE ,zxl.tax_rate_code TAX_RATE_CODE FROM xla_distribution_links xdl ,zx_lines zxl ,zx_regimes_tl zxr ,zx_taxes_tl ztt ,zx_status_tl zst ,zx_rates_tl zrt ,ra_cust_trx_line_gl_dist_all rd ,ra_customer_trx_lines_all rl WHERE :p_include_tax_details_flag = 'Y' AND zxr.tax_regime_id(+) = zxl.tax_regime_id AND zxr.language(+) = USERENV('LANG') AND ztt.tax_id(+) = zxl.tax_id AND ztt.language(+) = USERENV('LANG') AND zst.tax_status_id(+) = zxl.tax_status_id AND zst.language(+) = USERENV('LANG') AND zrt.tax_rate_id(+) = zxl.tax_rate_id AND zrt.language(+) = USERENV('LANG') AND xdl.application_id = 222 --:APPLICATION_ID AND xdl.ae_header_id = :HEADER_ID AND xdl.ae_line_num = :ORIG_LINE_NUMBER AND rd.customer_trx_id = rl.customer_trx_id AND rd.customer_trx_line_id= rl.customer_trx_line_id AND xdl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL' AND xdl.APPLIED_TO_DISTRIBUTION_TYPE='RA_CUST_TRX_LINE_GL_DIST_ALL' AND rd.cust_trx_line_gl_dist_id=xdl.APPLIED_TO_DIST_ID_NUM_1 AND rd.customer_trx_id = zxl.trx_id AND (rl.customer_trx_line_id = zxl.trx_line_id or rl.tax_line_id= zxl.tax_line_id) AND zxl.application_id =222 AND :ACCOUNTING_CLASS_CODE in ('REVENUE','SUSPENSE','UNBILL','UNEARNED_REVENUE','TAX') UNION ALL SELECT /*+ index(xdl, XLA_DISTRIBUTION_LINKS_N3) */ zxr.tax_regime_name TAX_REGIME_NAME ,zxl.tax_regime_code TAX_REGIME_CODE ,zxl.tax TAX ,ztt.tax_full_name TAX_NAME ,zst.tax_status_name TAX_STATUS_NAME ,zxl.tax_status_code TAX_STATUSC_CODE ,zrt.tax_rate_name TAX_RATE_NAME ,zxl.tax_rate TAX_RATE ,zxl.tax_type_code TAX_TYPE_CODE ,zxl.tax_rate_code TAX_RATE_CODE FROM xla_distribution_links xdl ,zx_lines zxl ,zx_regimes_tl zxr ,zx_taxes_tl ztt ,zx_status_tl zst ,zx_rates_tl zrt ,ap_invoice_distributions_all ID WHERE :p_include_tax_details_flag = 'Y' AND zxr.tax_regime_id(+) = zxl.tax_regime_id AND zxr.language(+) = USERENV('LANG') AND ztt.tax_id(+) = zxl.tax_id AND ztt.language(+) = USERENV('LANG') AND zst.tax_status_id(+) = zxl.tax_status_id AND zst.language(+) = USERENV('LANG') AND zrt.tax_rate_id(+) = zxl.tax_rate_id AND zrt.language(+) = USERENV('LANG') AND xdl.application_id = 200 --:APPLICATION_ID AND xdl.ae_header_id = :HEADER_ID AND xdl.ae_line_num = :ORIG_LINE_NUMBER AND ID.invoice_distribution_id=xdl.source_distribution_id_num_1 AND xdl.source_distribution_type = 'AP_INV_DIST' AND xdl.application_id = 200 AND ID.invoice_line_number = zxl.trx_line_id AND ID.invoice_id = zxl.trx_id AND zxl.application_id =200 AND :ACCOUNTING_CLASS_CODE in ('ITEM EXPENSE','ACCRUAL') UNION ALL SELECT zxrgtl.tax_regime_name TAX_REGIME_NAME ,zxrgb.tax_regime_code TAX_REGIME_CODE ,zxtb.tax TAX ,zxttl.tax_full_name TAX_NAME ,zxtstl.tax_status_name TAX_STATUS_NAME ,zxtsb.tax_status_code TAX_STATUSC_CODE ,zxrtl.tax_rate_name TAX_RATE_NAME ,zxrb.percentage_rate TAX_RATE ,zxtb.tax_type_code TAX_TYPE_CODE ,zxrb.tax_rate_code TAX_RATE_CODE FROM gl_je_lines jel ,zx_rates_b zxrb ,zx_rates_tl zxrtl ,zx_taxes_b zxtb ,zx_taxes_tl zxttl ,zx_regimes_b zxrgb ,zx_regimes_tl zxrgtl ,zx_status_b zxtsb ,zx_status_tl zxtstl WHERE :p_include_tax_details_flag = 'Y' AND jel.je_header_id = :HEADER_ID AND jel.je_line_num = :ORIG_LINE_NUMBER AND jel.ledger_id = :LEDGER_ID AND jel.tax_code_id = zxrb.tax_rate_id AND zxrb.tax_rate_id = zxrtl.tax_rate_id AND zxtb.tax_id = zxttl.tax_id AND zxrgb.tax_regime_id = zxrgtl.tax_regime_id AND zxtsb.tax_status_id = zxtstl.tax_status_id AND zxrtl.language = userenv('LANG') AND zxttl.language = userenv('LANG') AND zxrgtl.language = userenv('LANG') AND zxtstl.language = userenv('LANG') AND zxrb.tax_regime_code = zxtb.tax_regime_code AND zxrb.tax = zxtb.tax AND (zxrb.content_owner_id = zxtb.content_owner_id OR zxtb.content_owner_id = -99) AND zxrb.tax_regime_code = zxrgb.tax_regime_code AND zxrb.tax_regime_code = zxtsb.tax_regime_code AND zxrb.tax = zxtsb.tax AND zxrb.tax_status_code = zxtsb.tax_status_code AND (zxrb.content_owner_id = zxtsb.content_owner_id OR zxtsb.content_owner_id = -99) Y JG JGSLAAANA AR JG تقرير تحليل الحساب العام Imported from BI Publisher Application: المحليات الأقليمية Source: تقرير تحليل الحساب العام Short Name: JGSLAAANA DB package: XLA_ACCT_ANALYSIS_RPT_PKG D JG Kontenanalyse (global) Imported from BI Publisher Application: Regionale Lokalisierungen Source: Kontenanalyse (global) Short Name: JGSLAAANA DB package: XLA_ACCT_ANALYSIS_RPT_PKG E JG Análisis de Cuenta Regional Global Imported from BI Publisher Application: Localizaciones Regionales Source: Análisis de Cuenta Regional Global Short Name: JGSLAAANA DB package: XLA_ACCT_ANALYSIS_RPT_PKG F JG Etat global d'analyse des comptes Imported from BI Publisher Application: Regional Localizations Source: Etat global d'analyse des comptes Short Name: JGSLAAANA DB package: XLA_ACCT_ANALYSIS_RPT_PKG I JG Rapporto Analisi conto globale Imported from BI Publisher Application: Regional Localizations Source: Rapporto Analisi conto globale Short Name: JGSLAAANA DB package: XLA_ACCT_ANALYSIS_RPT_PKG JA JG グローバル勘定科目分析レポート Imported from BI Publisher Application: Regional Localizations Source: グローバル勘定科目分析レポート Short Name: JGSLAAANA DB package: XLA_ACCT_ANALYSIS_RPT_PKG KO JG 글로벌 계정 분석 보고서 Imported from BI Publisher Application: Regional Localizations Source: 글로벌 계정 분석 보고서 Short Name: JGSLAAANA DB package: XLA_ACCT_ANALYSIS_RPT_PKG PTB JG Relatório de Análise de Conta Global Imported from BI Publisher Application: Locais Regionais Source: Relatório de Análise de Conta Global Short Name: JGSLAAANA DB package: XLA_ACCT_ANALYSIS_RPT_PKG RU JG Глобальный отчет об анализе счетов Imported from BI Publisher Application: Местные версии Source: Глобальный отчет об анализе счетов Short Name: JGSLAAANA DB package: XLA_ACCT_ANALYSIS_RPT_PKG S JG Kontoanalys - rapport Imported from BI Publisher Application: Regional Localizations Source: Globalt: Kontoanalys - rapport Short Name: JGSLAAANA DB package: XLA_ACCT_ANALYSIS_RPT_PKG TR JG Global Hesap Analizi Raporu Imported from BI Publisher Application: Bölgesel Yerelleştirmeler Source: Global Hesap Analizi Raporu Short Name: JGSLAAANA DB package: XLA_ACCT_ANALYSIS_RPT_PKG US JG Global Account Analysis Imported from BI Publisher Application: Regional Localizations Source: Global Account Analysis Report Short Name: JGSLAAANA DB package: XLA_ACCT_ANALYSIS_RPT_PKG ZHS JG 全局账户分析报表 Imported from BI Publisher Application: 区域性本地化 Source: 全局账户分析报表 Short Name: JGSLAAANA DB package: XLA_ACCT_ANALYSIS_RPT_PKG BI Publisher 1=1 :p_account_flexfield_from :p_account_flexfield_to :p_account_segment_from :p_account_segment_to :p_application_id :p_balance_amount_from :p_balance_amount_to :p_balance_side :p_balance_side_code :p_balance_type :p_balance_type_code :p_balancing_segment_from :p_balancing_segment_to :p_begin_balance_union_all :p_budget_name :p_budget_version_id :p_coa_id :p_commercial_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_doc_seq_name :p_doc_seq_num_from :p_doc_seq_num_to :p_dummy_budget_version :p_dummy_encumbrance_type :p_encumbrance_type :p_encumbrance_type_id :p_gl_application_id_filter :p_gl_col_end :p_gl_col_start :p_gl_date_from :p_gl_date_to :p_gl_from :p_gl_main_filter :p_gl_other_filter :p_gt_le_col :p_gt_lgr_sgmt_col :p_inc_acct_with_no_act :p_include_acct_with_no_act :p_include_le_info_flag :p_include_legal_entity :p_include_stat_amount_lines :p_include_stat_amt_lines :p_include_tax_details :p_include_tax_details_flag :p_include_user_trx_id :p_include_user_trx_id_flag :p_include_zero_amount_lines :p_include_zero_amt_lines :p_je_source_name :p_je_source_period :p_ledger :p_ledger_filters :p_ledger_id :p_legal_ent_col :p_legal_ent_from :p_legal_ent_join :p_legal_entity :p_legal_entity_id :p_long_report :p_main_col_end :p_main_col_start :p_main_le_col :p_main_lgr_sgmt_col :p_order_by_clause :p_party_col :p_party_columns :p_party_join :p_party_tab :p_period_from :p_period_to :p_qualifier_segment :p_resp_application_id :p_seg_desc_from :p_seg_desc_join :p_sla_application_id_filter :p_sla_col_end :p_sla_col_start :p_sla_from :p_sla_main_filter :p_sla_other_filter :p_tax_query :p_trx_identifiers :p_trx_identifiers_1 :p_trx_identifiers_2 :p_trx_identifiers_3 :p_trx_identifiers_4 :p_trx_identifiers_5 :p_union_all :p_upg_gl_from :p_upg_gl_main_filter :p_vat_registration_query 1 -180 :p_resp_application_id Char fnd_profile.value('RESP_APPL_ID') US P_RESP_APPLICATION_ID Responsibility Application ID 2 -170 :p_ledger Char SELECT NAME FROM GL_LEDGERS WHERE LEDGER_ID = :$flex$.ledger US P_LEDGER Ledger Name 3 -160 :p_legal_entity Char SELECT NAME FROM XLE_FIRSTPARTY_INFORMATION_V WHERE LEGAL_ENTITY_ID = :$flex$.legal_entity US P_LEGAL_ENTITY Legal Entity Name 4 -150 :p_coa_id LOV Oracle JGSLA_CHART_OF_ACCOUNTS Y select chart_of_accounts_id id, chart_of_accounts_id value, null description from gl_ledgers where ledger_id=:$flex$.jgsla_jelines_ledgers order by value,description SELECT chart_of_accounts_id FROM gl_ledgers WHERE ledger_id = :$flex$.ledger US P_COA_ID Chart of Accounts ID 5 -140 :p_balance_type_code LOV Oracle XLA_SRS_BALANCE_TYPE Y select lookup_code id, meaning value, null description from xla_lookups where lookup_type='XLA_BALANCE_TYPE' order by value,description SELECT Meaning FROM XLA_LOOKUPS WHERE lookup_type = 'XLA_BALANCE_TYPE' AND lookup_code ='A' US P_BALANCE_TYPE_CODE Balance Type Code 6 -130 :p_include_tax_details Char SELECT :$flex$.display_vat_code.VALUE FROM DUAL US P_INCLUDE_TAX_DETAILS Display VAT Code 7 -120 :p_include_legal_entity Char SELECT :$flex$.include_legal_entity_information.VALUE from dual US P_INCLUDE_LEGAL_ENTITY_INFO Include Legal Entity Info 8 -110 :p_include_zero_amt_lines Char SELECT :$flex$.include_zero_amount_lines.VALUE FROM DUAL US P_INCLUDE_ZERO_AMT_LINES Include Zero Amount Lines Flag 9 -100 :p_custom_parameter_12 Char select release_name from fnd_product_groups where rownum=1 US P_CUSTOM_PARAMETER_12 Software Code Version 10 -90 :p_custom_parameter_13 Char fnd_profile.value('USERNAME') US P_CUSTOM_PARAMETER_13 User Name 11 -80 :p_custom_parameter_14 Char SELECT user_concurrent_program_name FROM FND_CONCURRENT_PROGRAMS_VL WHERE concurrent_program_name='JGSLAAANA' US P_CUSTOM_PARAMETER_14 Report Title 12 -70 :p_custom_parameter_16 Char SELECT :$flex$.first_report_sort.VALUE FROM DUAL US P_CUSTOM_PARAMETER_16 First Sort Order Description 13 -60 :p_custom_parameter_17 Char SELECT :$flex$.second_report_sort.VALUE FROM DUAL US P_CUSTOM_PARAMETER_17 Second Sort Order Description 14 -50 :p_custom_parameter_18 Char SELECT :$flex$.third_report_sort.VALUE FROM DUAL US P_CUSTOM_PARAMETER_18 Third Sort Order Description 15 -40 :p_inc_acct_with_no_act Char SELECT :$flex$.include_accounts_with_no_activity.VALUE FROM DUAL US P_INC_ACCT_WITH_NO_ACT Include Accounts With No Activity 16 -30 :p_custom_parameter_23 Char SELECT :$flex$.first_flexfield_segment_used.VALUE FROM DUAL US P_CUSTOM_PARAMETER_23 For output paramater page use only 17 -20 :p_custom_parameter_24 Char SELECT :$flex$.second_flexfield_segment_used.VALUE FROM DUAL US P_CUSTOM_PARAMETER_24 For output paramater page use only 18 -10 :p_custom_parameter_25 Char SELECT :$flex$.third_flexfield_segment_used.VALUE FROM DUAL US P_CUSTOM_PARAMETER_25 For output paramater page use only 19 10 :p_ledger_id LOV Oracle JGSLA_JELINES_LEDGERS Y select ledger_id id, name value, description description from gl_ledgers a where a.object_type_code='L' and ( 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 (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 (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) ) ) ) ) order by value,description Y US Ledger Ledger ID 20 20 :p_legal_entity_id LOV Oracle JGSLA_LEGAL_ENTITIES Y select gle.legal_entity_id id, xfi.name value, null description from gl_ledger_le_v gle,xle_firstparty_information_v xfi where gle.ledger_id=:$flex$.jgsla_jelines_ledgers and gle.legal_entity_id=xfi.legal_entity_id order by xfi.name Y US Legal Entity Legal Entity ID 21 30 :p_period_from LOV Oracle JGSLA_JELINES_PERIOD_FROM Y select period_name id, period_name value, null description from gl_ledgers gl,gl_periods glp where gl.ledger_id=:$flex$.jgsla_jelines_ledgers 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 Y US Period From Period From 22 40 :p_period_to LOV Oracle JGSLA_JELINES_PERIOD_TO Y select period_name id, period_name value, null description from gl_ledgers gl,gl_periods glp where glp.adjustment_period_flag='N' and gl.ledger_id=:$flex$.jgsla_jelines_ledgers 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$.jgsla_jelines_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$.jgsla_jelines_period_from ) order by glp.period_year desc,glp.period_num desc SELECT :$flex$.period_from FROM DUAL Y US Period To Period To 23 50 :p_gl_date_from Date SELECT To_char(glp.start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')) FROM gl_periods glp, gl_ledgers gl WHERE gl.ledger_id = :$flex$.ledger AND glp.period_set_name = gl.period_set_name AND glp.period_name = :$flex$.period_from US GL Date From GL Date From 24 60 :p_gl_date_to Date SELECT To_char(glp.end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')) FROM gl_periods glp, gl_ledgers gl WHERE gl.ledger_id = :$flex$.ledger AND glp.period_set_name = gl.period_set_name AND glp.period_name = :$flex$.period_to US GL Date To GL Date To 25 70 :p_account_flexfield_from Char US Accounting Flexfield From Accounting Flexfield From 26 80 :p_account_flexfield_to Char US Accounting Flexfield To Accounting Flexfield To 27 90 :p_include_tax_details_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 SELECT MEANING FROM XLA_LOOKUPS WHERE LOOKUP_TYPE = 'XLA_YES_NO' AND LOOKUP_CODE = 'N' US Display VAT Code Flag to indicate if tax detail is to be displayed in the report 28 100 :p_include_le_info_flag LOV Oracle XLA_SRS_COMPANY_INFO Y select lookup_code id, meaning value, null description from xla_lookups where lookup_type='XLA_COMPANY_INFO_SOURCE' order by value,description SELECT MEANING FROM XLA_LOOKUPS WHERE LOOKUP_TYPE = 'XLA_COMPANY_INFO_SOURCE' AND LOOKUP_CODE = 'NONE' US Include Legal Entity Information Flag to indicate if legal entity information is to be displayed in the report 29 110 :p_include_zero_amount_lines 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 SELECT meaning FROM xla_lookups WHERE lookup_type ='XLA_YES_NO' and lookup_code ='N' US Include Zero Amount Lines Include Zero Amount Lines Flag 30 120 :p_custom_parameter_1 LOV Oracle JGSLA_FLEX_SET1 Y select lookup_code id, meaning value, null description from fnd_lookup_values where lookup_type='JGSLA_RPT_FLEX_PARAMS' and language=userenv('LANG') order by value,description US First Flexfield Segment Used First Flexfield Segment Used 31 130 :p_custom_parameter_2 LOV Oracle JGSLA_FLEX_SET2 Y select lookup_code id, meaning value, null description from fnd_lookup_values where lookup_type='JGSLA_RPT_FLEX_PARAMS' and lookup_code<>:$flex$.jgsla_flex_set1 and language=userenv('LANG') order by value,description US Second Flexfield Segment Used Second Flexfield Segment Used 32 140 :p_custom_parameter_3 LOV Oracle JGSLA_FLEX_SET3 Y select lookup_code id, meaning value, null description from fnd_lookup_values where lookup_type='JGSLA_RPT_FLEX_PARAMS' and lookup_code<>:$flex$.jgsla_flex_set1 and lookup_code<>:$flex$.jgsla_flex_set2 and language=userenv('LANG') order by value,description US Third Flexfield Segment Used Third Flexfield Segment Used 33 150 :p_custom_parameter_4 LOV Oracle JGSLAJNLTP_SORT_SET1 Y select lookup_code id, meaning value, null description from fnd_lookup_values where lookup_type='JGSLAJNLTP_RPT_SORT_PARAMS' and language=userenv('LANG') order by value,description SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE='JGSLAJNLTP_RPT_SORT_PARAMS' AND LOOKUP_CODE = 'GL_DATE' Y US First Report Sort First Report Sort 34 160 :p_custom_parameter_5 LOV Oracle JGSLAJNLTP_SORT_SET2 Y select lookup_code id, meaning value, null description from fnd_lookup_values where lookup_type='JGSLAJNLTP_RPT_SORT_PARAMS' and lookup_code<>:$flex$.jgslajnltp_sort_set1 and language=userenv('LANG') order by value,description SELECT DECODE(:$flex$.first_report_sort,'GL_DATE',MEANING,null) MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'JGSLAJNLTP_RPT_SORT_PARAMS' and LOOKUP_CODE = 'ACCOUNTING_SEQUENCE_NAME' Y US Second Report Sort Second Report Sort 35 170 :p_custom_parameter_6 LOV Oracle JGSLAJNLTP_SORT_SET3 Y select lookup_code id, meaning value, null description from fnd_lookup_values where lookup_type='JGSLAJNLTP_RPT_SORT_PARAMS' and lookup_code<>:$flex$.jgslajnltp_sort_set1 and lookup_code<>:$flex$.jgslajnltp_sort_set2 and language=userenv('LANG') order by value,description SELECT DECODE(:$flex$.first_report_sort||:$flex$.second_report_sort, 'GL_DATE'||'ACCOUNTING_SEQUENCE_NAME',MEANING,null) MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'JGSLAJNLTP_RPT_SORT_PARAMS' and LOOKUP_CODE = 'ACCOUNTING_SEQUENCE_NUMBER' Y US Third Report Sort Third Report Sort 36 180 :p_custom_parameter_10 Number US First Page Number First Page Number 37 190 :p_custom_parameter_15 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 US Assign Zero Beginning Balances Zero Beginning Balances 38 200 :p_include_acct_with_no_act 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 SELECT meaning FROM xla_lookups WHERE lookup_type = 'XLA_YES_NO' and lookup_code ='N' US Include Accounts With No Activity Include Accounts With No Activity :$flex$.display_vat_code.VALUE Display VAT Code P_INCLUDE_TAX_DETAILS value :$flex$.first_flexfield_segment_used.VALUE First Flexfield Segment Used P_CUSTOM_PARAMETER_23 value :$flex$.first_report_sort First Report Sort Second Report Sort :$flex$.first_report_sort First Report Sort Third Report Sort :$flex$.first_report_sort.VALUE First Report Sort P_CUSTOM_PARAMETER_16 value :$flex$.include_accounts_with_no_activity.VALUE Include Accounts With No Activity P_INC_ACCT_WITH_NO_ACT value :$flex$.include_legal_entity_information.VALUE Include Legal Entity Information P_INCLUDE_LEGAL_ENTITY_INFO value :$flex$.include_zero_amount_lines.VALUE Include Zero Amount Lines P_INCLUDE_ZERO_AMT_LINES value :$flex$.jgsla_flex_set1 First Flexfield Segment Used Second Flexfield Segment Used :$flex$.jgsla_flex_set1 First Flexfield Segment Used Third Flexfield Segment Used :$flex$.jgsla_flex_set2 Second Flexfield Segment Used Third Flexfield Segment Used :$flex$.jgsla_jelines_ledgers Ledger Legal Entity :$flex$.jgsla_jelines_ledgers Ledger P_COA_ID :$flex$.jgsla_jelines_ledgers Ledger Period From :$flex$.jgsla_jelines_ledgers Ledger Period To :$flex$.jgsla_jelines_period_from Period From Period To :$flex$.jgslajnltp_sort_set1 First Report Sort Second Report Sort :$flex$.jgslajnltp_sort_set1 First Report Sort Third Report Sort :$flex$.jgslajnltp_sort_set2 Second Report Sort Third Report Sort :$flex$.ledger Ledger GL Date From :$flex$.ledger Ledger GL Date To :$flex$.ledger Ledger P_COA_ID :$flex$.ledger Ledger P_LEDGER :$flex$.legal_entity Legal Entity P_LEGAL_ENTITY :$flex$.period_from Period From GL Date From :$flex$.period_from Period From Period To :$flex$.period_to Period To GL Date To :$flex$.second_flexfield_segment_used.VALUE Second Flexfield Segment Used P_CUSTOM_PARAMETER_24 value :$flex$.second_report_sort Second Report Sort Third Report Sort :$flex$.second_report_sort.VALUE Second Report Sort P_CUSTOM_PARAMETER_17 value :$flex$.third_flexfield_segment_used.VALUE Third Flexfield Segment Used P_CUSTOM_PARAMETER_25 value :$flex$.third_report_sort.VALUE Third Report Sort P_CUSTOM_PARAMETER_18 value