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

VIEW: APPS.XTR_BOND_ISSUES_V

Object Details
Object Name: XTR_BOND_ISSUES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_BOND_ISSUES_V
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.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ISSUER VARCHAR2 (7) Yes Bond issuer
BOND_ISSUE_CODE VARCHAR2 (7) Yes User-defined identifier for the bond issue
FIRST_COUPON_DATE DATE

First coupon date to calculate cashflows from
MATURITY_DATE DATE
Yes Date when the deal matures or when an action is required
NO_OF_COUPONS_PER_YEAR NUMBER
Yes Number of coupons per year for the bond issue
COUPON_RATE NUMBER

Coupon rate
CURRENCY VARCHAR2 (15) Yes Currency code
CREATED_BY VARCHAR2 (30) Yes User who created this record
CREATED_ON DATE
Yes Date this record was created
AUTHORISED VARCHAR2 (1) Yes Flag to indicate if the bond issue is authorized for use (Y), or not (N)
YEAR_BASIS NUMBER
Yes No longer used
RISK_GROUP VARCHAR2 (10)
Product type
COUPON_TYPE VARCHAR2 (15)
Not currently used
DESCRIPTION VARCHAR2 (35)
Bond issue description
UPDATED_BY VARCHAR2 (30)
User who last updated this record
UPDATED_ON DATE

Date this record was last updated
AUDIT_INDICATOR VARCHAR2 (1)
Not currently used
CALC_TYPE VARCHAR2 (15)
Coupon interest calculation type
RIC_CODE VARCHAR2 (20)
Reference rate from current rates
BOND_OR_DEBENTURE_ISSUE VARCHAR2 (1)
Not currently used
YEAR_CALC_TYPE VARCHAR2 (15)
Day count basis which defines the way in which interest accrues
ACCRUED_INT_YEAR_CALC_BASIS VARCHAR2 (15)
Day count basis which defines the way in which interest accrues over time
FORCE_MONTH_END_COUPONS VARCHAR2 (1)
Flag to indicate if the coupon dates are to be forced to the last calendar date of the month (Y), or not (N)
COMMENCE_DATE DATE

Start date of the bond issue (dated date is the market term)
LAST_COUPON_DATE DATE

Last coupon date of the bond issue
SETTLEMENT_BASIS VARCHAR2 (2)
Method used to adjust coupon dates if they do not fall on a business day (valid values are Modified Following, Modified Previous (MP), Previous (P), and Null)
SECURITY_ID VARCHAR2 (15)
Bond issue unique identifier issued by the government (for example, CUSSIP)
PRICE_ROUNDING NUMBER

Number of decimal places used for price calculation
YIELD_ROUNDING NUMBER

Number of decimal places used for yield calculation
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.
MARGIN NUMBER

Specifies the margin for revaluation. This column is relevant for Bonds, Bond Options, Discounted Securities and Wholesale Term Money.
MARKET_DATA_SET VARCHAR2 (30)
Specifies the market data set used by the pricing model.
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.
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
ROUNDING_TYPE VARCHAR2 (1)
Not currently used
DAY_COUNT_TYPE VARCHAR2 (1)
Not currently used
BENCHMARK_RATE VARCHAR2 (20)
Benchmark rate
FLOAT_MARGIN NUMBER

Margin used for Floating Rate bond
RATE_FIXING_DAY NUMBER

Rate Fixing Day for Flaoting Rate Bond
MATURE_SETTLEMENT_BASIS VARCHAR2 (2)
Business day convention for maturity dates
CALLABLE_FLAG VARCHAR2 (1)
Y/N flag to denote if bond issue is callable
Query Text

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


SELECT ISSUER
,      BOND_ISSUE_CODE
,      FIRST_COUPON_DATE
,      MATURITY_DATE
,      NO_OF_COUPONS_PER_YEAR
,      COUPON_RATE
,      CURRENCY
,      CREATED_BY
,      CREATED_ON
,      AUTHORISED
,      YEAR_BASIS
,      RISK_GROUP
,      COUPON_TYPE
,      DESCRIPTION
,      UPDATED_BY
,      UPDATED_ON
,      AUDIT_INDICATOR
,      CALC_TYPE
,      RIC_CODE
,      BOND_OR_DEBENTURE_ISSUE
,      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
,      MARGIN
,      MARKET_DATA_SET
,      PRICING_MODEL
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ROUNDING_TYPE
,      DAY_COUNT_TYPE
,      BENCHMARK_RATE
,      FLOAT_MARGIN
,      RATE_FIXING_DAY
,      MATURE_SETTLEMENT_BASIS
,      CALLABLE_FLAG
FROM APPS.XTR_BOND_ISSUES_V;

Dependencies

[top of page]

APPS.XTR_BOND_ISSUES_V references the following:

SchemaAPPS
SynonymXTR_BOND_ISSUES
APPS.XTR_BOND_ISSUES_V is referenced by following:

SchemaAPPS
Package BodyXTR_MM_COVERS - show dependent code