VIEW: IGI.IGI_DOS_SOURCES#

Source

View Text - Preformatted

select DOSSIER_ID DOSSIER_ID, SOURCE_ID SOURCE_ID, SOB_ID SOB_ID, COA_ID COA_ID, BUDGET BUDGET, BUDGET_ENTITY_ID BUDGET_ENTITY_ID, BUDGET_ENTITY_NAME BUDGET_ENTITY_NAME, SEGMENT1_LOW SEGMENT1_LOW, SEGMENT1_HIGH SEGMENT1_HIGH, SEGMENT2_LOW SEGMENT2_LOW, SEGMENT2_HIGH SEGMENT2_HIGH, SEGMENT3_LOW SEGMENT3_LOW, SEGMENT3_HIGH SEGMENT3_HIGH, SEGMENT4_LOW SEGMENT4_LOW, SEGMENT4_HIGH SEGMENT4_HIGH, SEGMENT5_LOW SEGMENT5_LOW, SEGMENT5_HIGH SEGMENT5_HIGH, SEGMENT6_LOW SEGMENT6_LOW, SEGMENT6_HIGH SEGMENT6_HIGH, SEGMENT7_HIGH SEGMENT7_HIGH, SEGMENT7_LOW SEGMENT7_LOW, SEGMENT8_HIGH SEGMENT8_HIGH, SEGMENT8_LOW SEGMENT8_LOW, SEGMENT9_HIGH SEGMENT9_HIGH, SEGMENT9_LOW SEGMENT9_LOW, SEGMENT10_HIGH SEGMENT10_HIGH, SEGMENT10_LOW SEGMENT10_LOW, SEGMENT11_HIGH SEGMENT11_HIGH, SEGMENT11_LOW SEGMENT11_LOW, SEGMENT12_HIGH SEGMENT12_HIGH, SEGMENT12_LOW SEGMENT12_LOW, SEGMENT13_HIGH SEGMENT13_HIGH, SEGMENT13_LOW SEGMENT13_LOW, SEGMENT14_HIGH SEGMENT14_HIGH, SEGMENT14_LOW SEGMENT14_LOW, SEGMENT15_HIGH SEGMENT15_HIGH, SEGMENT15_LOW SEGMENT15_LOW, SEGMENT16_HIGH SEGMENT16_HIGH, SEGMENT16_LOW SEGMENT16_LOW, SEGMENT17_HIGH SEGMENT17_HIGH, SEGMENT17_LOW SEGMENT17_LOW, SEGMENT18_HIGH SEGMENT18_HIGH, SEGMENT18_LOW SEGMENT18_LOW, SEGMENT19_HIGH SEGMENT19_HIGH, SEGMENT19_LOW SEGMENT19_LOW, SEGMENT20_HIGH SEGMENT20_HIGH, SEGMENT20_LOW SEGMENT20_LOW, SEGMENT21_HIGH SEGMENT21_HIGH, SEGMENT21_LOW SEGMENT21_LOW, SEGMENT22_HIGH SEGMENT22_HIGH, SEGMENT22_LOW SEGMENT22_LOW, SEGMENT23_HIGH SEGMENT23_HIGH, SEGMENT23_LOW SEGMENT23_LOW, SEGMENT24_HIGH SEGMENT24_HIGH, SEGMENT24_LOW SEGMENT24_LOW, SEGMENT25_HIGH SEGMENT25_HIGH, SEGMENT26_LOW SEGMENT26_LOW, SEGMENT26_HIGH SEGMENT26_HIGH, SEGMENT27_LOW SEGMENT27_LOW, SEGMENT27_HIGH SEGMENT27_HIGH, SEGMENT28_LOW SEGMENT28_LOW, SEGMENT28_HIGH SEGMENT28_HIGH, SEGMENT29_LOW SEGMENT29_LOW, SEGMENT29_HIGH SEGMENT29_HIGH, SEGMENT30_LOW SEGMENT30_LOW, SEGMENT30_HIGH SEGMENT30_HIGH, SEGMENTS_LOW_CCID SEGMENTS_LOW_CCID, SEGMENTS_HIGH_CCID SEGMENTS_HIGH_CCID, SEGMENTS_LOW_CCID_DESC SEGMENTS_LOW_CCID_DESC, SEGMENTS_HIGH_CCID_DESC SEGMENTS_HIGH_CCID_DESC, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, BUDGET_VERSION_ID BUDGET_VERSION_ID, PERIOD_NAME PERIOD_NAME, SEGMENT25_LOW SEGMENT25_LOW, LINE_NUM LINE_NUM from "IGI"."IGI_DOS_SOURCES"

View Text - HTML Formatted

