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_A_BOND_ISSUES

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_A_BOND_ISSUES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UPDATED_ON
XTR_A_BOND_ISSUES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BOND_ISSUE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
AUDIT_DATE_STORED	DATE			Date on which this record is audited.
AUDIT_INDICATOR	VARCHAR2	(1)
AUTHORISED	VARCHAR2	(1)	Yes	Indicates if this record is authorised to be used. Valid values are: Y (authorised) or N (not authorised).
BOND_ISSUE_CODE	VARCHAR2	(7)	Yes
BOND_OR_DEBENTURE_ISSUE	VARCHAR2	(1)
CALC_TYPE	VARCHAR2	(15)
COUPON_RATE	NUMBER
COUPON_TYPE	VARCHAR2	(15)
CREATED_BY	VARCHAR2	(30)	Yes	User who created this record.
CREATED_ON	DATE		Yes	Date on which this record is created.
CURRENCY	VARCHAR2	(15)	Yes
DESCRIPTION	VARCHAR2	(35)
FIRST_COUPON_DATE	DATE
ISSUER	VARCHAR2	(7)	Yes
MATURITY_DATE	DATE		Yes
NO_OF_COUPONS_PER_YEAR	NUMBER		Yes
RIC_CODE	VARCHAR2	(20)
RISK_GROUP	VARCHAR2	(10)
UPDATED_BY	VARCHAR2	(30)
UPDATED_ON	DATE
YEAR_BASIS	NUMBER		Yes
YEAR_CALC_TYPE	VARCHAR2	(15)
ACCRUED_INT_YEAR_CALC_BASIS	VARCHAR2	(15)
FORCE_MONTH_END_COUPONS	VARCHAR2	(1)
COMMENCE_DATE	DATE
LAST_COUPON_DATE	DATE
SETTLEMENT_BASIS	VARCHAR2	(2)
SECURITY_ID	VARCHAR2	(10)
PRICE_ROUNDING	NUMBER
YIELD_ROUNDING	NUMBER
PRICE_ROUND_TYPE	VARCHAR2	(2)		Flag to indicate whether price information should be rounded(R) or truncated(T) to the specified number of digits.
YIELD_ROUND_TYPE	VARCHAR2	(2)		Flag to indicate whether yield information should be rounded(R) or truncated(T) to the specified number of digits.
CALC_ROUNDING	NUMBER			Number that specifies how many digits will be carried over during mid-step calculations.
PRICING_MODEL	VARCHAR2	(30)		Specifies the pricing model used by this deal. Derived from the CODE column of the XTR_PRICE_MODELS table. All deals will have a pricing model.
MARKET_DATA_SET	VARCHAR2	(30)		Specifies the market data set used by the pricing model
MARGIN	NUMBER			Specifies the margin for revaluation. This column is relevant for Bonds, Bond Options, Discounted Securities and Wholesale Term Money.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		For Descriptive Flexfield
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield

Query Text

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


SELECT AUDIT_DATE_STORED
,      AUDIT_INDICATOR
,      AUTHORISED
,      BOND_ISSUE_CODE
,      BOND_OR_DEBENTURE_ISSUE
,      CALC_TYPE
,      COUPON_RATE
,      COUPON_TYPE
,      CREATED_BY
,      CREATED_ON
,      CURRENCY
,      DESCRIPTION
,      FIRST_COUPON_DATE
,      ISSUER
,      MATURITY_DATE
,      NO_OF_COUPONS_PER_YEAR
,      RIC_CODE
,      RISK_GROUP
,      UPDATED_BY
,      UPDATED_ON
,      YEAR_BASIS
,      YEAR_CALC_TYPE
,      ACCRUED_INT_YEAR_CALC_BASIS
,      FORCE_MONTH_END_COUPONS
,      COMMENCE_DATE
,      LAST_COUPON_DATE
,      SETTLEMENT_BASIS
,      SECURITY_ID
,      PRICE_ROUNDING
,      YIELD_ROUNDING
,      PRICE_ROUND_TYPE
,      YIELD_ROUND_TYPE
,      CALC_ROUNDING
,      PRICING_MODEL
,      MARKET_DATA_SET
,      MARGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM XTR.XTR_A_BOND_ISSUES;

Dependencies

[top of page]

XTR.XTR_A_BOND_ISSUES does not reference any database object

XTR.XTR_A_BOND_ISSUES is referenced by following:

XTR: XTR_A_BOND_ISSUES#