VIEW: XTR.XTR_BOND_ALLOC_DETAILS#

Source

View Text - Preformatted

select BOND_ALLOC_DETAIL_ID BOND_ALLOC_DETAIL_ID, BATCH_ID BATCH_ID, DEAL_NO DEAL_NO, CROSS_REF_NO CROSS_REF_NO, FACE_VALUE FACE_VALUE, INITIAL_FAIR_VALUE INITIAL_FAIR_VALUE, AMC_REAL_GAIN_LOSS AMC_REAL_GAIN_LOSS, MTM_REAL_GAIN_LOSS MTM_REAL_GAIN_LOSS, FRONT_END_BROKERAGE FRONT_END_BROKERAGE, BACK_END_BROKERAGE BACK_END_BROKERAGE, FRONT_END_PREM_DISC FRONT_END_PREM_DISC, BACK_END_PREM_DISC BACK_END_PREM_DISC, BACK_END_INTEREST BACK_END_INTEREST, CROSS_REF_DEAL_DATE CROSS_REF_DEAL_DATE, CROSS_REF_START_DATE CROSS_REF_START_DATE, CROSS_REF_CLEAN_PX CROSS_REF_CLEAN_PX, 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, AVG_RATE_LAST_PROCESSED AVG_RATE_LAST_PROCESSED from "XTR"."XTR_BOND_ALLOC_DETAILS"

View Text - HTML Formatted

SELECT BOND_ALLOC_DETAIL_ID BOND_ALLOC_DETAIL_ID
, BATCH_ID BATCH_ID
, DEAL_NO DEAL_NO
, CROSS_REF_NO CROSS_REF_NO
, FACE_VALUE FACE_VALUE
, INITIAL_FAIR_VALUE INITIAL_FAIR_VALUE
, AMC_REAL_GAIN_LOSS AMC_REAL_GAIN_LOSS
, MTM_REAL_GAIN_LOSS MTM_REAL_GAIN_LOSS
, FRONT_END_BROKERAGE FRONT_END_BROKERAGE
, BACK_END_BROKERAGE BACK_END_BROKERAGE
, FRONT_END_PREM_DISC FRONT_END_PREM_DISC
, BACK_END_PREM_DISC BACK_END_PREM_DISC
, BACK_END_INTEREST BACK_END_INTEREST
, CROSS_REF_DEAL_DATE CROSS_REF_DEAL_DATE
, CROSS_REF_START_DATE CROSS_REF_START_DATE
, CROSS_REF_CLEAN_PX CROSS_REF_CLEAN_PX
, 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
, AVG_RATE_LAST_PROCESSED AVG_RATE_LAST_PROCESSED
FROM "XTR"."XTR_BOND_ALLOC_DETAILS"