VIEW: APPS.IGI_ITR_CHARGE_RANGE_AUTH_SS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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