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_DISC_LIMIT_OVERVIEW_V

Object Details

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

View Type

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

The XTR_DISC_LIMIT_OVERVIEW_V view is used for the Discoverer report and is based on the XTR_LIMIT_OVERVIEW_V view and XTR_BIS_LIMIT_OVERVIEW_V view with User Access Security added to it. User access to company information is enforced in the XTR_DISC_LIMIT_OVERVIEW_V view. Please refer to the full description of XTR_LIMIT_OVERVIEW_V for more details.

[View Source]

Columns

Name	Datatype	Length	Comments
LIMIT_TYPE	VARCHAR2	(12)	Type of limit (COUNTERPARTY, COMPANY, GROUP, SOVEREIGN, or CURRENCY)
CPARTY	VARCHAR2	(7)	Refer to base table.
COUNTRY	VARCHAR2	(3)	Refer to base table.
COUNTRY_NAME	VARCHAR2	(80)	Refer to base table.
LIMIT_CODE	VARCHAR2	(7)	Refer to base table.
COMPANY	VARCHAR2	(7)	Refer to base table.
COMPANY_NAME	VARCHAR2	(50)	Refer to base table.
LIMIT_GROUP	VARCHAR2	(3)	Refer to base table.
CURR	VARCHAR2	(15)	Refer to base table.
LIMIT_AMOUNT	NUMBER		Refer to base table.
UTILIZED	NUMBER		Refer to base table.
AVAILABLE	NUMBER		Refer to base table.
EFFECTIVE_DATE	DATE		Refer to base table.
CPARTY_NAME	VARCHAR2	(50)	Refer to base table.

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
,      CPARTY_NAME
FROM APPS.XTR_DISC_LIMIT_OVERVIEW_V;

Dependencies

[top of page]

APPS.XTR_DISC_LIMIT_OVERVIEW_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_TERRITORIES_VL; XTR_COMPANY_AUTHORITIES; XTR_DEALER_CODES; XTR_LIMIT_OVERVIEW_V; XTR_PARTY_INFO; XTR_USER_ACCESS - show dependent code

APPS.XTR_DISC_LIMIT_OVERVIEW_V is not referenced by any database object