VIEW: APPS.IGS_AD_TST_RSLT_DTLS_V

Source

View Text - Preformatted

SELECT TRD.ROWID ROW_ID, TRD.TST_RSLT_DTLS_ID TST_RSLT_DTLS_ID, TRD.TEST_RESULTS_ID TEST_RESULTS_ID, TRD.TEST_SEGMENT_ID TEST_SEGMENT_ID, TS.TEST_SEGMENT_NAME TEST_SEGMENT_NAME, TRD.TEST_SCORE TEST_SCORE, TRD.PERCENTILE PERCENTILE, TRD.NATIONAL_PERCENTILE NATIONAL_PERCENTILE, TRD.STATE_PERCENTILE STATE_PERCENTILE, TRD.PERCENTILE_YEAR_RANK PERCENTILE_YEAR_RANK, TRD.SCORE_BAND_LOWER SCORE_BAND_LOWER, TRD.SCORE_BAND_UPPER SCORE_BAND_UPPER, TRD.IRREGULARITY_CODE_ID IRREGULARITY_CODE_ID, CC.NAME IRREGULARITY_CODE_NAME, TRD.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, TRD.ATTRIBUTE1 ATTRIBUTE1, TRD.ATTRIBUTE2 ATTRIBUTE2, TRD.ATTRIBUTE3 ATTRIBUTE3, TRD.ATTRIBUTE4 ATTRIBUTE4, TRD.ATTRIBUTE5 ATTRIBUTE5, TRD.ATTRIBUTE6 ATTRIBUTE6, TRD.ATTRIBUTE7 ATTRIBUTE7, TRD.ATTRIBUTE8 ATTRIBUTE8, TRD.ATTRIBUTE9 ATTRIBUTE9, TRD.ATTRIBUTE10 ATTRIBUTE10, TRD.ATTRIBUTE11 ATTRIBUTE11, TRD.ATTRIBUTE12 ATTRIBUTE12, TRD.ATTRIBUTE13 ATTRIBUTE13, TRD.ATTRIBUTE14 ATTRIBUTE14, TRD.ATTRIBUTE15 ATTRIBUTE15, TRD.ATTRIBUTE16 ATTRIBUTE16, TRD.ATTRIBUTE17 ATTRIBUTE17, TRD.ATTRIBUTE18 ATTRIBUTE18, TRD.ATTRIBUTE19 ATTRIBUTE19, TRD.ATTRIBUTE20 ATTRIBUTE20, TRD.CREATED_BY CREATED_BY, TRD.CREATION_DATE CREATION_DATE, TRD.LAST_UPDATED_BY LAST_UPDATED_BY, TRD.LAST_UPDATE_DATE LAST_UPDATE_DATE, TRD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TS.SEGMENT_TYPE SEGMENT_TYPE, TS.SEGMENT_GROUP SEGMENT_GROUP FROM IGS_AD_TST_RSLT_DTLS TRD, IGS_AD_TEST_SEGMENTS TS, IGS_AD_CODE_CLASSES CC WHERE TRD.TEST_SEGMENT_ID = TS.TEST_SEGMENT_ID AND CC.CODE_ID (+) = TRD.IRREGULARITY_CODE_ID

View Text - HTML Formatted

SELECT TRD.ROWID ROW_ID
, TRD.TST_RSLT_DTLS_ID TST_RSLT_DTLS_ID
, TRD.TEST_RESULTS_ID TEST_RESULTS_ID
, TRD.TEST_SEGMENT_ID TEST_SEGMENT_ID
, TS.TEST_SEGMENT_NAME TEST_SEGMENT_NAME
, TRD.TEST_SCORE TEST_SCORE
, TRD.PERCENTILE PERCENTILE
, TRD.NATIONAL_PERCENTILE NATIONAL_PERCENTILE
, TRD.STATE_PERCENTILE STATE_PERCENTILE
, TRD.PERCENTILE_YEAR_RANK PERCENTILE_YEAR_RANK
, TRD.SCORE_BAND_LOWER SCORE_BAND_LOWER
, TRD.SCORE_BAND_UPPER SCORE_BAND_UPPER
, TRD.IRREGULARITY_CODE_ID IRREGULARITY_CODE_ID
, CC.NAME IRREGULARITY_CODE_NAME
, TRD.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TRD.ATTRIBUTE1 ATTRIBUTE1
, TRD.ATTRIBUTE2 ATTRIBUTE2
, TRD.ATTRIBUTE3 ATTRIBUTE3
, TRD.ATTRIBUTE4 ATTRIBUTE4
, TRD.ATTRIBUTE5 ATTRIBUTE5
, TRD.ATTRIBUTE6 ATTRIBUTE6
, TRD.ATTRIBUTE7 ATTRIBUTE7
, TRD.ATTRIBUTE8 ATTRIBUTE8
, TRD.ATTRIBUTE9 ATTRIBUTE9
, TRD.ATTRIBUTE10 ATTRIBUTE10
, TRD.ATTRIBUTE11 ATTRIBUTE11
, TRD.ATTRIBUTE12 ATTRIBUTE12
, TRD.ATTRIBUTE13 ATTRIBUTE13
, TRD.ATTRIBUTE14 ATTRIBUTE14
, TRD.ATTRIBUTE15 ATTRIBUTE15
, TRD.ATTRIBUTE16 ATTRIBUTE16
, TRD.ATTRIBUTE17 ATTRIBUTE17
, TRD.ATTRIBUTE18 ATTRIBUTE18
, TRD.ATTRIBUTE19 ATTRIBUTE19
, TRD.ATTRIBUTE20 ATTRIBUTE20
, TRD.CREATED_BY CREATED_BY
, TRD.CREATION_DATE CREATION_DATE
, TRD.LAST_UPDATED_BY LAST_UPDATED_BY
, TRD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TRD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TS.SEGMENT_TYPE SEGMENT_TYPE
, TS.SEGMENT_GROUP SEGMENT_GROUP
FROM IGS_AD_TST_RSLT_DTLS TRD
, IGS_AD_TEST_SEGMENTS TS
, IGS_AD_CODE_CLASSES CC
WHERE TRD.TEST_SEGMENT_ID = TS.TEST_SEGMENT_ID
AND CC.CODE_ID (+) = TRD.IRREGULARITY_CODE_ID