eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGI_ITR_CHARGE_RANGE_AUTH_SS_V

Product:	IGI - Public Sector Financials International
Description:
Implementation/DBA Data:	APPS.IGI_ITR_CHARGE_RANGE_AUTH_SS_V

View Text

SELECT A.ROWID ROW_ID
, A.CHARGE_CENTER_ID CHARGE_CENTER_ID
, A.CHARGE_RANGE_ID CHARGE_RANGE_ID
, A.AUTHORISER_ID AUTHORISER_ID
, A.EMPLOYEE_ID EMPLOYEE_ID
, A.ACTIVE_FLAG ACTIVE_FLAG
, F.USER_NAME PERSON_NAME_DSP
, A.SEGMENT1_LOW SEGMENT1_LOW
, A.SEGMENT2_LOW SEGMENT2_LOW
, A.SEGMENT3_LOW SEGMENT3_LOW
, A.SEGMENT4_LOW SEGMENT4_LOW
, A.SEGMENT5_LOW SEGMENT5_LOW
, A.SEGMENT6_LOW SEGMENT6_LOW
, A.SEGMENT7_LOW SEGMENT7_LOW
, A.SEGMENT8_LOW SEGMENT8_LOW
, A.SEGMENT9_LOW SEGMENT9_LOW
, A.SEGMENT10_LOW SEGMENT10_LOW
, A.SEGMENT11_LOW SEGMENT11_LOW
, A.SEGMENT12_LOW SEGMENT12_LOW
, A.SEGMENT13_LOW SEGMENT13_LOW
, A.SEGMENT14_LOW SEGMENT14_LOW
, A.SEGMENT15_LOW SEGMENT15_LOW
, A.SEGMENT16_LOW SEGMENT16_LOW
, A.SEGMENT17_LOW SEGMENT17_LOW
, A.SEGMENT18_LOW SEGMENT18_LOW
, A.SEGMENT19_LOW SEGMENT19_LOW
, A.SEGMENT20_LOW SEGMENT20_LOW
, A.SEGMENT21_LOW SEGMENT21_LOW
, A.SEGMENT22_LOW SEGMENT22_LOW
, A.SEGMENT23_LOW SEGMENT23_LOW
, A.SEGMENT24_LOW SEGMENT24_LOW
, A.SEGMENT25_LOW SEGMENT25_LOW
, A.SEGMENT26_LOW SEGMENT26_LOW
, A.SEGMENT27_LOW SEGMENT27_LOW
, A.SEGMENT28_LOW SEGMENT28_LOW
, A.SEGMENT29_LOW SEGMENT29_LOW
, A.SEGMENT30_LOW SEGMENT30_LOW
, A.SEGMENT1_HIGH SEGMENT1_HIGH
, A.SEGMENT2_HIGH SEGMENT2_HIGH
, A.SEGMENT3_HIGH SEGMENT3_HIGH
, A.SEGMENT4_HIGH SEGMENT4_HIGH
, A.SEGMENT5_HIGH SEGMENT5_HIGH
, A.SEGMENT6_HIGH SEGMENT6_HIGH
, A.SEGMENT7_HIGH SEGMENT7_HIGH
, A.SEGMENT8_HIGH SEGMENT8_HIGH
, A.SEGMENT9_HIGH SEGMENT9_HIGH
, A.SEGMENT10_HIGH SEGMENT10_HIGH
, A.SEGMENT11_HIGH SEGMENT11_HIGH
, A.SEGMENT12_HIGH SEGMENT12_HIGH
, A.SEGMENT13_HIGH SEGMENT13_HIGH
, A.SEGMENT14_HIGH SEGMENT14_HIGH
, A.SEGMENT15_HIGH SEGMENT15_HIGH
, A.SEGMENT16_HIGH SEGMENT16_HIGH
, A.SEGMENT17_HIGH SEGMENT17_HIGH
, A.SEGMENT18_HIGH SEGMENT18_HIGH
, A.SEGMENT19_HIGH SEGMENT19_HIGH
, A.SEGMENT20_HIGH SEGMENT20_HIGH
, A.SEGMENT21_HIGH SEGMENT21_HIGH
, A.SEGMENT22_HIGH SEGMENT22_HIGH
, A.SEGMENT23_HIGH SEGMENT23_HIGH
, A.SEGMENT24_HIGH SEGMENT24_HIGH
, A.SEGMENT25_HIGH SEGMENT25_HIGH
, A.SEGMENT26_HIGH SEGMENT26_HIGH
, A.SEGMENT27_HIGH SEGMENT27_HIGH
, A.SEGMENT28_HIGH SEGMENT28_HIGH
, A.SEGMENT29_HIGH SEGMENT29_HIGH
, A.SEGMENT30_HIGH SEGMENT30_HIGH
, A.CREATION_DATE CREATION_DATE
, A.CREATED_BY CREATED_BY
, A.LAST_UPDATE_DATE LAST_UPDATE_DATE
, A.LAST_UPDATED_BY LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGI_ITR_CHARGE_RANGES A
, FND_USER F
WHERE A.AUTHORISER_ID = F.USER_ID

Columns

Name
ROW_ID
CHARGE_CENTER_ID
CHARGE_RANGE_ID
AUTHORISER_ID
EMPLOYEE_ID
ACTIVE_FLAG
PERSON_NAME_DSP
SEGMENT1_LOW
SEGMENT2_LOW
SEGMENT3_LOW
SEGMENT4_LOW
SEGMENT5_LOW
SEGMENT6_LOW
SEGMENT7_LOW
SEGMENT8_LOW
SEGMENT9_LOW
SEGMENT10_LOW
SEGMENT11_LOW
SEGMENT12_LOW
SEGMENT13_LOW
SEGMENT14_LOW
SEGMENT15_LOW
SEGMENT16_LOW
SEGMENT17_LOW
SEGMENT18_LOW
SEGMENT19_LOW
SEGMENT20_LOW
SEGMENT21_LOW
SEGMENT22_LOW
SEGMENT23_LOW
SEGMENT24_LOW
SEGMENT25_LOW
SEGMENT26_LOW
SEGMENT27_LOW
SEGMENT28_LOW
SEGMENT29_LOW
SEGMENT30_LOW
SEGMENT1_HIGH
SEGMENT2_HIGH
SEGMENT3_HIGH
SEGMENT4_HIGH
SEGMENT5_HIGH
SEGMENT6_HIGH
SEGMENT7_HIGH
SEGMENT8_HIGH
SEGMENT9_HIGH
SEGMENT10_HIGH
SEGMENT11_HIGH
SEGMENT12_HIGH
SEGMENT13_HIGH
SEGMENT14_HIGH
SEGMENT15_HIGH
SEGMENT16_HIGH
SEGMENT17_HIGH
SEGMENT18_HIGH
SEGMENT19_HIGH
SEGMENT20_HIGH
SEGMENT21_HIGH
SEGMENT22_HIGH
SEGMENT23_HIGH
SEGMENT24_HIGH
SEGMENT25_HIGH
SEGMENT26_HIGH
SEGMENT27_HIGH
SEGMENT28_HIGH
SEGMENT29_HIGH
SEGMENT30_HIGH
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN