GL Currency - Historical Rates Listing

Description
Categories: BI Publisher, Financials
Application: General Ledger
Source: Currency - Historical Rates Listing (XML)
Short Name: GLXRLHST_XML
DB package: GL_GLXRLHST_XMLP_PKG
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
Minimum precision
 
Number
Access Set Id
 
Number
To Period
 
LOV Oracle
From Period
 
LOV Oracle
Ledger
 
LOV Oracle