VIEW: APPS.IGSBV_AD_PER_TST_RSLT_DTLS

Source

View Text - Preformatted

SELECT atd.TST_RSLT_DTLS_ID, atd.TEST_RESULTS_ID, apt.PERSON_ID, apt.ADMISSION_TEST_TYPE, atd.TEST_SEGMENT_ID, atd.TEST_SCORE, atd.PERCENTILE, atd.NATIONAL_PERCENTILE, atd.STATE_PERCENTILE, atd.PERCENTILE_YEAR_RANK, atd.SCORE_BAND_LOWER, atd.SCORE_BAND_UPPER, atd.IRREGULARITY_CODE_ID, '_DF:IGS:IGS_AD_TEST_RSLT_DTLS_FLEX:atd', atd.created_by, atd.creation_date, atd.last_updated_by, atd.last_update_date FROM IGS_AD_TST_RSLT_DTLS atd, IGS_AD_TEST_RESULTS apt WHERE atd.TEST_RESULTS_ID = apt.TEST_RESULTS_ID WITH READ ONLY

View Text - HTML Formatted

SELECT ATD.TST_RSLT_DTLS_ID
, ATD.TEST_RESULTS_ID
, APT.PERSON_ID
, APT.ADMISSION_TEST_TYPE
, ATD.TEST_SEGMENT_ID
, ATD.TEST_SCORE
, ATD.PERCENTILE
, ATD.NATIONAL_PERCENTILE
, ATD.STATE_PERCENTILE
, ATD.PERCENTILE_YEAR_RANK
, ATD.SCORE_BAND_LOWER
, ATD.SCORE_BAND_UPPER
, ATD.IRREGULARITY_CODE_ID
, '_DF:IGS:IGS_AD_TEST_RSLT_DTLS_FLEX:ATD'
, ATD.CREATED_BY
, ATD.CREATION_DATE
, ATD.LAST_UPDATED_BY
, ATD.LAST_UPDATE_DATE
FROM IGS_AD_TST_RSLT_DTLS ATD
, IGS_AD_TEST_RESULTS APT
WHERE ATD.TEST_RESULTS_ID = APT.TEST_RESULTS_ID WITH READ ONLY