[Home] [Help]
VIEW: APPS.IGS_DA_XML_TESTSEGMENTS_V
Source
View Text - Preformatted
SELECT atsr.test_segment_name, atsr.test_score, atsr.person_id, atsr.test_results_id from igs_ad_test_seg_results_v atsr, igs_ad_test_results atr WHERE atsr.test_results_id = atr.test_results_id and atr.active_ind = 'Y'
View Text - HTML Formatted
SELECT ATSR.TEST_SEGMENT_NAME
, ATSR.TEST_SCORE
, ATSR.PERSON_ID
, ATSR.TEST_RESULTS_ID
FROM IGS_AD_TEST_SEG_RESULTS_V ATSR
, IGS_AD_TEST_RESULTS ATR
WHERE ATSR.TEST_RESULTS_ID = ATR.TEST_RESULTS_ID
AND ATR.ACTIVE_IND = 'Y'