FND Design Data [Home] [Help]

View: GLFV_GL_PERIOD_EXCHANGE_RATES

Product: GL - General Ledger
Description: General Ledger period exchange rates are average, period-end, and revaluation conversion rates defined between any two currencies.
Implementation/DBA Data: ViewAPPS.GLFV_GL_PERIOD_EXCHANGE_RATES
View Text

SELECT GL_LEDGERS.LEDGER_ID
, GL_LEDGERS.NAME
, PS.PERIOD_NAME
, PERT.TO_CURRENCY
, LK.MEANING
, PART.CONVERSION_RATE
, PERT.CONVERSION_RATE
FROM GL_LOOKUPS LK
, GL_PERIOD_STATUSES PS
, GL_ROW_MULTIPLIERS MULT
, GL_DAILY_RATES PERT
, GL_DAILY_RATES PART
, GL_LEDGERS GL_LEDGERS
WHERE PS.APPLICATION_ID = 101
AND PS.LEDGER_ID = GL_LEDGERS.LEDGER_ID
AND MULT.MULTIPLIER IN ( 1
, 2 )
AND PERT.FROM_CURRENCY = GL_LEDGERS.CURRENCY_CODE
AND PERT.CONVERSION_DATE = PS.END_DATE
AND PERT.CONVERSION_TYPE = DECODE ( MULT.MULTIPLIER
, 1
, GL_LEDGERS.PERIOD_END_RATE_TYPE
, GL_LEDGERS.BUDGET_PERIOD_END_RATE_TYPE )
AND PART.FROM_CURRENCY = PERT.FROM_CURRENCY
AND PART.TO_CURRENCY = PERT.TO_CURRENCY
AND PERT.CONVERSION_DATE = PART.CONVERSION_DATE
AND PART.CONVERSION_TYPE = DECODE( MULT.MULTIPLIER
, 1
, GL_LEDGERS.PERIOD_AVERAGE_RATE_TYPE
, GL_LEDGERS.BUDGET_PERIOD_AVG_RATE_TYPE )
AND LK.LOOKUP_TYPE = 'TRANSLATION_BAL_TYPE'
AND LK.LOOKUP_CODE = DECODE ( MULT.MULTIPLIER
, 1
, 'A'
, 2
, 'B')
AND '_SEC:GL:GL_LEDGERS.LEDGER_ID'IS NOT NULL WITH READ ONLY

Columns

Name
LEDGER_ID
LEDGER_NAME
PERIOD_NAME
TO_CURRENCY
BALANCE_TYPE
PERIOD_AVERAGE_RATE
PERIOD_END_RATE