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_BIS_LIMIT_OVERVIEW_V

Object Details

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

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Comments
LIMIT_TYPE	VARCHAR2	(12)	Type of limit (COUNTERPARTY, COMPANY, GROUP, SOVEREIGN, or CURRENCY)
CPARTY	VARCHAR2	(7)	Party against which limits are applied (only applies to counterparty, group, and settlement limits)
COUNTRY	VARCHAR2	(3)	Country code (only applies to counterparty and soveriegn limits)
COUNTRY_NAME	VARCHAR2	(80)	Country shortname
LIMIT_CODE	VARCHAR2	(7)	Limit code (only applies to company and counterparty limits)
COMPANY	VARCHAR2	(7)	Company code (does not apply to currency limits)
COMPANY_NAME	VARCHAR2	(20)	Counterparty shortname against whom the underlying deals are booked
LIMIT_GROUP	VARCHAR2	(3)	Type of limit, either counterparty, company, group, sovereign, settlement, or currency limit
CURR	VARCHAR2	(15)	Currency code (only applies to currency limits)
LIMIT_AMOUNT	NUMBER		Total amount that deal transactions have applied to the limit
UTILIZED	NUMBER		Total amount that deal transactions have applied to the limit
AVAILABLE	NUMBER		Amount available until reaching limit amount (difference between the limit and utilized amount)
EFFECTIVE_DATE	DATE		Limit effective date

Query Text

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


SELECT LIMIT_TYPE
,      CPARTY
,      COUNTRY
,      COUNTRY_NAME
,      LIMIT_CODE
,      COMPANY
,      COMPANY_NAME
,      LIMIT_GROUP
,      CURR
,      LIMIT_AMOUNT
,      UTILIZED
,      AVAILABLE
,      EFFECTIVE_DATE
FROM APPS.XTR_BIS_LIMIT_OVERVIEW_V;

Dependencies

[top of page]

APPS.XTR_BIS_LIMIT_OVERVIEW_V references the following:

APPS: FND_TERRITORIES_VL; XTR_LIMIT_OVERVIEW_V; XTR_PARTIES_V; XTR_USER_ACCESS - show dependent code

APPS.XTR_BIS_LIMIT_OVERVIEW_V is not referenced by any database object