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_MATURITIES_V

Object Details

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

View Type

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

XTR_MATURITIES_V contains information on the cashflows that belong to the date amount types that appear in the Maturities by Counterparty or Maturities by Date reports. The date amount types that appear in these reports are pre-defined and have the MATURITY_REPORT flag set to 'Y' in the XTR_DATE_AMOUNT_TYPES table.
This view is used in the Maturities by Date and Maturities by Counterparty reports.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DEAL_NUMBER	NUMBER		Yes	Unique number assigned to each deal
TRANSACTION_NUMBER	NUMBER			Unique reference number assigned to a transaction
AMOUNT_DATE	DATE			Date the deal finishes and is paid off, or date the principal amount of a note, draft, acceptance, bond, short term or other debt instrument becomes due and payable.
CURRENCY	VARCHAR2	(15)	Yes	Currency code
TYPE_OF_AMOUNT	VARCHAR2	(7)	Yes	Code that identifies the purpose of the amounts for a deal type
USER_AMOUNT_TYPE	VARCHAR2	(7)	Yes	User-defined amount type code
AMOUNT	NUMBER		Yes	Transaction amount
CASHFLOW_AMOUNT	NUMBER			Cash flow amount
COMPANY	VARCHAR2	(7)		Company code
CPARTY	VARCHAR2	(7)		Counterparty code
CPARTY_NAME	VARCHAR2	(20)		Counterparty short name
CLIENT	VARCHAR2	(7)		Client for which the deal is made
CLIENT_NAME	VARCHAR2	(20)		Client short name
DEALER	VARCHAR2	(10)		Code for Treasury users
CONTRACT_TYPE	VARCHAR2	(7)	Yes	Code for high level deals
USER_DEAL_TYPE	VARCHAR2	(7)	Yes	User-defined deal type code
SUBTYPE	VARCHAR2	(7)		Code for deal executions permissible within a deal type
USER_DEAL_SUBTYPE	VARCHAR2	(7)	Yes	User-defined deal subtype code
PRODUCT	VARCHAR2	(10)		Code for products used in a deal type
PORTFOLIO	VARCHAR2	(7)		Code for grouping deals under a single portfolio
CODE_COMBINATION_ID	NUMBER	(15)		Unique key for identifying GL account references
RATE	NUMBER			Transaction rate
COMPANY_ACCOUNT	VARCHAR2	(20)		Settlement account number
HCE_AMOUNT	NUMBER			Amount in reporting currency equivalent
CONTRACT_STATUS	VARCHAR2	(10)		Code for the execution status of deals and transactions
USER_STATUS_CODE	VARCHAR2	(10)	Yes	User-defined deal status code
DIARY_NOTE_DETAILS	VARCHAR2	(255)		Not currently used
AUTHORISED_BY	VARCHAR2	(30)		Login name of user who created the deal, to be included only if parameter DUAL_AUTHORISE is set to Y
AUTHORISED_ON	DATE			Date on which the user created the deal, to be included only if parameter DUAL_AUTHORISE is set to Y
DATE_TYPE	VARCHAR2	(7)	Yes	Date type tied to specific deal types (for example, accrual, maturity, start, and dealt dates)
USER_DATE_TYPE	VARCHAR2	(7)	Yes	User-defined date type code

Query Text

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


SELECT DEAL_NUMBER
,      TRANSACTION_NUMBER
,      AMOUNT_DATE
,      CURRENCY
,      TYPE_OF_AMOUNT
,      USER_AMOUNT_TYPE
,      AMOUNT
,      CASHFLOW_AMOUNT
,      COMPANY
,      CPARTY
,      CPARTY_NAME
,      CLIENT
,      CLIENT_NAME
,      DEALER
,      CONTRACT_TYPE
,      USER_DEAL_TYPE
,      SUBTYPE
,      USER_DEAL_SUBTYPE
,      PRODUCT
,      PORTFOLIO
,      CODE_COMBINATION_ID
,      RATE
,      COMPANY_ACCOUNT
,      HCE_AMOUNT
,      CONTRACT_STATUS
,      USER_STATUS_CODE
,      DIARY_NOTE_DETAILS
,      AUTHORISED_BY
,      AUTHORISED_ON
,      DATE_TYPE
,      USER_DATE_TYPE
FROM APPS.XTR_MATURITIES_V;

Dependencies

[top of page]

APPS.XTR_MATURITIES_V references the following:

APPS: XTR_AMOUNT_TYPES; XTR_DATE_AMOUNT_TYPES; XTR_DATE_TYPES; XTR_DEAL_DATE_AMOUNTS_V; XTR_DEAL_STATUSES; XTR_DEAL_SUBTYPES; XTR_DEAL_TYPES; XTR_PARTY_INFO; XTR_USER_ACCESS - show dependent code

APPS.XTR_MATURITIES_V is not referenced by any database object