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_LIMIT_UTILIZATION_FEE

Object Details

Object Name:	XTR_LIMIT_UTILIZATION_FEE
Object Type:	TABLE
Owner:	XTR
FND Design Data:	XTR.XTR_LIMIT_UTILIZATION_FEE
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:

Columns

Name	Datatype	Length	Mandatory	Comments
COMPANY_CODE	VARCHAR2	(7)	Yes	Company identifier. Foreign key to XTR_PARTIES_V.
CPARTY_CODE	VARCHAR2	(7)	Yes	Counterparty identifier. Foreign key to XTR_PARTIES_V.
EFFECTIVE_FROM_DATE	DATE
INTEREST_RATE	NUMBER
LIMIT_CODE	VARCHAR2	(7)	Yes
MAX_AMT	NUMBER			Maximum fee amount.
MIN_AMT	NUMBER			Minimum fee amount.

Query Text

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


SELECT COMPANY_CODE
,      CPARTY_CODE
,      EFFECTIVE_FROM_DATE
,      INTEREST_RATE
,      LIMIT_CODE
,      MAX_AMT
,      MIN_AMT
FROM XTR.XTR_LIMIT_UTILIZATION_FEE;

Dependencies

[top of page]

XTR.XTR_LIMIT_UTILIZATION_FEE does not reference any database object

XTR.XTR_LIMIT_UTILIZATION_FEE is referenced by following:

XTR: XTR_LIMIT_UTILIZATION_FEE#