VIEW: APPS.XTR_INTEREST_TOLERANCES_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)