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_MIRROR_DDA_LIMIT_ROW

Object Details

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

XTR_MIRROR_DDA_LIMIT_ROW contains the cashflow information for all deal transactions in CURRENT status. Each row contains the cashflow details for one deal transaction. The ?after insert, update or delete? database trigger for the XTR_DEAL_DATE_AMOUNTS table
inserts a not null LIMIT_CODE column into this table. In addition, the trigger calculates the weighted limit utilization amount and its reporting currency equivalent for the deal transaction and inserts those amounts into this table. Triggers also update the limit utilization amounts in the applicable limits tables.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_MIRROR_DDA_LIMIT_ROW_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DEAL_NUMBER TRANSACTION_NUMBER DEAL_TYPE
XTR_MIRROR_DDA_LIMIT_ROW_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LIMIT_PARTY
XTR_MIRROR_DDA_LIMIT_ROW_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AMOUNT_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
ACCOUNT_NO	VARCHAR2	(20)		Alpha-numeric reference to financial accounts of Treasury parties
AMOUNT	NUMBER		Yes	Transaction amount
AMOUNT_DATE	DATE			Date that the deal finishes and is paid off. Date on which the principal amount of a note, draft, acceptance, bond, short term or other debt instrument becomes due and payable.
AMOUNT_INDIC	NUMBER			Not currently used
COMMENCE_DATE	DATE			Commence date
COMPANY_CODE	VARCHAR2	(7)		Company code
CONTRA_CCY	VARCHAR2	(15)		Contra currency in a foreign exchange currency quote
COUNTRY_CODE	VARCHAR2	(2)		Country code
CROSS_REF_TO_OTHER_PARTY	VARCHAR2	(7)		Party cross reference
CURRENCY	VARCHAR2	(15)		Currency code
CURRENCY_COMBINATION	VARCHAR2	(31)		Currency quotations which combine a base and a contra currency
DATE_LAST_SET	DATE		Yes	Not currently used
DEALER_CODE	VARCHAR2	(10)		Code for Treasury users
DEAL_NUMBER	NUMBER		Yes	Unique number assigned to each deal
DEAL_SUBTYPE	VARCHAR2	(7)		Code for deal executions permissible within a deal type
DEAL_TYPE	VARCHAR2	(7)	Yes	Code for high level deals
HCE_AMOUNT	NUMBER		Yes	Amount in reporting currency equivalent
HCE_UTILISED_AMOUNT	NUMBER			Amount in reporting currency equivalent
LIMIT_CODE	VARCHAR2	(7)		Code for user-defined limits imposed on deals and transactions
LIMIT_PARTY	VARCHAR2	(7)		Party on which limit is imposed
LIMIT_TYPE	VARCHAR2	(2)		Type of limit imposed
PORTFOLIO_CODE	VARCHAR2	(7)		Code for grouping deals under a single portfolio
PRODUCT_TYPE	VARCHAR2	(10)		Code for products used in a deal type
STATUS_CODE	VARCHAR2	(10)		Code for the execution status of deals and transactions
TRANSACTION_NUMBER	NUMBER		Yes	Unique reference number assigned to a transaction
TRANSACTION_RATE	NUMBER			Transaction rate (for example, foreign exchange rate or money market interest rate)
UTILISED_AMOUNT	NUMBER			Total amount that deal transactions have applied to the limit
COL_17095040	DATE			Not currently used
BANK_ACCT_USE_ID	NUMBER	(15)		ID reference to financial accounts of Treasury parties

Query Text

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


SELECT ACCOUNT_NO
,      AMOUNT
,      AMOUNT_DATE
,      AMOUNT_INDIC
,      COMMENCE_DATE
,      COMPANY_CODE
,      CONTRA_CCY
,      COUNTRY_CODE
,      CROSS_REF_TO_OTHER_PARTY
,      CURRENCY
,      CURRENCY_COMBINATION
,      DATE_LAST_SET
,      DEALER_CODE
,      DEAL_NUMBER
,      DEAL_SUBTYPE
,      DEAL_TYPE
,      HCE_AMOUNT
,      HCE_UTILISED_AMOUNT
,      LIMIT_CODE
,      LIMIT_PARTY
,      LIMIT_TYPE
,      PORTFOLIO_CODE
,      PRODUCT_TYPE
,      STATUS_CODE
,      TRANSACTION_NUMBER
,      TRANSACTION_RATE
,      UTILISED_AMOUNT
,      COL_17095040
,      BANK_ACCT_USE_ID
FROM XTR.XTR_MIRROR_DDA_LIMIT_ROW;

Dependencies

[top of page]

XTR.XTR_MIRROR_DDA_LIMIT_ROW does not reference any database object

XTR.XTR_MIRROR_DDA_LIMIT_ROW is referenced by following:

APPS: XTR_AD_MIRROR_DDA_LIMIT_ROW_T; XTR_AI_MIRROR_DDA_LIMIT_ROW_T; XTR_AU_MIRROR_DDA_LIMIT_ROW_T; XTR_MIRROR_DDA_LIMIT_ROW