VIEW: APPS.XTR_DISC_HEDGE_RETRO_TESTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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