[Home] [Help]
View: 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
Name |
INTEREST_TOLERANCE_ID |
AUTHORIZED |
COMPANY_CODE |
CPARTY_CODE |
DEAL_TYPE |
CURRENCY_CODE |
LIMIT_AMOUNT |
AMOUNT_PERCENT |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |