DBA Data[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'