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_LIMIT_OVERVIEW_V

Object Details

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

View Type

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

XTR_LIMIT_OVERVIEW_V shows a subset of columns from counterparty, sovereign, global, currency, group and settlement limits. The main purpose of this view is to show the limit versus utilization amounts for each of the six limit areas.

This view corresponds to the View Limit Utilizations window.

[View Source]

Columns

Name	Datatype	Length	Comments
LIMIT_TYPE	VARCHAR2	(12)	Various Limit Types like Counterparty, global
LIMIT_PARTY	VARCHAR2	(7)	Counter Party Name if cparty name is available
COUNTRY	VARCHAR2	(3)	Country
LIMIT_CODE	VARCHAR2	(7)	Limit code for counterparty limits
COMPANY	VARCHAR2	(7)	Company Code
LIMIT_GROUP	VARCHAR2	(3)	Limit type for group limits
CURRENCY	VARCHAR2	(15)	Currency Code
LIMIT_AMT	NUMBER		Limit Amount
UTILISED	NUMBER		Limit utilized
AVAILABLE	NUMBER		Limti Available
EFFECTIVE_DATE	DATE		Efffective date which is sysdate
ATTRIBUTE1	VARCHAR2	(256)	Descriptive flexfield segment column
ATTRIBUTE2	VARCHAR2	(256)	Descriptive flexfield segment column
ATTRIBUTE3	VARCHAR2	(256)	Descriptive flexfield segment column
ATTRIBUTE4	VARCHAR2	(256)	Descriptive flexfield segment column
ATTRIBUTE5	VARCHAR2	(256)	Descriptive flexfield segment column
ATTRIBUTE6	VARCHAR2	(256)	Descriptive flexfield segment column
ATTRIBUTE7	VARCHAR2	(256)	Descriptive flexfield segment column
ATTRIBUTE8	VARCHAR2	(256)	Descriptive flexfield segment column
ATTRIBUTE9	VARCHAR2	(256)	Descriptive flexfield segment column
ATTRIBUTE10	VARCHAR2	(256)	Descriptive flexfield segment column
ATTRIBUTE11	VARCHAR2	(256)	Descriptive flexfield segment column
ATTRIBUTE12	VARCHAR2	(256)	Descriptive flexfield segment column
ATTRIBUTE13	VARCHAR2	(256)	Descriptive flexfield segment column
ATTRIBUTE14	VARCHAR2	(256)	Descriptive flexfield segment column
ATTRIBUTE15	VARCHAR2	(256)	Descriptive flexfield segment column

Query Text

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


SELECT LIMIT_TYPE
,      LIMIT_PARTY
,      COUNTRY
,      LIMIT_CODE
,      COMPANY
,      LIMIT_GROUP
,      CURRENCY
,      LIMIT_AMT
,      UTILISED
,      AVAILABLE
,      EFFECTIVE_DATE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.XTR_LIMIT_OVERVIEW_V;

Dependencies

[top of page]

APPS.XTR_LIMIT_OVERVIEW_V references the following:

APPS: XTR_COMPANY_LIMITS; XTR_COUNTERPARTY_LIMITS; XTR_COUNTRY_COMPANY_LIMITS; XTR_GROUP_LIMITS; XTR_MASTER_CURRENCIES; XTR_PARTIES_V; XTR_PRO_PARAM; XTR_SETTLEMENTS_V; XTR_USER_ACCESS - show dependent code

APPS.XTR_LIMIT_OVERVIEW_V is referenced by following:

APPS: XTR_BIS_LIMIT_OVERVIEW_V; XTR_DISC_LIMIT_OVERVIEW_V