VIEW: XTR.XTR_DEAL_RETRO_TESTS#

Source

View Text - Preformatted

select DEAL_RETRO_TEST_ID DEAL_RETRO_TEST_ID, BATCH_ID BATCH_ID, HEDGE_ATTRIBUTE_ID HEDGE_ATTRIBUTE_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_ID, DEAL_NUMBER DEAL_NUMBER, AMOUNT_TYPE AMOUNT_TYPE, EFF_PRD_GAIN_LOSS_AMT EFF_PRD_GAIN_LOSS_AMT, INEFF_PRD_GAIN_LOSS_AMT INEFF_PRD_GAIN_LOSS_AMT, EXCLUDED_PRD_GAIN_LOSS_AMT EXCLUDED_PRD_GAIN_LOSS_AMT, RECLASS_GAIN_LOSS_AMT RECLASS_GAIN_LOSS_AMT, EFF_CUM_GAIN_LOSS_AMT EFF_CUM_GAIN_LOSS_AMT, INEFF_CUM_GAIN_LOSS_AMT INEFF_CUM_GAIN_LOSS_AMT, EXCLUDED_CUM_GAIN_LOSS_AMT EXCLUDED_CUM_GAIN_LOSS_AMT, HEDGE_RETRO_TEST_ID HEDGE_RETRO_TEST_ID, RESULT_DATE RESULT_DATE from "XTR"."XTR_DEAL_RETRO_TESTS"

View Text - HTML Formatted

SELECT DEAL_RETRO_TEST_ID DEAL_RETRO_TEST_ID
, BATCH_ID BATCH_ID
, HEDGE_ATTRIBUTE_ID HEDGE_ATTRIBUTE_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_ID
, DEAL_NUMBER DEAL_NUMBER
, AMOUNT_TYPE AMOUNT_TYPE
, EFF_PRD_GAIN_LOSS_AMT EFF_PRD_GAIN_LOSS_AMT
, INEFF_PRD_GAIN_LOSS_AMT INEFF_PRD_GAIN_LOSS_AMT
, EXCLUDED_PRD_GAIN_LOSS_AMT EXCLUDED_PRD_GAIN_LOSS_AMT
, RECLASS_GAIN_LOSS_AMT RECLASS_GAIN_LOSS_AMT
, EFF_CUM_GAIN_LOSS_AMT EFF_CUM_GAIN_LOSS_AMT
, INEFF_CUM_GAIN_LOSS_AMT INEFF_CUM_GAIN_LOSS_AMT
, EXCLUDED_CUM_GAIN_LOSS_AMT EXCLUDED_CUM_GAIN_LOSS_AMT
, HEDGE_RETRO_TEST_ID HEDGE_RETRO_TEST_ID
, RESULT_DATE RESULT_DATE
FROM "XTR"."XTR_DEAL_RETRO_TESTS"