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.

[Home] [Help]

View: XTR_MIRROR_DDA_LIMIT_ROW_V

Product:	XTR - Treasury
Description:
Implementation/DBA Data:	APPS.XTR_MIRROR_DDA_LIMIT_ROW_V

View Text

SELECT XD.DEAL_NUMBER
, XD.DEAL_TYPE
, XD.TRANSACTION_NUMBER
, XD.LIMIT_CODE
, XD.AMOUNT
, XD.HCE_AMOUNT
, XD.DATE_LAST_SET
, XD.PRODUCT_TYPE
, XD.COMPANY_CODE
, XD.LIMIT_PARTY
, XD.AMOUNT_DATE
, XD.DEALER_CODE
, XD.COUNTRY_CODE
, XD.DEAL_SUBTYPE
, XD.PORTFOLIO_CODE
, XD.STATUS_CODE
, XD.CURRENCY
, XD.UTILISED_AMOUNT
, XD.HCE_UTILISED_AMOUNT
, XD.CROSS_REF_TO_OTHER_PARTY
, XD.LIMIT_TYPE
, XD.COMMENCE_DATE
, XD.CURRENCY_COMBINATION
, XD.CONTRA_CCY
, XD.TRANSACTION_RATE
, XD.AMOUNT_INDIC
, XD.ACCOUNT_NO FROM XTR_MIRROR_DDA_LIMIT_ROW XD WHERE COMPANY_CODE IN (SELECT XCA.PARTY_CODE FROM XTR_COMPANY_AUTHORITIES XCA
, XTR_DEALER_CODES XDC WHERE XD.COMPANY_CODE = XCA.PARTY_CODE AND XCA.DEALER_CODE = XDC.DEALER_CODE AND XCA.COMPANY_AUTHORISED_FOR_INPUT = 'Y' AND XDC.USER_ID = FND_GLOBAL.USER_ID)

Columns

Name
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