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

TABLE: IGI.IGI_ITR_CHARGE_ORIG

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


IGI_ITR_CHARGE_ORIG stores the Originator information for a charge center


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CHARGE_CENTER_ID NUMBER (15) Yes Charge Center Identifier
ORIGINATOR_ID NUMBER (15) Yes Originator Identifier
CHARGE_ORIG_ID NUMBER (10) Yes Charge Originator Identifier
APPLICATION_ID NUMBER (10)
Application Identifier
ID_FLEX_CODE VARCHAR2 (4)
Flex Structure Identifier
ID_FLEX_NUM NUMBER (15)
Flex Structure Identifier
CONCATENATED_SEGMENTS VARCHAR2 (2000)
Concatenated Segment Values
EMPLOYEE_ID NUMBER

Employee Identifier
START_DATE DATE

Start Date
END_DATE DATE

End Date
CODE_COMBINATION_ID NUMBER

Code Combination Identifier
SEGMENT1 VARCHAR2 (30)
Key flexfield segment
SEGMENT2 VARCHAR2 (30)
Key flexfield segment
SEGMENT3 VARCHAR2 (30)
Key flexfield segment
SEGMENT4 VARCHAR2 (30)
Key flexfield segment
SEGMENT5 VARCHAR2 (30)
Key flexfield segment
SEGMENT6 VARCHAR2 (30)
Key flexfield segment
SEGMENT7 VARCHAR2 (30)
Key flexfield segment
SEGMENT8 VARCHAR2 (30)
Key flexfield segment
SEGMENT9 VARCHAR2 (30)
Key flexfield segment
SEGMENT10 VARCHAR2 (30)
Key flexfield segment
SEGMENT11 VARCHAR2 (30)
Key flexfield segment
SEGMENT12 VARCHAR2 (30)
Key flexfield segment
SEGMENT13 VARCHAR2 (30)
Key flexfield segment
SEGMENT14 VARCHAR2 (30)
Key flexfield segment
SEGMENT15 VARCHAR2 (30)
Key flexfield segment
SEGMENT16 VARCHAR2 (30)
Key flexfield segment
SEGMENT17 VARCHAR2 (30)
Key flexfield segment
SEGMENT18 VARCHAR2 (30)
Key flexfield segment
SEGMENT19 VARCHAR2 (30)
Key flexfield segment
SEGMENT20 VARCHAR2 (30)
Key flexfield segment
SEGMENT21 VARCHAR2 (30)
Segment Value
SEGMENT22 VARCHAR2 (30)
Segment Value
SEGMENT23 VARCHAR2 (30)
Segment Value
SEGMENT24 VARCHAR2 (30)
Segment Value
SEGMENT25 VARCHAR2 (30)
Segment Value
SEGMENT26 VARCHAR2 (30)
Segment Value
SEGMENT27 VARCHAR2 (30)
Segment Value
SEGMENT28 VARCHAR2 (30)
Segment Value
SEGMENT29 VARCHAR2 (30)
Segment Value
SEGMENT30 VARCHAR2 (30)
Segment Value
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created 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).
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).
Query Text

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


SELECT CHARGE_CENTER_ID
,      ORIGINATOR_ID
,      CHARGE_ORIG_ID
,      APPLICATION_ID
,      ID_FLEX_CODE
,      ID_FLEX_NUM
,      CONCATENATED_SEGMENTS
,      EMPLOYEE_ID
,      START_DATE
,      END_DATE
,      CODE_COMBINATION_ID
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM IGI.IGI_ITR_CHARGE_ORIG;

Dependencies

[top of page]

IGI.IGI_ITR_CHARGE_ORIG does not reference any database object

IGI.IGI_ITR_CHARGE_ORIG is referenced by following:

SchemaIGI
ViewIGI_ITR_CHARGE_ORIG#