VIEW: APPS.IGI_ITR_CHARGE_RANGES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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