[Home] [Help] [Dependency Information]

VIEW: APPS.XTR_MIRROR_DDA_LIMIT_ROW_V

Object Details

Object Name:	XTR_MIRROR_DDA_LIMIT_ROW_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_MIRROR_DDA_LIMIT_ROW_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

Query Text

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

SELECT DEAL_NUMBER
,      DEAL_TYPE
,      TRANSACTION_NUMBER
,      LIMIT_CODE
,      AMOUNT
,      HCE_AMOUNT
,      DATE_LAST_SET
,      PRODUCT_TYPE
,      COMPANY_CODE
,      LIMIT_PARTY
,      AMOUNT_DATE
,      DEALER_CODE
,      COUNTRY_CODE
,      DEAL_SUBTYPE
,      PORTFOLIO_CODE
,      STATUS_CODE
,      CURRENCY
,      UTILISED_AMOUNT
,      HCE_UTILISED_AMOUNT
,      CROSS_REF_TO_OTHER_PARTY
,      LIMIT_TYPE
,      COMMENCE_DATE
,      CURRENCY_COMBINATION
,      CONTRA_CCY
,      TRANSACTION_RATE
,      AMOUNT_INDIC
,      ACCOUNT_NO
FROM APPS.XTR_MIRROR_DDA_LIMIT_ROW_V;

Dependencies

[top of page]

APPS

FND_GLOBAL - show dependent code

XTR_COMPANY_AUTHORITIES

XTR_DEALER_CODES

XTR_MIRROR_DDA_LIMIT_ROW

APPS

XTR_EXP_SUMM_P - show dependent code

XTR_LIMITS_P - show dependent code

XTR_NET_POSITIONS_V