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]

VIEW: APPS.XTR_BOND_ALLOC_DETAILS_V

Object Details

Object Name:	XTR_BOND_ALLOC_DETAILS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_BOND_ALLOC_DETAILS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

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.

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
FROM APPS.XTR_BOND_ALLOC_DETAILS_V;

Dependencies

[top of page]

APPS.XTR_BOND_ALLOC_DETAILS_V references the following:

APPS: XTR_BOND_ALLOC_DETAILS

APPS.XTR_BOND_ALLOC_DETAILS_V is not referenced by any database object