VIEW: IGI.IGI_DOS_TRX_DEST#

Source

View Text - Preformatted

select SOB_ID SOB_ID, TRX_ID TRX_ID, DEST_TRX_ID DEST_TRX_ID, SOURCE_TRX_ID SOURCE_TRX_ID, SOURCE_ID SOURCE_ID, DESTINATION_ID DESTINATION_ID, CODE_COMBINATION_ID CODE_COMBINATION_ID, PROFILE_CODE PROFILE_CODE, BUDGET_NAME BUDGET_NAME, BUDGET_ENTITY_ID BUDGET_ENTITY_ID, BUDGET_AMOUNT BUDGET_AMOUNT, FUNDS_AVAILABLE FUNDS_AVAILABLE, NEW_BALANCE NEW_BALANCE, CURRENCY_CODE CURRENCY_CODE, VISIBLE_SEGMENTS VISIBLE_SEGMENTS, ACTUAL_SEGMENTS ACTUAL_SEGMENTS, MRC_BUDGET_AMOUNT MRC_BUDGET_AMOUNT, MRC_BUDGET_AMT_EXCH_RATE MRC_BUDGET_AMT_EXCH_RATE, MRC_BUDGET_AMT_EXCH_RATE_TYPE MRC_BUDGET_AMT_EXCH_RATE_TYPE, MRC_BUDGET_AMT_EXCH_DATE MRC_BUDGET_AMT_EXCH_DATE, MRC_BUDGET_AMT_EXCH_STATUS MRC_BUDGET_AMT_EXCH_STATUS, MRC_FUNDS_AVAIL MRC_FUNDS_AVAIL, MRC_FUNDS_AVAIL_EXCH_RATE MRC_FUNDS_AVAIL_EXCH_RATE, MRC_FUNDS_AVAIL_EXCH_RATE_TYPE MRC_FUNDS_AVAIL_EXCH_RATE_TYPE, MRC_FUNDS_AVAIL_EXCH_DATE MRC_FUNDS_AVAIL_EXCH_DATE, MRC_FUNDS_AVAIL_EXCH_STATUS MRC_FUNDS_AVAIL_EXCH_STATUS, MRC_NEW_BALANCE MRC_NEW_BALANCE, MRC_NEW_BALANCE_EXCH_RATE MRC_NEW_BALANCE_EXCH_RATE, MRC_NEW_BALANCE_EXCH_RATE_TYPE MRC_NEW_BALANCE_EXCH_RATE_TYPE, MRC_NEW_BALANCE_EXCH_DATE MRC_NEW_BALANCE_EXCH_DATE, MRC_NEW_BALANCE_EXCH_STATUS MRC_NEW_BALANCE_EXCH_STATUS, DOSSIER_ID DOSSIER_ID, BUDGET_VERSION_ID BUDGET_VERSION_ID, PERIOD_NAME PERIOD_NAME, PERCENTAGE PERCENTAGE, STATUS STATUS, GROUP_ID GROUP_ID, QUARTER_NUM QUARTER_NUM, PERIOD_YEAR PERIOD_YEAR, PERIOD_NUM PERIOD_NUM, 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, LINE_NUM LINE_NUM, SEGMENT1 SEGMENT1, SEGMENT2 SEGMENT2, SEGMENT3 SEGMENT3, SEGMENT4 SEGMENT4, SEGMENT5 SEGMENT5, SEGMENT6 SEGMENT6, SEGMENT7 SEGMENT7, SEGMENT8 SEGMENT8, SEGMENT9 SEGMENT9, SEGMENT10 SEGMENT10, SEGMENT11 SEGMENT11, SEGMENT12 SEGMENT12, SEGMENT13 SEGMENT13, SEGMENT14 SEGMENT14, SEGMENT15 SEGMENT15, SEGMENT16 SEGMENT16, SEGMENT17 SEGMENT17, SEGMENT18 SEGMENT18, SEGMENT19 SEGMENT19, SEGMENT20 SEGMENT20, SEGMENT21 SEGMENT21, SEGMENT22 SEGMENT22, SEGMENT23 SEGMENT23, SEGMENT24 SEGMENT24, SEGMENT25 SEGMENT25, SEGMENT26 SEGMENT26, SEGMENT27 SEGMENT27, SEGMENT28 SEGMENT28, SEGMENT29 SEGMENT29, SEGMENT30 SEGMENT30 from "IGI"."IGI_DOS_TRX_DEST"

View Text - HTML Formatted

