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_EXCESS_LOG_DETAILS_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
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.
AUTHORISED_BY	VARCHAR2	(10)		Treasury user who authorized the limit exceptions
COMPANY_CODE	VARCHAR2	(7)		Company code
COUNTRY_CODE	VARCHAR2	(2)		Country code
CURRENCY	VARCHAR2	(15)		Currency code
DEAL_NUMBER	NUMBER		Yes	Unique number assigned to each deal
DEALER_CODE	VARCHAR2	(10)		Code for Treasury users
DUAL_AUTHORISED_BY	VARCHAR2	(10)		Not currently used
DUAL_AUTHORISED_ON	DATE			Not currently used
EXCEEDED_BY_AMOUNT	NUMBER			Amount that a transaction exceeded the limit
EXCEEDED_ON_DATE	DATE		Yes	Date on which the limit exception occurred
EXCEPTION_TYPE	VARCHAR2	(8)	Yes	Type of limit exception (WARNING, EXCEEDED, or NO_LIMIT)
HCE_AMOUNT	NUMBER		Yes	Exceeded amount in reporting currency equivalent
LIMITING_AMOUNT	NUMBER			Maximum amount allowed by the limit
LIMIT_CHECK_TYPE	VARCHAR2	(8)	Yes	Type of limit that exceeded (for example, company, counterparty, currency, and dealer)
LIMIT_CODE	VARCHAR2	(7)		Code for user-defined limits imposed on deals and transactions
LIMIT_COMPANY	VARCHAR2	(2)		Limit type code (tied to one of four limit categories)
LIMIT_GROUP	VARCHAR2	(2)		Limit investment category (F for fund, I for invest, X for foreign exchange, or OD for overdraft)
LIMIT_PARTY	VARCHAR2	(7)		Party against which limits are checked
LOG_ID	NUMBER		Yes	Limit exception log batch identifier
TRANSACTION_NUMBER	NUMBER			Unique reference number assigned to a transaction

Query Text

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


SELECT AMOUNT_DATE
,      AUTHORISED_BY
,      COMPANY_CODE
,      COUNTRY_CODE
,      CURRENCY
,      DEAL_NUMBER
,      DEALER_CODE
,      DUAL_AUTHORISED_BY
,      DUAL_AUTHORISED_ON
,      EXCEEDED_BY_AMOUNT
,      EXCEEDED_ON_DATE
,      EXCEPTION_TYPE
,      HCE_AMOUNT
,      LIMITING_AMOUNT
,      LIMIT_CHECK_TYPE
,      LIMIT_CODE
,      LIMIT_COMPANY
,      LIMIT_GROUP
,      LIMIT_PARTY
,      LOG_ID
,      TRANSACTION_NUMBER
FROM APPS.XTR_LIMIT_EXCESS_LOG_DETAILS_V;

Dependencies

[top of page]

APPS.XTR_LIMIT_EXCESS_LOG_DETAILS_V references the following:

APPS: XTR_COMPANY_LIMITS; XTR_LIMIT_EXCESS_LOG; XTR_LIMIT_TYPES; XTR_MIRROR_DDA_LIMIT_ROW; XTR_PARTY_INFO

APPS.XTR_LIMIT_EXCESS_LOG_DETAILS_V is not referenced by any database object