[Home] [Help] [Dependency Information]
Object Name: | GL_REVAL_ACCOUNT_RANGES |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_REVAL_ACCOUNT_RANGES |
Subobject Name: | |
Status: | VALID |
GL_REVAL_ACCOUNT_RANGES stores the account ranges to be processed for a revaluation. Each row includes the revaluation id, the account range and two flags to indicate whether the balancing and natural account segments are parent values that should be expanded within the specified account range. Each account range stored in this table should be related to one and only one revaluation defined in GL_REVALUATIONS.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_REVEL_ACCOUNT_RANGES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REVALUATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REVALUATION_ID | NUMBER | (15) | Yes | Revaluation defining column |
EXPAND_BALANCING_FLAG | VARCHAR2 | (1) | Yes | Indicates if Revaluation should expand the parent value for the balancing segment within the specified account range |
EXPAND_NATURAL_ACCOUNT_FLAG | VARCHAR2 | (1) | Yes | Indicates if Revaluation should expand the parent value for the natural account segment within the specified account range |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | 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 | |
CONTEXT | VARCHAR2 | (150) | Descriptive flexfield context column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT REVALUATION_ID
, EXPAND_BALANCING_FLAG
, EXPAND_NATURAL_ACCOUNT_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, 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
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM GL.GL_REVAL_ACCOUNT_RANGES;
GL.GL_REVAL_ACCOUNT_RANGES does not reference any database object
GL.GL_REVAL_ACCOUNT_RANGES is referenced by following:
|
|
|