VIEW: APPS.GL_HISTORICAL_RATES_V

Source

View Text - Preformatted

SELECT hist.ROWID ROW_ID, hist.LEDGER_ID LEDGER_ID, hist.PERIOD_NAME PERIOD_NAME, hist.PERIOD_NUM PERIOD_NUM, hist.PERIOD_YEAR PERIOD_YEAR, hist.CODE_COMBINATION_ID CODE_COMBINATION_ID, hist.TARGET_CURRENCY TARGET_CURRENCY, hist.UPDATE_FLAG UPDATE_FLAG, hist.LAST_UPDATE_DATE LAST_UPDATE_DATE, hist.LAST_UPDATED_BY LAST_UPDATED_BY, hist.CREATION_DATE CREATION_DATE, hist.CREATED_BY CREATED_BY, hist.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, hist.RATE_TYPE RATE_TYPE, lk.SHOW_RATE_TYPE SHOW_RATE_TYPE, hist.TRANSLATED_RATE TRANSLATED_RATE, hist.TRANSLATED_AMOUNT TRANSLATED_AMOUNT, hist.ACCOUNT_TYPE ACCOUNT_TYPE, hist.ATTRIBUTE1 ATTRIBUTE1, hist.ATTRIBUTE2 ATTRIBUTE2, hist.ATTRIBUTE3 ATTRIBUTE3, hist.ATTRIBUTE4 ATTRIBUTE4, hist.ATTRIBUTE5 ATTRIBUTE5, hist.CONTEXT CONTEXT, hist.USAGE_CODE USAGE_CODE, cc.SEGMENT1 SEGMENT1, cc.SEGMENT2 SEGMENT2, cc.SEGMENT3 SEGMENT3, cc.SEGMENT4 SEGMENT4, cc.SEGMENT5 SEGMENT5, cc.SEGMENT6 SEGMENT6, cc.SEGMENT7 SEGMENT7, cc.SEGMENT8 SEGMENT8, cc.SEGMENT9 SEGMENT9, cc.SEGMENT10 SEGMENT10, cc.SEGMENT11 SEGMENT11, cc.SEGMENT12 SEGMENT12, cc.SEGMENT13 SEGMENT13, cc.SEGMENT14 SEGMENT14, cc.SEGMENT15 SEGMENT15, cc.SEGMENT16 SEGMENT16, cc.SEGMENT17 SEGMENT17, cc.SEGMENT18 SEGMENT18, cc.SEGMENT19 SEGMENT19, cc.SEGMENT20 SEGMENT20, cc.SEGMENT21 SEGMENT21, cc.SEGMENT22 SEGMENT22, cc.SEGMENT23 SEGMENT23, cc.SEGMENT24 SEGMENT24, cc.SEGMENT25 SEGMENT25, cc.SEGMENT26 SEGMENT26, cc.SEGMENT27 SEGMENT27, cc.SEGMENT28 SEGMENT28, cc.SEGMENT29 SEGMENT29, cc.SEGMENT30 SEGMENT30 FROM gl_lookups_rate_type_v lk, gl_historical_rates hist, gl_code_combinations cc WHERE hist.RATE_TYPE = lk.RATE_TYPE(+) AND hist.code_combination_id = cc.code_combination_id

View Text - HTML Formatted

SELECT HIST.ROWID ROW_ID
, HIST.LEDGER_ID LEDGER_ID
, HIST.PERIOD_NAME PERIOD_NAME
, HIST.PERIOD_NUM PERIOD_NUM
, HIST.PERIOD_YEAR PERIOD_YEAR
, HIST.CODE_COMBINATION_ID CODE_COMBINATION_ID
, HIST.TARGET_CURRENCY TARGET_CURRENCY
, HIST.UPDATE_FLAG UPDATE_FLAG
, HIST.LAST_UPDATE_DATE LAST_UPDATE_DATE
, HIST.LAST_UPDATED_BY LAST_UPDATED_BY
, HIST.CREATION_DATE CREATION_DATE
, HIST.CREATED_BY CREATED_BY
, HIST.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, HIST.RATE_TYPE RATE_TYPE
, LK.SHOW_RATE_TYPE SHOW_RATE_TYPE
, HIST.TRANSLATED_RATE TRANSLATED_RATE
, HIST.TRANSLATED_AMOUNT TRANSLATED_AMOUNT
, HIST.ACCOUNT_TYPE ACCOUNT_TYPE
, HIST.ATTRIBUTE1 ATTRIBUTE1
, HIST.ATTRIBUTE2 ATTRIBUTE2
, HIST.ATTRIBUTE3 ATTRIBUTE3
, HIST.ATTRIBUTE4 ATTRIBUTE4
, HIST.ATTRIBUTE5 ATTRIBUTE5
, HIST.CONTEXT CONTEXT
, HIST.USAGE_CODE USAGE_CODE
, CC.SEGMENT1 SEGMENT1
, CC.SEGMENT2 SEGMENT2
, CC.SEGMENT3 SEGMENT3
, CC.SEGMENT4 SEGMENT4
, CC.SEGMENT5 SEGMENT5
, CC.SEGMENT6 SEGMENT6
, CC.SEGMENT7 SEGMENT7
, CC.SEGMENT8 SEGMENT8
, CC.SEGMENT9 SEGMENT9
, CC.SEGMENT10 SEGMENT10
, CC.SEGMENT11 SEGMENT11
, CC.SEGMENT12 SEGMENT12
, CC.SEGMENT13 SEGMENT13
, CC.SEGMENT14 SEGMENT14
, CC.SEGMENT15 SEGMENT15
, CC.SEGMENT16 SEGMENT16
, CC.SEGMENT17 SEGMENT17
, CC.SEGMENT18 SEGMENT18
, CC.SEGMENT19 SEGMENT19
, CC.SEGMENT20 SEGMENT20
, CC.SEGMENT21 SEGMENT21
, CC.SEGMENT22 SEGMENT22
, CC.SEGMENT23 SEGMENT23
, CC.SEGMENT24 SEGMENT24
, CC.SEGMENT25 SEGMENT25
, CC.SEGMENT26 SEGMENT26
, CC.SEGMENT27 SEGMENT27
, CC.SEGMENT28 SEGMENT28
, CC.SEGMENT29 SEGMENT29
, CC.SEGMENT30 SEGMENT30
FROM GL_LOOKUPS_RATE_TYPE_V LK
, GL_HISTORICAL_RATES HIST
, GL_CODE_COMBINATIONS CC
WHERE HIST.RATE_TYPE = LK.RATE_TYPE(+)
AND HIST.CODE_COMBINATION_ID = CC.CODE_COMBINATION_ID