VIEW: APPS.GL_TRANSLATION_RATES

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)