SELECT SOB_ID SOB_ID
, TRX_ID TRX_ID
, DEST_TRX_ID DEST_TRX_ID
, SOURCE_TRX_ID SOURCE_TRX_ID
, SOURCE_ID SOURCE_ID
, DESTINATION_ID DESTINATION_ID
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, PROFILE_CODE PROFILE_CODE
, BUDGET_NAME BUDGET_NAME
, BUDGET_ENTITY_ID BUDGET_ENTITY_ID
, BUDGET_AMOUNT BUDGET_AMOUNT
, FUNDS_AVAILABLE FUNDS_AVAILABLE
, NEW_BALANCE NEW_BALANCE
, CURRENCY_CODE CURRENCY_CODE
, VISIBLE_SEGMENTS VISIBLE_SEGMENTS
, ACTUAL_SEGMENTS ACTUAL_SEGMENTS
, MRC_BUDGET_AMOUNT MRC_BUDGET_AMOUNT
, MRC_BUDGET_AMT_EXCH_RATE MRC_BUDGET_AMT_EXCH_RATE
, MRC_BUDGET_AMT_EXCH_RATE_TYPE MRC_BUDGET_AMT_EXCH_RATE_TYPE
, MRC_BUDGET_AMT_EXCH_DATE MRC_BUDGET_AMT_EXCH_DATE
, MRC_BUDGET_AMT_EXCH_STATUS MRC_BUDGET_AMT_EXCH_STATUS
, MRC_FUNDS_AVAIL MRC_FUNDS_AVAIL
, MRC_FUNDS_AVAIL_EXCH_RATE MRC_FUNDS_AVAIL_EXCH_RATE
, MRC_FUNDS_AVAIL_EXCH_RATE_TYPE MRC_FUNDS_AVAIL_EXCH_RATE_TYPE
, MRC_FUNDS_AVAIL_EXCH_DATE MRC_FUNDS_AVAIL_EXCH_DATE
, MRC_FUNDS_AVAIL_EXCH_STATUS MRC_FUNDS_AVAIL_EXCH_STATUS
, MRC_NEW_BALANCE MRC_NEW_BALANCE
, MRC_NEW_BALANCE_EXCH_RATE MRC_NEW_BALANCE_EXCH_RATE
, MRC_NEW_BALANCE_EXCH_RATE_TYPE MRC_NEW_BALANCE_EXCH_RATE_TYPE
, MRC_NEW_BALANCE_EXCH_DATE MRC_NEW_BALANCE_EXCH_DATE
, MRC_NEW_BALANCE_EXCH_STATUS MRC_NEW_BALANCE_EXCH_STATUS
, DOSSIER_ID DOSSIER_ID
, BUDGET_VERSION_ID BUDGET_VERSION_ID
, PERIOD_NAME PERIOD_NAME
, PERCENTAGE PERCENTAGE
, STATUS STATUS
, GROUP_ID GROUP_ID
, QUARTER_NUM QUARTER_NUM
, PERIOD_YEAR PERIOD_YEAR
, PERIOD_NUM PERIOD_NUM
, 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
, LINE_NUM LINE_NUM
, SEGMENT1 SEGMENT1
, SEGMENT2 SEGMENT2
, SEGMENT3 SEGMENT3
, SEGMENT4 SEGMENT4
, SEGMENT5 SEGMENT5
, SEGMENT6 SEGMENT6
, SEGMENT7 SEGMENT7
, SEGMENT8 SEGMENT8
, SEGMENT9 SEGMENT9
, SEGMENT10 SEGMENT10
, SEGMENT11 SEGMENT11
, SEGMENT12 SEGMENT12
, SEGMENT13 SEGMENT13
, SEGMENT14 SEGMENT14
, SEGMENT15 SEGMENT15
, SEGMENT16 SEGMENT16
, SEGMENT17 SEGMENT17
, SEGMENT18 SEGMENT18
, SEGMENT19 SEGMENT19
, SEGMENT20 SEGMENT20
, SEGMENT21 SEGMENT21
, SEGMENT22 SEGMENT22
, SEGMENT23 SEGMENT23
, SEGMENT24 SEGMENT24
, SEGMENT25 SEGMENT25
, SEGMENT26 SEGMENT26
, SEGMENT27 SEGMENT27
, SEGMENT28 SEGMENT28
, SEGMENT29 SEGMENT29
, SEGMENT30 SEGMENT30
FROM "IGI"."IGI_DOS_TRX_DEST"