VIEW: APPS.XTR_DISC_REVALUATION_DETAILS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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