View: XTR_INTEREST_TOLERANCES_V

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

View Text

SELECT IT.INTEREST_TOLERANCE_ID
, IT.AUTHORIZED
, IT.COMPANY_CODE
, IT.CPARTY_CODE
, IT.DEAL_TYPE
, IT.CURRENCY_CODE
, IT.LIMIT_AMOUNT
, IT.AMOUNT_PERCENT
, IT.CREATED_BY
, IT.CREATION_DATE
, IT.LAST_UPDATED_BY
, IT.LAST_UPDATE_DATE
, IT.LAST_UPDATE_LOGIN FROM XTR_INTEREST_TOLERANCES IT
WHERE IT.COMPANY_CODE IN ( SELECT XCA.PARTY_CODE
FROM XTR_COMPANY_AUTHORITIES XCA
, XTR_DEALER_CODES XDC
WHERE IT.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