Product: | IGI - Public Sector Financials International |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGI_ITR_CHARGE_ORIG_SS_V |
SELECT ORIG.ROWID ROW_ID
, ORIG.CHARGE_CENTER_ID CHARGE_CENTER_ID
, ORIG.CHARGE_ORIG_ID CHARGE_ORIG_ID
, ORIG.ORIGINATOR_ID ORIGINATOR_ID
, ORIG.APPLICATION_ID APPLICATION_ID
, ORIG.ID_FLEX_CODE ID_FLEX_CODE
, ORIG.ID_FLEX_NUM ID_FLEX_NUM
, ORIG.CONCATENATED_SEGMENTS CONCATENATED_SEGMENTS
, ORIG.EMPLOYEE_ID EMPLOYEE_ID
, ORIG.START_DATE START_DATE
, ORIG.END_DATE END_DATE
, ORIG.CODE_COMBINATION_ID CODE_COMBINATION_ID
, FND.USER_NAME PERSON_NAME_DSP
, ORIG.SEGMENT1 SEGMENT1
, ORIG.SEGMENT2 SEGMENT2
, ORIG.SEGMENT3 SEGMENT3
, ORIG.SEGMENT4 SEGMENT4
, ORIG.SEGMENT5 SEGMENT5
, ORIG.SEGMENT6 SEGMENT6
, ORIG.SEGMENT7 SEGMENT
, ORIG.SEGMENT8 SEGMENT8
, ORIG.SEGMENT9 SEGMENT9
, ORIG.SEGMENT10 SEGMENT10
, ORIG.SEGMENT11 SEGMENT11
, ORIG.SEGMENT12 SEGMENT12
, ORIG.SEGMENT13 SEGMENT13
, ORIG.SEGMENT14 SEGMENT14
, ORIG.SEGMENT15 SEGMENT15
, ORIG.SEGMENT16 SEGMENT16
, ORIG.SEGMENT17 SEGMENT17
, ORIG.SEGMENT18 SEGMENT18
, ORIG.SEGMENT19 SEGMENT19
, ORIG.SEGMENT20 SEGMENT20
, ORIG.SEGMENT21 SEGMENT21
, ORIG.SEGMENT22 SEGMENT22
, ORIG.SEGMENT23 SEGMENT23
, ORIG.SEGMENT24 SEGMENT24
, ORIG.SEGMENT25 SEGMENT25
, ORIG.SEGMENT26 SEGMENT26
, ORIG.SEGMENT27 SEGMENT27
, ORIG.SEGMENT28 SEGMENT28
, ORIG.SEGMENT29 SEGMENT29
, ORIG.SEGMENT30 SEGMENT30
, ORIG.CREATION_DATE CREATION_DATE
, ORIG.CREATED_BY CREATED_BY
, ORIG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ORIG.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ORIG.LAST_UPDATED_BY LAST_UPDATED_BY
FROM IGI_ITR_CHARGE_CENTER CC
, IGI_ITR_CHARGE_ORIG ORIG
, FND_USER FND
WHERE ORIG.ORIGINATOR_ID =FND.USER_ID
AND ORIG.CHARGE_CENTER_ID = CC.CHARGE_CENTER_ID