VIEW: APPS.XTR_DISC_HEDGE_PRO_TESTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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