Product: | GL - General Ledger |
---|---|
Description: | |
Implementation/DBA Data: | APPS.GL_TRANSLATION_RATES |
SELECT LGR.LEDGER_ID SET_OF_BOOKS_ID
, PS.PERIOD_NAME PERIOD_NAME
, PERT.TO_CURRENCY TO_CURRENCY_CODE
, DECODE(MULT.MULTIPLIER
, 1
, 'A'
, 2
, 'B') ACTUAL_FLAG
, PART.CONVERSION_RATE AVG_RATE
, PERT.CONVERSION_RATE EOP_RATE
, PART.CONVERSION_RATE AVG_RATE_NUMERATOR
, PERT.CONVERSION_RATE EOP_RATE_NUMERATOR
, 1 AVG_RATE_DENOMINATOR
, 1 EOP_RATE_DENOMINATOR
, DECODE(NULL
, 'X'
, SUSPENSE_ALLOWED_FLAG
, 'N') UPDATE_FLAG
, NULL LAST_UPDATE_DATE
, NULL LAST_UPDATED_BY
, NULL CREATION_DATE
, NULL CREATED_BY
, NULL LAST_UPDATE_LOGIN
, NULL ATTRIBUTE1
, NULL ATTRIBUTE2
, NULL ATTRIBUTE3
, NULL ATTRIBUTE4
, NULL ATTRIBUTE5
, NULL CONTEXT
FROM GL_LEDGERS LGR
, GL_PERIOD_STATUSES PS
, GL_ROW_MULTIPLIERS MULT
, GL_DAILY_RATES PERT
, GL_DAILY_RATES PART
WHERE PS.APPLICATION_ID = 101
AND PS.LEDGER_ID = LGR.LEDGER_ID
AND MULT.MULTIPLIER IN (1
, 2)
AND PERT.FROM_CURRENCY = LGR.CURRENCY_CODE
AND PERT.CONVERSION_DATE = PS.END_DATE
AND PERT.CONVERSION_TYPE = DECODE(MULT.MULTIPLIER
, 1
, LGR.PERIOD_END_RATE_TYPE
, LGR.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
, LGR.PERIOD_AVERAGE_RATE_TYPE
, LGR.BUDGET_PERIOD_AVG_RATE_TYPE)