eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: XTR.XTR_BOND_ALLOC_DETAILS

Object Details

Object Name:	XTR_BOND_ALLOC_DETAILS
Object Type:	TABLE
Owner:	XTR
FND Design Data:	XTR.XTR_BOND_ALLOC_DETAILS
Subobject Name:
Status:	VALID

For realized gain/loss from bond resale

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Mandatory	Comments
BOND_ALLOC_DETAIL_ID	NUMBER	Yes	Unique identifier for each row of this table
BATCH_ID	NUMBER		Batch id of revaluation batch in which the gain/loss amount was recognized.
DEAL_NO	NUMBER		Deal number from which resale amount came from.
CROSS_REF_NO	NUMBER		Resale deal number.
FACE_VALUE	NUMBER		Resale face value.
INITIAL_FAIR_VALUE	NUMBER		Initial fair value allocated to the resold face.
AMC_REAL_GAIN_LOSS	NUMBER		Realized gain/loss of resale calculated based on the amortized cost basis method, with consideration for front and back-end transaction costs, dependant on company parameter 'Include Transaction Costs' setting.
MTM_REAL_GAIN_LOSS	NUMBER		Realized gain/loss of resale calculated based on the mark-to-market method, with consideration for front and back-end transaction costs, dependant on company parameter 'Include Transaction Costs' setting.
FRONT_END_BROKERAGE	NUMBER		Brokerage amount allocated to face value being resold from the original buy deal.
BACK_END_BROKERAGE	NUMBER		Brokerage amount allocated to face value being resold from the resale deal.
FRONT_END_PREM_DISC	NUMBER		Premium or discount amount from the original buy deal allocated to face value being resold. positive amount = premium negative amount = discount.
BACK_END_PREM_DISC	NUMBER		Premium or discount amount from the resale deal allocated to the face value being resold. positive amount = premium negative amount = discount.
BACK_END_INTEREST	NUMBER		Interest amount from the resale deal allocated to the face value being resold.
CROSS_REF_DEAL_DATE	DATE		Deal date of the resale deal.
CROSS_REF_START_DATE	DATE		Start date of the resale deal.
CROSS_REF_CLEAN_PX	NUMBER		Clean price of the resale deal.
CREATED_BY	NUMBER	Yes	Standard Who column.
CREATION_DATE	DATE	Yes	Standard Who column.
LAST_UPDATED_BY	NUMBER	Yes	Standard Who column.
LAST_UPDATE_DATE	DATE	Yes	Standard Who column.
LAST_UPDATE_LOGIN	NUMBER		Standard Who column.
AVG_RATE_LAST_PROCESSED	DATE		The date of the latest average rate that has been processed for a bond resale deal.

Query Text

Cut, paste (and edit) the following text to query this object:


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
,      AVG_RATE_LAST_PROCESSED
FROM XTR.XTR_BOND_ALLOC_DETAILS;

Dependencies

[top of page]

XTR.XTR_BOND_ALLOC_DETAILS does not reference any database object

XTR.XTR_BOND_ALLOC_DETAILS is referenced by following:

XTR: XTR_BOND_ALLOC_DETAILS#