Product: | GL - General Ledger |
---|---|
Description: | 10SC ONLY |
Implementation/DBA Data: | APPS.GL_HISTORICAL_RATES_V |
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