[Home] [Help] [Dependency Information]
Object Name: | XLA_TB_DEF_SEG_RANGES |
---|---|
Object Type: | TABLE |
Owner: | XLA |
FND Design Data: | XLA.XLA_TB_DEF_SEG_RANGES |
Subobject Name: | |
Status: | VALID |
This tables stores segment ranges generated based on Open Account Balances Listing report definition details. When the report definition is definied by Flexfield, the SEGMENT
columns stores to segment values of given accounts. In this case, SEGMENT
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XLA_TB_DEF_SEG_RANGES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
DEFINITION_CODE
LINE_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEFINITION_CODE | VARCHAR2 | (30) | Yes | Definition code for the Open Account Balances Listing definition |
LINE_NUM | NUMBER | (15) | Yes | Line number |
SEGMENT1_FROM | VARCHAR2 | (25) | Low value of the SEGMENT1 column | |
SEGMENT1_TO | VARCHAR2 | (25) | High value of the SEGMENT1 column | |
SEGMENT2_FROM | VARCHAR2 | (25) | Low value of the SEGMENT2 column | |
SEGMENT2_TO | VARCHAR2 | (25) | High value of the SEGMENT2 column | |
SEGMENT3_FROM | VARCHAR2 | (25) | Low value of the SEGMENT3 column | |
SEGMENT3_TO | VARCHAR2 | (25) | High value of the SEGMENT3 column | |
SEGMENT4_FROM | VARCHAR2 | (25) | Low value of the SEGMENT4 column | |
SEGMENT4_TO | VARCHAR2 | (25) | High value of the SEGMENT4 column | |
SEGMENT5_FROM | VARCHAR2 | (25) | Low value of the SEGMENT5 column | |
SEGMENT5_TO | VARCHAR2 | (25) | High value of the SEGMENT5 column | |
SEGMENT6_FROM | VARCHAR2 | (25) | Low value of the SEGMENT6 column | |
SEGMENT6_TO | VARCHAR2 | (25) | High value of the SEGMENT6 column | |
SEGMENT7_FROM | VARCHAR2 | (25) | Low value of the SEGMENT7 column | |
SEGMENT7_TO | VARCHAR2 | (25) | High value of the SEGMENT7 column | |
SEGMENT8_FROM | VARCHAR2 | (25) | Low value of the SEGMENT8 column | |
SEGMENT8_TO | VARCHAR2 | (25) | High value of the SEGMENT8 column | |
SEGMENT9_FROM | VARCHAR2 | (25) | Low value of the SEGMENT9 column | |
SEGMENT9_TO | VARCHAR2 | (25) | High value of the SEGMENT9 column | |
SEGMENT10_FROM | VARCHAR2 | (25) | Low value of the SEGMENT10 column | |
SEGMENT10_TO | VARCHAR2 | (25) | High value of the SEGMENT10 column | |
SEGMENT11_FROM | VARCHAR2 | (25) | Low value of the SEGMENT11 column | |
SEGMENT11_TO | VARCHAR2 | (25) | High value of the SEGMENT11 column | |
SEGMENT12_FROM | VARCHAR2 | (25) | Low value of the SEGMENT12 column | |
SEGMENT12_TO | VARCHAR2 | (25) | High value of the SEGMENT12 column | |
SEGMENT13_FROM | VARCHAR2 | (25) | Low value of the SEGMENT13 column | |
SEGMENT13_TO | VARCHAR2 | (25) | High value of the SEGMENT13 column | |
SEGMENT14_FROM | VARCHAR2 | (25) | Low value of the SEGMENT14 column | |
SEGMENT14_TO | VARCHAR2 | (25) | High value of the SEGMENT14 column | |
SEGMENT15_FROM | VARCHAR2 | (25) | Low value of the SEGMENT15 column | |
SEGMENT15_TO | VARCHAR2 | (25) | High value of the SEGMENT15 column | |
SEGMENT16_FROM | VARCHAR2 | (25) | Low value of the SEGMENT16 column | |
SEGMENT16_TO | VARCHAR2 | (25) | High value of the SEGMENT16 column | |
SEGMENT17_FROM | VARCHAR2 | (25) | Low value of the SEGMENT17 column | |
SEGMENT17_TO | VARCHAR2 | (25) | High value of the SEGMENT17 column | |
SEGMENT18_FROM | VARCHAR2 | (25) | Low value of the SEGMENT18 column | |
SEGMENT18_TO | VARCHAR2 | (25) | High value of the SEGMENT18 column | |
SEGMENT19_FROM | VARCHAR2 | (25) | Low value of the SEGMENT19 column | |
SEGMENT19_TO | VARCHAR2 | (25) | High value of the SEGMENT19 column | |
SEGMENT20_FROM | VARCHAR2 | (25) | Low value of the SEGMENT20 column | |
SEGMENT20_TO | VARCHAR2 | (25) | High value of the SEGMENT20 column | |
SEGMENT21_FROM | VARCHAR2 | (25) | Low value of the SEGMENT21 column | |
SEGMENT21_TO | VARCHAR2 | (25) | High value of the SEGMENT21 column | |
SEGMENT22_FROM | VARCHAR2 | (25) | Low value of the SEGMENT22 column | |
SEGMENT22_TO | VARCHAR2 | (25) | High value of the SEGMENT22 column | |
SEGMENT23_FROM | VARCHAR2 | (25) | Low value of the SEGMENT23 column | |
SEGMENT23_TO | VARCHAR2 | (25) | High value of the SEGMENT23 column | |
SEGMENT24_FROM | VARCHAR2 | (25) | Low value of the SEGMENT24 column | |
SEGMENT24_TO | VARCHAR2 | (25) | High value of the SEGMENT24 column | |
SEGMENT25_FROM | VARCHAR2 | (25) | Low value of the SEGMENT25 column | |
SEGMENT25_TO | VARCHAR2 | (25) | High value of the SEGMENT25 column | |
SEGMENT26_FROM | VARCHAR2 | (25) | Low value of the SEGMENT26 column | |
SEGMENT26_TO | VARCHAR2 | (25) | High value of the SEGMENT26 column | |
SEGMENT27_FROM | VARCHAR2 | (25) | Low value of the SEGMENT27 column | |
SEGMENT27_TO | VARCHAR2 | (25) | High value of the SEGMENT27 column | |
SEGMENT28_FROM | VARCHAR2 | (25) | Low value of the SEGMENT28 column | |
SEGMENT28_TO | VARCHAR2 | (25) | High value of the SEGMENT28 column | |
SEGMENT29_FROM | VARCHAR2 | (25) | Low value of the SEGMENT29 column | |
SEGMENT29_TO | VARCHAR2 | (25) | High value of the SEGMENT29 column | |
SEGMENT30_FROM | VARCHAR2 | (25) | Low value of the SEGMENT30 column | |
SEGMENT30_TO | VARCHAR2 | (25) | High value of the SEGMENT30 column | |
BALANCE_DATE | DATE | The date the initial balance is effective | ||
OWNER_CODE | VARCHAR2 | (30) | Identifies the owner of the report detail row for the purpose of preventing removal of that row from the definition. |
Cut, paste (and edit) the following text to query this object:
SELECT DEFINITION_CODE
, LINE_NUM
, SEGMENT1_FROM
, SEGMENT1_TO
, SEGMENT2_FROM
, SEGMENT2_TO
, SEGMENT3_FROM
, SEGMENT3_TO
, SEGMENT4_FROM
, SEGMENT4_TO
, SEGMENT5_FROM
, SEGMENT5_TO
, SEGMENT6_FROM
, SEGMENT6_TO
, SEGMENT7_FROM
, SEGMENT7_TO
, SEGMENT8_FROM
, SEGMENT8_TO
, SEGMENT9_FROM
, SEGMENT9_TO
, SEGMENT10_FROM
, SEGMENT10_TO
, SEGMENT11_FROM
, SEGMENT11_TO
, SEGMENT12_FROM
, SEGMENT12_TO
, SEGMENT13_FROM
, SEGMENT13_TO
, SEGMENT14_FROM
, SEGMENT14_TO
, SEGMENT15_FROM
, SEGMENT15_TO
, SEGMENT16_FROM
, SEGMENT16_TO
, SEGMENT17_FROM
, SEGMENT17_TO
, SEGMENT18_FROM
, SEGMENT18_TO
, SEGMENT19_FROM
, SEGMENT19_TO
, SEGMENT20_FROM
, SEGMENT20_TO
, SEGMENT21_FROM
, SEGMENT21_TO
, SEGMENT22_FROM
, SEGMENT22_TO
, SEGMENT23_FROM
, SEGMENT23_TO
, SEGMENT24_FROM
, SEGMENT24_TO
, SEGMENT25_FROM
, SEGMENT25_TO
, SEGMENT26_FROM
, SEGMENT26_TO
, SEGMENT27_FROM
, SEGMENT27_TO
, SEGMENT28_FROM
, SEGMENT28_TO
, SEGMENT29_FROM
, SEGMENT29_TO
, SEGMENT30_FROM
, SEGMENT30_TO
, BALANCE_DATE
, OWNER_CODE
FROM XLA.XLA_TB_DEF_SEG_RANGES;
XLA.XLA_TB_DEF_SEG_RANGES does not reference any database object
XLA.XLA_TB_DEF_SEG_RANGES is referenced by following:
|
|
|