SELECT DOSSIER_ID DOSSIER_ID
, SOURCE_ID SOURCE_ID
, SOB_ID SOB_ID
, COA_ID COA_ID
, BUDGET BUDGET
, BUDGET_ENTITY_ID BUDGET_ENTITY_ID
, BUDGET_ENTITY_NAME BUDGET_ENTITY_NAME
, SEGMENT1_LOW SEGMENT1_LOW
, SEGMENT1_HIGH SEGMENT1_HIGH
, SEGMENT2_LOW SEGMENT2_LOW
, SEGMENT2_HIGH SEGMENT2_HIGH
, SEGMENT3_LOW SEGMENT3_LOW
, SEGMENT3_HIGH SEGMENT3_HIGH
, SEGMENT4_LOW SEGMENT4_LOW
, SEGMENT4_HIGH SEGMENT4_HIGH
, SEGMENT5_LOW SEGMENT5_LOW
, SEGMENT5_HIGH SEGMENT5_HIGH
, SEGMENT6_LOW SEGMENT6_LOW
, SEGMENT6_HIGH SEGMENT6_HIGH
, SEGMENT7_HIGH SEGMENT7_HIGH
, SEGMENT7_LOW SEGMENT7_LOW
, SEGMENT8_HIGH SEGMENT8_HIGH
, SEGMENT8_LOW SEGMENT8_LOW
, SEGMENT9_HIGH SEGMENT9_HIGH
, SEGMENT9_LOW SEGMENT9_LOW
, SEGMENT10_HIGH SEGMENT10_HIGH
, SEGMENT10_LOW SEGMENT10_LOW
, SEGMENT11_HIGH SEGMENT11_HIGH
, SEGMENT11_LOW SEGMENT11_LOW
, SEGMENT12_HIGH SEGMENT12_HIGH
, SEGMENT12_LOW SEGMENT12_LOW
, SEGMENT13_HIGH SEGMENT13_HIGH
, SEGMENT13_LOW SEGMENT13_LOW
, SEGMENT14_HIGH SEGMENT14_HIGH
, SEGMENT14_LOW SEGMENT14_LOW
, SEGMENT15_HIGH SEGMENT15_HIGH
, SEGMENT15_LOW SEGMENT15_LOW
, SEGMENT16_HIGH SEGMENT16_HIGH
, SEGMENT16_LOW SEGMENT16_LOW
, SEGMENT17_HIGH SEGMENT17_HIGH
, SEGMENT17_LOW SEGMENT17_LOW
, SEGMENT18_HIGH SEGMENT18_HIGH
, SEGMENT18_LOW SEGMENT18_LOW
, SEGMENT19_HIGH SEGMENT19_HIGH
, SEGMENT19_LOW SEGMENT19_LOW
, SEGMENT20_HIGH SEGMENT20_HIGH
, SEGMENT20_LOW SEGMENT20_LOW
, SEGMENT21_HIGH SEGMENT21_HIGH
, SEGMENT21_LOW SEGMENT21_LOW
, SEGMENT22_HIGH SEGMENT22_HIGH
, SEGMENT22_LOW SEGMENT22_LOW
, SEGMENT23_HIGH SEGMENT23_HIGH
, SEGMENT23_LOW SEGMENT23_LOW
, SEGMENT24_HIGH SEGMENT24_HIGH
, SEGMENT24_LOW SEGMENT24_LOW
, SEGMENT25_HIGH SEGMENT25_HIGH
, SEGMENT26_LOW SEGMENT26_LOW
, SEGMENT26_HIGH SEGMENT26_HIGH
, SEGMENT27_LOW SEGMENT27_LOW
, SEGMENT27_HIGH SEGMENT27_HIGH
, SEGMENT28_LOW SEGMENT28_LOW
, SEGMENT28_HIGH SEGMENT28_HIGH
, SEGMENT29_LOW SEGMENT29_LOW
, SEGMENT29_HIGH SEGMENT29_HIGH
, SEGMENT30_LOW SEGMENT30_LOW
, SEGMENT30_HIGH SEGMENT30_HIGH
, SEGMENTS_LOW_CCID SEGMENTS_LOW_CCID
, SEGMENTS_HIGH_CCID SEGMENTS_HIGH_CCID
, SEGMENTS_LOW_CCID_DESC SEGMENTS_LOW_CCID_DESC
, SEGMENTS_HIGH_CCID_DESC SEGMENTS_HIGH_CCID_DESC
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, BUDGET_VERSION_ID BUDGET_VERSION_ID
, PERIOD_NAME PERIOD_NAME
, SEGMENT25_LOW SEGMENT25_LOW
, LINE_NUM LINE_NUM
FROM "IGI"."IGI_DOS_SOURCES"