[Home] [Help] [Dependency Information]
Object Name: | GL_HISTORICAL_RATE_RANGES |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_HISTORICAL_RATE_RANGES |
Subobject Name: | |
Status: | VALID |
GL_HISTORICAL_RATE_RANGES stores the ranges of accounts for which you want to assign historical foreign currency translation rates. Each row contains the target currency, the period, the historical rate or amount, and the range of accounts for which the rate or amount is applicable.
When rows are saved into this table, the Assign Historical Rates program is automatically started by Oracle General Ledger. The Assign Historical Rates program creates rows with this target currency, period, and rate or amount in the GL_HISTORICAL_RATES table for each account in the range. It then deletes the rows from the GL_HISTORICAL_RATE_RANGES table. This table corresponds to the Assign by Ranges window of the Historical Rates form.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HISTORICAL_RANGE_ID | NUMBER | (15) | Yes | Historical rate range defining column |
LEDGER_ID | NUMBER | (15) | Yes | Ledger defining column |
TARGET_CURRENCY | VARCHAR2 | (15) | Yes | Translation target currency |
PERIOD_NAME | VARCHAR2 | (15) | Yes | Accounting period |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
TRANSLATED_RATE | NUMBER | Historical rate | ||
TRANSLATED_AMOUNT | NUMBER | Historical amount | ||
STATUS | VARCHAR2 | (1) | Status column used internally by Assign Historical Rates program | |
CREATION_DATE | DATE | Standard Who column | ||
CREATED_BY | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
SEGMENT1_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT1_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT2_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT2_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT3_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT3_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT4_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT4_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT5_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT5_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT6_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT6_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT7_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT7_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT8_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT8_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT9_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT9_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT10_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT10_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT11_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT11_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT12_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT12_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT13_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT13_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT14_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT14_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT15_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT15_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT16_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT16_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT17_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT17_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT18_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT18_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT19_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT19_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT20_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT20_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT21_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT21_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT22_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT22_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT23_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT23_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT24_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT24_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT25_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT25_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT26_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT26_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT27_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT27_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT28_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT28_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT29_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT29_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT30_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT30_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column |
Cut, paste (and edit) the following text to query this object:
SELECT HISTORICAL_RANGE_ID
, LEDGER_ID
, TARGET_CURRENCY
, PERIOD_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, TRANSLATED_RATE
, TRANSLATED_AMOUNT
, STATUS
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, SEGMENT1_LOW
, SEGMENT1_HIGH
, SEGMENT2_LOW
, SEGMENT2_HIGH
, SEGMENT3_LOW
, SEGMENT3_HIGH
, SEGMENT4_LOW
, SEGMENT4_HIGH
, SEGMENT5_LOW
, SEGMENT5_HIGH
, SEGMENT6_LOW
, SEGMENT6_HIGH
, SEGMENT7_LOW
, SEGMENT7_HIGH
, SEGMENT8_LOW
, SEGMENT8_HIGH
, SEGMENT9_LOW
, SEGMENT9_HIGH
, SEGMENT10_LOW
, SEGMENT10_HIGH
, SEGMENT11_LOW
, SEGMENT11_HIGH
, SEGMENT12_LOW
, SEGMENT12_HIGH
, SEGMENT13_LOW
, SEGMENT13_HIGH
, SEGMENT14_LOW
, SEGMENT14_HIGH
, SEGMENT15_LOW
, SEGMENT15_HIGH
, SEGMENT16_LOW
, SEGMENT16_HIGH
, SEGMENT17_LOW
, SEGMENT17_HIGH
, SEGMENT18_LOW
, SEGMENT18_HIGH
, SEGMENT19_LOW
, SEGMENT19_HIGH
, SEGMENT20_LOW
, SEGMENT20_HIGH
, SEGMENT21_LOW
, SEGMENT21_HIGH
, SEGMENT22_LOW
, SEGMENT22_HIGH
, SEGMENT23_LOW
, SEGMENT23_HIGH
, SEGMENT24_LOW
, SEGMENT24_HIGH
, SEGMENT25_LOW
, SEGMENT25_HIGH
, SEGMENT26_LOW
, SEGMENT26_HIGH
, SEGMENT27_LOW
, SEGMENT27_HIGH
, SEGMENT28_LOW
, SEGMENT28_HIGH
, SEGMENT29_LOW
, SEGMENT29_HIGH
, SEGMENT30_LOW
, SEGMENT30_HIGH
FROM GL.GL_HISTORICAL_RATE_RANGES;
GL.GL_HISTORICAL_RATE_RANGES does not reference any database object
GL.GL_HISTORICAL_RATE_RANGES is referenced by following:
|
|
|