View: XTR_DISC_HEDGE_RETRO_TESTS_V

Product:	XTR - Treasury
Description:	View definition for the retrospective effectiveness test results and measurement details at the hedge level.
Implementation/DBA Data:	APPS.XTR_DISC_HEDGE_RETRO_TESTS_V

View Text

SELECT R.HEDGE_RETRO_TEST_ID
, R.COMPANY_CODE
, XIA.FULL_NAME COMPANY_NAME
, R.HEDGE_ATTRIBUTE_ID
, R.RESULT_CODE
, R.BATCH_ID
, R.RESULT_DATE
, R.COMMENTS
, DC1.DEALER_CODE CREATED_BY
, R.CREATION_DATE
, DC2.DEALER_CODE LAST_UPDATED_BY
, R.LAST_UPDATE_DATE
, R.PROGRAM_ID
, R.PROGRAM_APPLICATION_ID
, R.REQUEST_ID
, R.COMPLETE_FLAG
, R.GAIN_LOSS_CCY
, R.AMOUNT_TYPE
, R.ITEM_PRD_GAIN_LOSS_AMT
, R.INST_PRD_GAIN_LOSS_AMT
, R.ITEM_CUM_GAIN_LOSS_AMT
, R.INST_CUM_GAIN_LOSS_AMT
, R.PCT_EFFECTIVE
, R.EFF_PRD_GAIN_LOSS_AMT
, R.INEFF_PRD_GAIN_LOSS_AMT
, R.EXCLUDED_PRD_GAIN_LOSS_AMT
, R.RECLASS_GAIN_LOSS_AMT
, R.EFF_CUM_GAIN_LOSS_AMT
, R.INEFF_CUM_GAIN_LOSS_AMT
, R.EXCLUDED_CUM_GAIN_LOSS_AMT
, R.ATTRIBUTE_CATEGORY
, R.ATTRIBUTE1
, R.ATTRIBUTE2
, R.ATTRIBUTE3
, R.ATTRIBUTE4
, R.ATTRIBUTE5
, R.ATTRIBUTE6
, R.ATTRIBUTE7
, R.ATTRIBUTE8
, R.ATTRIBUTE9
, R.ATTRIBUTE10
, R.ATTRIBUTE11
, R.ATTRIBUTE12
, R.ATTRIBUTE13
, R.ATTRIBUTE14
, R.ATTRIBUTE15
FROM XTR_HEDGE_RETRO_TESTS R
, XTR_COMPANY_AUTHORITIES XCA
, XTR_DEALER_CODES XDC
, XTR_PARTY_INFO XIA
, XTR_DEALER_CODES DC1
, XTR_DEALER_CODES DC2
WHERE R.COMPANY_CODE = XIA.PARTY_CODE
AND R.CREATED_BY = DC1.USER_ID
AND R.LAST_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