GL Currency - Historical Rates Listing
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Historical Rates Listing Report
Application: General Ledger
Source: Currency - Historical Rates Listing (XML)
Short Name: GLXRLHST_XML
DB package: GL_GLXRLHST_XMLP_PKG
Description: Historical Rates Listing Report
Application: General Ledger
Source: Currency - Historical Rates Listing (XML)
Short Name: GLXRLHST_XML
DB package: GL_GLXRLHST_XMLP_PKG
Run
GL Currency - Historical Rates Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
select null FLEX_DATA_ALL, null FLEX_DATA_BAL, null FLEX_DATA_ACCT, ghr.period_year PERIOD_YEAR, ghr.period_num PERIOD_NUM, ghr.period_name PERIOD_NAME, ghr.target_currency TARGET_CURRENCY, gl1.meaning RATE_TYPE, ghr.translated_rate RATE, ghr.translated_amount AMOUNT, gl2.meaning ACCOUNT_TYPE, gl3.meaning USAGE_CODE, fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_field_all', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEX_FIELD_ALL, fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_desc_acct', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'FULL_DESCRIPTION') FLEX_DESC_ACCT from gl_lookups gl1, gl_lookups gl2, gl_lookups gl3, gl_code_combinations gcc, gl_historical_rates ghr where ghr.ledger_id = :P_LEDGER_ID and ghr.code_combination_id = gcc.code_combination_id and gl1.lookup_type (+) = 'RATE_TYPE' and gl1.lookup_code (+) = ghr.rate_type and gl2.lookup_type (+) = 'ACCOUNT TYPE' and gl2.lookup_code (+) = ghr.account_type and gl3.lookup_type(+) = 'CONSOLIDATION_USAGE' and gl3.lookup_code(+) = ghr.usage_code and ghr.period_year * 10000 + ghr.period_num between :FROM_EFF_PERIOD_NUM and :TO_EFF_PERIOD_NUM &WHERE_DAS order by ghr.period_year, ghr.period_num, ghr.target_currency, &FLEX_ORDERBY_BAL_D, &FLEX_ORDERBY_BAL_I, &FLEX_ORDERBY_ACCT_D, &FLEX_ORDERBY_ACCT_I, &FLEX_ORDERBY_ALL |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Ledger |
|
LOV Oracle | |
From Period |
|
LOV Oracle | |
To Period |
|
LOV Oracle |