GL Currency - Historical Rates Listing

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

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