VIEW: APPS.IGS_DA_XML_EXAMINATION_V

Source

View Text - Preformatted

SELECT atr.admission_test_type, to_char(atr.test_date, 'YYYY-MM-DD'), atr.comp_test_score, dr.batch_id, atr.person_id, atr.test_results_id from igs_ad_test_results_v atr, igs_da_rqst dr WHERE atr.active_ind = 'Y' and NOT EXISTS (select 'X' from IGS_DA_REQ_FTRS drf where drf.batch_id = dr.batch_id and drf.feature_code = 'ETS' and NVL(drf.feature_value, 'N') = 'Y')

View Text - HTML Formatted

SELECT ATR.ADMISSION_TEST_TYPE
, TO_CHAR(ATR.TEST_DATE
, 'YYYY-MM-DD')
, ATR.COMP_TEST_SCORE
, DR.BATCH_ID
, ATR.PERSON_ID
, ATR.TEST_RESULTS_ID
FROM IGS_AD_TEST_RESULTS_V ATR
, IGS_DA_RQST DR
WHERE ATR.ACTIVE_IND = 'Y'
AND NOT EXISTS (SELECT 'X'
FROM IGS_DA_REQ_FTRS DRF
WHERE DRF.BATCH_ID = DR.BATCH_ID
AND DRF.FEATURE_CODE = 'ETS'
AND NVL(DRF.FEATURE_VALUE
, 'N') = 'Y')