GL_TRANSLATION_RATES

Details

• Schema: FUSION

• Object owner: GL

• Object type: VIEW

Columns

Name
SET_OF_BOOKS_ID PERIOD_NAME TO_CURRENCY_CODE ACTUAL_FLAG AVG_RATE EOP_RATE AVG_RATE_NUMERATOR EOP_RATE_NUMERATOR AVG_RATE_DENOMINATOR EOP_RATE_DENOMINATOR UPDATE_FLAG LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE_CATEGORY

Query

SQL_Statement

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 ATTRIBUTE_CATEGORY 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)