[Home] [Help]
| Product: | XTR - Treasury |
|---|---|
| Description: | Based on table xtr_bond_alloc_details. |
| Implementation/DBA Data: |
APPS.XTR_BOND_ALLOC_DETAILS_V
|
SELECT BOND_ALLOC_DETAIL_ID
, BATCH_ID
, DEAL_NO
, CROSS_REF_NO
, FACE_VALUE
, INITIAL_FAIR_VALUE
, AMC_REAL_GAIN_LOSS
, MTM_REAL_GAIN_LOSS
, FRONT_END_BROKERAGE
, BACK_END_BROKERAGE
, FRONT_END_PREM_DISC
, BACK_END_PREM_DISC
, BACK_END_INTEREST
, CROSS_REF_DEAL_DATE
, CROSS_REF_START_DATE
, CROSS_REF_CLEAN_PX
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM XTR_BOND_ALLOC_DETAILS