VIEW: APPS.IGS_AD_TRANSCRIPT_V

Source

View Text - Preformatted

SELECT T.ROWID ROW_ID, T.TRANSCRIPT_ID TRANSCRIPT_ID, T.EDUCATION_ID EDUCATION_ID, T.TRANSCRIPT_STATUS TRANSCRIPT_STATUS, L1.MEANING TRANSCRIPT_STATUS_MEANING, T.TRANSCRIPT_SOURCE TRANSCRIPT_SOURCE, CC3.NAME TRANSCRIPT_SOURCE_CODE, T.TRANSCRIPT_TYPE TRANSCRIPT_TYPE, L3.MEANING TRANSCRIPT_TYPE_MEANING, T.DATE_OF_RECEIPT DATE_OF_RECEIPT, T.TERM_TYPE TERM_TYPE, L2.MEANING TERM_TYPE_MEANING, T.RANK_IN_CLASS RANK_IN_CLASS, T.CLASS_SIZE CLASS_SIZE, T.WEIGHTED_RANK WEIGHTED_RANK, T.APPROXIMATE_RANK APPROXIMATE_RANK, T.PERCENTILE_RANK PERCENTILE_RANK, T.DECILE_RANK DECILE_RANK, T.QUARTILE_RANK QUARTILE_RANK, T.QUINTILE_RANK QUINTILE_RANK, T.ENTERED_GPA ENTERED_GPA, T.ENTERED_GS_ID ENTERED_GS_ID, CC1.NAME ENTERED_GRADING_SCALE, T.CONV_GPA CONV_GPA, T.CONV_GS_ID CONV_GS_ID, CC2.NAME CONV_GRADING_SCALE, T.CREATED_BY CREATED_BY, T.CREATION_DATE CREATION_DATE, T.LAST_UPDATED_BY LAST_UPDATED_BY, T.LAST_UPDATE_DATE LAST_UPDATE_DATE, T.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, T.REQUEST_ID REQUEST_ID, T.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, T.PROGRAM_ID PROGRAM_ID, T.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE ,T.OVERRIDE OVERRIDE ,T.OVERRIDE_ID OVERRIDE_ID ,T.OVERRIDE_DATE OVERRIDE_DATE ,T.DATE_OF_ISSUE DATE_OF_ISSUE , T. CORE_CURRICULUM_VALUE CORE_CURRICULUM_VALUE FROM IGS_AD_TRANSCRIPT T, IGS_LOOKUPS_VIEW L1, IGS_LOOKUPS_VIEW L2, IGS_AD_CODE_CLASSES CC1, IGS_AD_CODE_CLASSES CC2, IGS_AD_CODE_CLASSES CC3 ,IGS_LOOKUPS_VIEW L3 WHERE T.TRANSCRIPT_STATUS = L1.LOOKUP_CODE AND L1.LOOKUP_TYPE = 'TRANSCRIPT_STATUS' AND T.TERM_TYPE = L2.LOOKUP_CODE AND L2.LOOKUP_TYPE = 'TERM_TYPE' AND T.ENTERED_GS_ID = CC1.CODE_ID AND T.CONV_GS_ID = CC2.CODE_ID AND T.TRANSCRIPT_SOURCE = CC3.CODE_ID AND T.TRANSCRIPT_TYPE = L3.LOOKUP_CODE AND L3.LOOKUP_TYPE = 'TRANSCRIPT_TYPE'

View Text - HTML Formatted

SELECT T.ROWID ROW_ID
, T.TRANSCRIPT_ID TRANSCRIPT_ID
, T.EDUCATION_ID EDUCATION_ID
, T.TRANSCRIPT_STATUS TRANSCRIPT_STATUS
, L1.MEANING TRANSCRIPT_STATUS_MEANING
, T.TRANSCRIPT_SOURCE TRANSCRIPT_SOURCE
, CC3.NAME TRANSCRIPT_SOURCE_CODE
, T.TRANSCRIPT_TYPE TRANSCRIPT_TYPE
, L3.MEANING TRANSCRIPT_TYPE_MEANING
, T.DATE_OF_RECEIPT DATE_OF_RECEIPT
, T.TERM_TYPE TERM_TYPE
, L2.MEANING TERM_TYPE_MEANING
, T.RANK_IN_CLASS RANK_IN_CLASS
, T.CLASS_SIZE CLASS_SIZE
, T.WEIGHTED_RANK WEIGHTED_RANK
, T.APPROXIMATE_RANK APPROXIMATE_RANK
, T.PERCENTILE_RANK PERCENTILE_RANK
, T.DECILE_RANK DECILE_RANK
, T.QUARTILE_RANK QUARTILE_RANK
, T.QUINTILE_RANK QUINTILE_RANK
, T.ENTERED_GPA ENTERED_GPA
, T.ENTERED_GS_ID ENTERED_GS_ID
, CC1.NAME ENTERED_GRADING_SCALE
, T.CONV_GPA CONV_GPA
, T.CONV_GS_ID CONV_GS_ID
, CC2.NAME CONV_GRADING_SCALE
, T.CREATED_BY CREATED_BY
, T.CREATION_DATE CREATION_DATE
, T.LAST_UPDATED_BY LAST_UPDATED_BY
, T.LAST_UPDATE_DATE LAST_UPDATE_DATE
, T.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, T.REQUEST_ID REQUEST_ID
, T.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, T.PROGRAM_ID PROGRAM_ID
, T.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, T.OVERRIDE OVERRIDE
, T.OVERRIDE_ID OVERRIDE_ID
, T.OVERRIDE_DATE OVERRIDE_DATE
, T.DATE_OF_ISSUE DATE_OF_ISSUE
, T. CORE_CURRICULUM_VALUE CORE_CURRICULUM_VALUE
FROM IGS_AD_TRANSCRIPT T
, IGS_LOOKUPS_VIEW L1
, IGS_LOOKUPS_VIEW L2
, IGS_AD_CODE_CLASSES CC1
, IGS_AD_CODE_CLASSES CC2
, IGS_AD_CODE_CLASSES CC3
, IGS_LOOKUPS_VIEW L3
WHERE T.TRANSCRIPT_STATUS = L1.LOOKUP_CODE
AND L1.LOOKUP_TYPE = 'TRANSCRIPT_STATUS'
AND T.TERM_TYPE = L2.LOOKUP_CODE
AND L2.LOOKUP_TYPE = 'TERM_TYPE'
AND T.ENTERED_GS_ID = CC1.CODE_ID
AND T.CONV_GS_ID = CC2.CODE_ID
AND T.TRANSCRIPT_SOURCE = CC3.CODE_ID
AND T.TRANSCRIPT_TYPE = L3.LOOKUP_CODE
AND L3.LOOKUP_TYPE = 'TRANSCRIPT_TYPE'