DBA Data[Home] [Help] [Dependency Information]

TABLE: IGI.IGI_ITR_CHARGE_RANGES

Object Details
Object Name: IGI_ITR_CHARGE_RANGES
Object Type: TABLE
Owner: IGI
FND Design Data: TableIGI.IGI_ITR_CHARGE_RANGES
Subobject Name:
Status: VALID


IGI_ITR_CHARGE_RANGES stores the Accounting Flexfield ranges defined by the user and corresponds to the Account Ranges region in the Define Internal Trading Charge Centers window.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGI_ITR_CHARGE_RANGES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHARGE_RANGE_ID
Columns
Name Datatype Length Mandatory Comments
CHARGE_RANGE_ID NUMBER (15) Yes Charge range identifier
CHARGE_CENTER_ID NUMBER (15) Yes Charge center identifier
SEGMENT1_LOW VARCHAR2 (30)
Segment Value 1 - Low
SEGMENT1_HIGH VARCHAR2 (30)
Segment Value 1 - High
SEGMENT2_LOW VARCHAR2 (30)
Segment Value 2 - Low
SEGMENT2_HIGH VARCHAR2 (30)
Segment Value 2 - High
SEGMENT3_LOW VARCHAR2 (30)
Segment Value 3 - Low
SEGMENT3_HIGH VARCHAR2 (30)
Segment Value 3 - High
SEGMENT4_LOW VARCHAR2 (30)
Segment Value 4 - Low
SEGMENT4_HIGH VARCHAR2 (30)
Segment Value 4 - High
SEGMENT5_LOW VARCHAR2 (30)
Segment Value 5 - Low
SEGMENT5_HIGH VARCHAR2 (30)
Segment Value 5 - High
SEGMENT6_LOW VARCHAR2 (30)
Segment Value 6 - Low
SEGMENT6_HIGH VARCHAR2 (30)
Segment Value 6 - High
SEGMENT7_LOW VARCHAR2 (30)
Segment Value 7 - Low
SEGMENT7_HIGH VARCHAR2 (30)
Segment Value 7 - High
SEGMENT8_LOW VARCHAR2 (30)
Segment Value 8 - Low
SEGMENT8_HIGH VARCHAR2 (30)
Segment Value 8 - High
SEGMENT9_LOW VARCHAR2 (30)
Segment Value 9 - Low
SEGMENT9_HIGH VARCHAR2 (30)
Segment Value 9 - High
SEGMENT10_LOW VARCHAR2 (30)
Segment Value 10 - Low
SEGMENT10_HIGH VARCHAR2 (30)
Segment Value 10 - High
SEGMENT11_LOW VARCHAR2 (30)
Segment Value 11 - Low
SEGMENT11_HIGH VARCHAR2 (30)
Segment Value 11 - High
SEGMENT12_LOW VARCHAR2 (30)
Segment Value 12 - Low
SEGMENT12_HIGH VARCHAR2 (30)
Segment Value 12 - High
SEGMENT13_LOW VARCHAR2 (30)
Segment Value 13 - Low
SEGMENT13_HIGH VARCHAR2 (30)
Segment Value 13 - High
SEGMENT14_LOW VARCHAR2 (30)
Segment Value 14 - Low
SEGMENT14_HIGH VARCHAR2 (30)
Segment Value 14 - High
SEGMENT15_LOW VARCHAR2 (30)
Segment Value 15 - Low
SEGMENT15_HIGH VARCHAR2 (30)
Segment Value 15 - High
SEGMENT16_LOW VARCHAR2 (30)
Segment Value 16 - Low
SEGMENT16_HIGH VARCHAR2 (30)
Segment Value 16 - High
SEGMENT17_LOW VARCHAR2 (30)
Segment Value 17 - Low
SEGMENT17_HIGH VARCHAR2 (30)
Segment Value 17 - High
SEGMENT18_LOW VARCHAR2 (30)
Segment Value 18 - Low
SEGMENT18_HIGH VARCHAR2 (30)
Segment Value 18 - High
SEGMENT19_LOW VARCHAR2 (30)
Segment Value 19 - Low
SEGMENT19_HIGH VARCHAR2 (30)
Segment Value 19 - High
SEGMENT20_LOW VARCHAR2 (30)
Segment Value 20 - Low
SEGMENT20_HIGH VARCHAR2 (30)
Segment Value 20 - High
SEGMENT21_LOW VARCHAR2 (30)
Segment Value 21 - Low
SEGMENT21_HIGH VARCHAR2 (30)
Segment Value 21 - High
SEGMENT22_LOW VARCHAR2 (30)
Segment Value 22 - Low
SEGMENT22_HIGH VARCHAR2 (30)
Segment Value 22 - High
SEGMENT23_LOW VARCHAR2 (30)
Segment Value 23 - Low
SEGMENT23_HIGH VARCHAR2 (30)
Segment Value 23 - High
SEGMENT24_LOW VARCHAR2 (30)
Segment Value 24 - Low
SEGMENT24_HIGH VARCHAR2 (30)
Segment Value 24 - High
SEGMENT25_LOW VARCHAR2 (30)
Segment Value 25 - Low
SEGMENT25_HIGH VARCHAR2 (30)
Segment Value 25 - High
SEGMENT26_LOW VARCHAR2 (30)
Segment Value 26 - Low
SEGMENT26_HIGH VARCHAR2 (30)
Segment Value 26 - High
SEGMENT27_LOW VARCHAR2 (30)
Segment Value 27 - Low
SEGMENT27_HIGH VARCHAR2 (30)
Segment Value 27 - High
SEGMENT28_LOW VARCHAR2 (30)
Segment Value 28 - Low
SEGMENT28_HIGH VARCHAR2 (30)
Segment Value 28 - High
SEGMENT29_LOW VARCHAR2 (30)
Segment Value 29 - Low
SEGMENT29_HIGH VARCHAR2 (30)
Segment Value 29 - High
SEGMENT30_LOW VARCHAR2 (30)
Segment Value 30 - Low
SEGMENT30_HIGH VARCHAR2 (30)
Segment Value 30 - High
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
AUTHORISER_ID NUMBER (15)
Authoriser Identifier
EMPLOYEE_ID NUMBER (15)
Employee Identifier
ACTIVE_FLAG VARCHAR2 (1)
Y / N
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CHARGE_RANGE_ID
,      CHARGE_CENTER_ID
,      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
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      AUTHORISER_ID
,      EMPLOYEE_ID
,      ACTIVE_FLAG
FROM IGI.IGI_ITR_CHARGE_RANGES;

Dependencies

[top of page]

IGI.IGI_ITR_CHARGE_RANGES does not reference any database object

IGI.IGI_ITR_CHARGE_RANGES is referenced by following:

SchemaAPPS
SynonymIGI_ITR_CHARGE_RANGES