View: XTR_DISC_HEDGE_PRO_TESTS_V

Product:	XTR - Treasury
Description:	View definition for the hedge prospective effectiveness test results.
Implementation/DBA Data:	APPS.XTR_DISC_HEDGE_PRO_TESTS_V

View Text

SELECT P.HEDGE_PRO_TEST_ID
, P.HEDGE_ATTRIBUTE_ID
, P.COMPANY_CODE
, XIA.FULL_NAME COMPANY_NAME
, P.RESULT_CODE
, P.RESULT_DATE
, P.LAST_TEST_DATE
, DC1.DEALER_CODE PERFORMED_BY
, P.COMMENTS
, DC2.DEALER_CODE CREATED_BY
, P.CREATION_DATE
, DC3.DEALER_CODE LAST_UPDATED_BY
, P.LAST_UPDATE_DATE
, DC4.DEALER_CODE LAST_UPDATE_LOGIN
, P.ATTRIBUTE_CATEGORY
, P.ATTRIBUTE1
, P.ATTRIBUTE2
, P.ATTRIBUTE3
, P.ATTRIBUTE4
, P.ATTRIBUTE5
, P.ATTRIBUTE6
, P.ATTRIBUTE7
, P.ATTRIBUTE8
, P.ATTRIBUTE9
, P.ATTRIBUTE10
, P.ATTRIBUTE11
, P.ATTRIBUTE12
, P.ATTRIBUTE13
, P.ATTRIBUTE14
, P.ATTRIBUTE15
FROM XTR_HEDGE_PRO_TESTS P
, XTR_COMPANY_AUTHORITIES XCA
, XTR_DEALER_CODES XDC
, XTR_PARTY_INFO XIA
, XTR_DEALER_CODES DC1
, XTR_DEALER_CODES DC2
, XTR_DEALER_CODES DC3
, XTR_DEALER_CODES DC4
WHERE P.COMPANY_CODE = XIA.PARTY_CODE
AND P.PERFORMED_BY = DC1.USER_ID
AND P.CREATED_BY = DC2.USER_ID
AND P.LAST_UPDATED_BY = DC3.USER_ID
AND P.LAST_UPDATE_LOGIN = DC4.USER_ID
AND P.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