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_DISC_ACCRLS_AMORT_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

The XTR_DISC_NET_POSITIONS_V view is used for Discoverer report and is based on the XTR_NET_POSITIONS_V view and XTR_BIS_NET_POSITIONS_V view. User access to company information is enforced in the XTR_DISC_NET_POSITIONS_V view. Please refer to the full description of XTR_NET_POSITIONS_V for more details.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DEAL_NO	NUMBER		Yes	Unique number assigned to each deal
BATCH_ID	NUMBER	(15)	Yes	Refer to base table.
TRANS_NO	NUMBER		Yes	Refer to base table.
PERIOD_FROM	DATE		Yes	Refer to base table.
PERIOD_TO	DATE		Yes	Refer to base table.
COMPANY_CODE	VARCHAR2	(7)	Yes	Refer to base table.
DEAL_TYPE	VARCHAR2	(7)	Yes	Refer to base table.
DEAL_SUBTYPE	VARCHAR2	(7)	Yes	Refer to base table.
CPARTY_CODE	VARCHAR2	(7)		Refer to base table.
CURRENCY	VARCHAR2	(15)		Refer to base table.
PRODUCT_TYPE	VARCHAR2	(10)		Refer to base table.
PORTFOLIO_CODE	VARCHAR2	(7)		Refer to base table.
AMOUNT_TYPE	VARCHAR2	(7)	Yes	Refer to base table.
ACTION_CODE	VARCHAR2	(7)	Yes	Refer to base table.
TRANSACTION_AMOUNT	NUMBER			Refer to base table.
ACTUAL_START_DATE	DATE			Refer to base table.
ACTUAL_MATURITY_DATE	DATE			Refer to base table.
INTEREST_RATE	NUMBER			Refer to base table.
NO_OF_DAYS	NUMBER			Refer to base table.
YEAR_BASIS	NUMBER			Refer to base table.
ACCRLS_AMOUNT	NUMBER			Refer to base table.
FIRST_ACCRUAL_INDIC	VARCHAR2	(1)		Refer to base table.
ACCRLS_AMOUNT_BAL	NUMBER			Refer to base table.
EFFECTIVE_CALCULATED_VALUE	NUMBER			Refer to base table.
CALC_FACE_VALUE	NUMBER			Refer to base table.
EFFINT_ACCRLS_AMOUNT_BAL	NUMBER			Refer to base table.
COMPANY_NAME	VARCHAR2	(50)	Yes	Refer to base table.
DEAL_TYPE_NAME	VARCHAR2	(80)	Yes	Refer to base table.
DEAL_SUBTYPE_NAME	VARCHAR2	(80)	Yes	Refer to base table.
CPARTY_NAME	VARCHAR2	(50)		Refer to base table.
PRODUCT_TYPE_DESC	VARCHAR2	(80)		Refer to base table.

Query Text

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


SELECT DEAL_NO
,      BATCH_ID
,      TRANS_NO
,      PERIOD_FROM
,      PERIOD_TO
,      COMPANY_CODE
,      DEAL_TYPE
,      DEAL_SUBTYPE
,      CPARTY_CODE
,      CURRENCY
,      PRODUCT_TYPE
,      PORTFOLIO_CODE
,      AMOUNT_TYPE
,      ACTION_CODE
,      TRANSACTION_AMOUNT
,      ACTUAL_START_DATE
,      ACTUAL_MATURITY_DATE
,      INTEREST_RATE
,      NO_OF_DAYS
,      YEAR_BASIS
,      ACCRLS_AMOUNT
,      FIRST_ACCRUAL_INDIC
,      ACCRLS_AMOUNT_BAL
,      EFFECTIVE_CALCULATED_VALUE
,      CALC_FACE_VALUE
,      EFFINT_ACCRLS_AMOUNT_BAL
,      COMPANY_NAME
,      DEAL_TYPE_NAME
,      DEAL_SUBTYPE_NAME
,      CPARTY_NAME
,      PRODUCT_TYPE_DESC
FROM APPS.XTR_DISC_ACCRLS_AMORT_V;

Dependencies

[top of page]

APPS.XTR_DISC_ACCRLS_AMORT_V references the following:

APPS: FND_GLOBAL - show dependent code; XTR_ACCRLS_AMORT; XTR_COMPANY_AUTHORITIES; XTR_DEALER_CODES; XTR_DEAL_SUBTYPES; XTR_DEAL_TYPES; XTR_PARTY_INFO; XTR_PRODUCT_TYPES

APPS.XTR_DISC_ACCRLS_AMORT_V is not referenced by any database object