View: XTR_DISC_REVALUATION_DETAILS_V

Product:	XTR - Treasury
Description:	Revaluation results of Treasury deals, where user access to company information is enforced.
Implementation/DBA Data:	APPS.XTR_DISC_REVALUATION_DETAILS_V

View Text

SELECT R.ACTION_CODE
, R.COMPANY_CODE
, R.CONTRACT_CODE
, R.CURRENCYA TRANS_CURR
, R.CURRENCYB CONTRA_CURR
, R.REF_NUMBER
, ST.USER_DEAL_SUBTYPE
, DT.USER_DEAL_TYPE
, R.EFFECTIVE_DATE
, R.EFFECTIVE_DAYS
, DC1.DEALER_CODE ENTERED_BY
, R.ENTERED_ON
, R.FACE_VALUE
, R.FXO_SELL_REF_AMOUNT
, R.PERIOD_FROM
, R.PERIOD_TO
, R.PORTFOLIO_CODE
, R.PRODUCT_TYPE
, R.REALISED_PL
, R.REVAL_CCY
, R.REVAL_RATE
, R.TRANSACTION_NO
, R.TRANSACTION_PERIOD
, R.TRANSACTION_RATE
, R.UNREALISED_PL
, DC2.DEALER_CODE UPDATED_BY
, R.UPDATED_ON
, R.YEAR_BASIS
, DC3.DEALER_CODE CREATED_BY
, R.CREATED_ON
, R.REVALUATION_DETAILS_ID
, R.BATCH_ID
, R.COMPLETE_FLAG
, R.OVERWRITE_TYPE
, R.OVERWRITE_VALUE
, R.OVERWRITE_REASON
, R.FAIR_VALUE
, R.REALIZED_FLAG
, R.CUMM_GAIN_LOSS_AMOUNT
, R.CURR_GAIN_LOSS_AMOUNT
, R.SOB_FV_GAIN_LOSS_AMOUNT
, R.SOB_FAIR_VALUE_AMOUNT
, R.REVAL_CURR_FV_AMOUNT
, R.CTR_CURR_SOB_CURR_FWD_RATE
, R.EXCHANGE_RATE_ONE
, R.EXCHANGE_RATE_TWO
, R.AMOUNT_TYPE
, R.QUANTITY
, XIA.FULL_NAME COMPANY_NAME
, ST.NAME DEAL_SUBTYPE_NAME
, DT.NAME DEAL_TYPE_NAME
, P.PRODUCT_DESC PRODUCT_TYPE_DESC
FROM XTR_REVALUATION_DETAILS_V R
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST
, XTR_COMPANY_AUTHORITIES XCA
, XTR_DEALER_CODES XDC
, XTR_PRODUCT_TYPES P
, XTR_PARTY_INFO XIA
, XTR_DEALER_CODES DC1
, XTR_DEALER_CODES DC2
, XTR_DEALER_CODES DC3
WHERE DT.DEAL_TYPE = R.DEAL_TYPE
AND (ST.DEAL_TYPE(+) = R.DEAL_TYPE
AND ST.DEAL_SUBTYPE(+) = R.DEAL_SUBTYPE)
AND (P.DEAL_TYPE(+) = R.DEAL_TYPE
AND P.PRODUCT_TYPE(+) = R.PRODUCT_TYPE)
AND R.COMPANY_CODE = XIA.PARTY_CODE
AND R.ENTERED_BY = DC1.USER_ID
AND R.CREATED_BY = DC3.USER_ID
AND R.UPDATED_BY = DC2.USER_ID
AND R.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