eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGS_AD_ACAD_HISTORY_V

Source

View Text - Preformatted


SELECT HE.ROWID, HE.EDUCATION_ID, HE.PARTY_ID, HE.SCHOOL_PARTY_ID, DECODE (HE.SCHOOL_PARTY_ID,NULL, NULL, (SELECT OSS_ORG_UNIT_CD FROM IGS_PE_HZ_PARTIES WHERE HE.SCHOOL_PARTY_ID = PARTY_ID) ) INSTITUTION_CODE, NVL (DECODE (HE.SCHOOL_PARTY_ID,NULL, NULL, (SELECT PARTY_NAME FROM HZ_PARTIES WHERE HE.SCHOOL_PARTY_ID = PARTY_ID) ),HE.SCHOOL_ATTENDED_NAME ) INSTITUTION_NAME, DECODE (HE.SCHOOL_PARTY_ID,NULL, NULL, (SELECT OI_INSTITUTION_TYPE FROM IGS_PE_HZ_PARTIES WHERE HE.SCHOOL_PARTY_ID = PARTY_ID AND INST_ORG_IND = 'I') ) INSTITUTION_TYPE, DECODE (HE.SCHOOL_PARTY_ID,NULL, NULL, (SELECT OI_INST_CONTROL_TYPE FROM IGS_PE_HZ_PARTIES WHERE HE.SCHOOL_PARTY_ID = PARTY_ID AND INST_ORG_IND = 'I') ) INST_CONTROL_TYPE, HAH.CURRENT_INST, HAH.TRANSCRIPT_REQUIRED TRANSCRIPT_REQUIRED, NULL, NULL, HE.COURSE_MAJOR, DECODE (HE.COURSE_MAJOR,NULL, NULL, (SELECT TITLE FROM IGS_PS_VER WHERE COURSE_CD||'/'||VERSION_NUMBER = HE.COURSE_MAJOR) ) TITLE, HAH.COMMENTS, HE.START_DATE_ATTENDED, HE.LAST_DATE_ATTENDED, HAH.PLANNED_COMPLETION_DATE, NULL, NULL, HAH.RECALC_TOTAL_CP_ATTEMPTED, HAH.RECALC_TOTAL_CP_EARNED, HAH.RECALC_TOTAL_UNIT_GP, HAH.RECALC_TOT_GPA_UTS_ATTEMPTED, HAH.RECALC_INST_GPA, HAH.RECALC_GRADING_SCALE_ID, DECODE (HAH.RECALC_GRADING_SCALE_ID,NULL, NULL, (SELECT NAME FROM IGS_AD_CODE_CLASSES WHERE HAH.RECALC_GRADING_SCALE_ID = CODE_ID) ) RECALC_GRADING_SCALE, HAH.SELFREP_TOTAL_CP_ATTEMPTED, HAH.SELFREP_TOTAL_CP_EARNED, HAH.SELFREP_TOTAL_UNIT_GP, HAH.SELFREP_TOT_GPA_UTS_ATTEMP, HAH.SELFREP_INST_GPA, HAH.SELFREP_GRADING_SCALE_ID, DECODE (HAH.SELFREP_GRADING_SCALE_ID,NULL, NULL, (SELECT NAME FROM IGS_AD_CODE_CLASSES WHERE HAH.SELFREP_GRADING_SCALE_ID = CODE_ID) ) SELFREP_GRADING_SCALE, HAH.SELFREP_WEIGHTED_GPA, HAH.SELFREP_RANK_IN_CLASS, HAH.SELFREP_CLASS_SIZE, HAH.SELFREP_WEIGHED_RANK, HE.TYPE_OF_SCHOOL, HAH.ATTRIBUTE_CATEGORY, HAH.ATTRIBUTE1, HAH.ATTRIBUTE2, HAH.ATTRIBUTE3, HAH.ATTRIBUTE4, HAH.ATTRIBUTE5, HAH.ATTRIBUTE6, HAH.ATTRIBUTE7, HAH.ATTRIBUTE8, HAH.ATTRIBUTE9, HAH.ATTRIBUTE10, HAH.ATTRIBUTE11, HAH.ATTRIBUTE12, HAH.ATTRIBUTE13, HAH.ATTRIBUTE14, HAH.ATTRIBUTE15, HAH.ATTRIBUTE16, HAH.ATTRIBUTE17, HAH.ATTRIBUTE18, HAH.ATTRIBUTE19, HAH.ATTRIBUTE20, HE.CREATED_BY, HE.CREATION_DATE, HE.LAST_UPDATED_BY, HE.LAST_UPDATE_DATE, HE.LAST_UPDATE_LOGIN, HE.REQUEST_ID, HE.PROGRAM_APPLICATION_ID, HE.PROGRAM_ID, HE.PROGRAM_UPDATE_DATE, HE.STATUS, ( SELECT MEANING FROM FND_LOOKUP_VALUES WHERE HE.STATUS = LOOKUP_CODE AND LOOKUP_TYPE = 'REGISTRY_STATUS' AND VIEW_APPLICATION_ID = 222 AND SECURITY_GROUP_ID = 0 AND LANGUAGE = USERENV('LANG') ) STATUS_MEANING, HE.OBJECT_VERSION_NUMBER, HAH.DEGREE_ATTEMPTED, HE.DEGREE_RECEIVED FROM HZ_EDUCATION HE, IGS_AD_HZ_ACAD_HIST HAH WHERE HE.EDUCATION_ID = HAH.EDUCATION_ID(+) AND HE.STATUS IN ('A','I')

View Text - HTML Formatted

SELECT HE.ROWID
, HE.EDUCATION_ID
, HE.PARTY_ID
, HE.SCHOOL_PARTY_ID
, DECODE (HE.SCHOOL_PARTY_ID
, NULL
, NULL
, (SELECT OSS_ORG_UNIT_CD
FROM IGS_PE_HZ_PARTIES
WHERE HE.SCHOOL_PARTY_ID = PARTY_ID) ) INSTITUTION_CODE
, NVL (DECODE (HE.SCHOOL_PARTY_ID
, NULL
, NULL
, (SELECT PARTY_NAME
FROM HZ_PARTIES
WHERE HE.SCHOOL_PARTY_ID = PARTY_ID) )
, HE.SCHOOL_ATTENDED_NAME ) INSTITUTION_NAME
, DECODE (HE.SCHOOL_PARTY_ID
, NULL
, NULL
, (SELECT OI_INSTITUTION_TYPE
FROM IGS_PE_HZ_PARTIES
WHERE HE.SCHOOL_PARTY_ID = PARTY_ID
AND INST_ORG_IND = 'I') ) INSTITUTION_TYPE
, DECODE (HE.SCHOOL_PARTY_ID
, NULL
, NULL
, (SELECT OI_INST_CONTROL_TYPE
FROM IGS_PE_HZ_PARTIES
WHERE HE.SCHOOL_PARTY_ID = PARTY_ID
AND INST_ORG_IND = 'I') ) INST_CONTROL_TYPE
, HAH.CURRENT_INST
, HAH.TRANSCRIPT_REQUIRED TRANSCRIPT_REQUIRED
, NULL
, NULL
, HE.COURSE_MAJOR
, DECODE (HE.COURSE_MAJOR
, NULL
, NULL
, (SELECT TITLE
FROM IGS_PS_VER
WHERE COURSE_CD||'/'||VERSION_NUMBER = HE.COURSE_MAJOR) ) TITLE
, HAH.COMMENTS
, HE.START_DATE_ATTENDED
, HE.LAST_DATE_ATTENDED
, HAH.PLANNED_COMPLETION_DATE
, NULL
, NULL
, HAH.RECALC_TOTAL_CP_ATTEMPTED
, HAH.RECALC_TOTAL_CP_EARNED
, HAH.RECALC_TOTAL_UNIT_GP
, HAH.RECALC_TOT_GPA_UTS_ATTEMPTED
, HAH.RECALC_INST_GPA
, HAH.RECALC_GRADING_SCALE_ID
, DECODE (HAH.RECALC_GRADING_SCALE_ID
, NULL
, NULL
, (SELECT NAME
FROM IGS_AD_CODE_CLASSES
WHERE HAH.RECALC_GRADING_SCALE_ID = CODE_ID) ) RECALC_GRADING_SCALE
, HAH.SELFREP_TOTAL_CP_ATTEMPTED
, HAH.SELFREP_TOTAL_CP_EARNED
, HAH.SELFREP_TOTAL_UNIT_GP
, HAH.SELFREP_TOT_GPA_UTS_ATTEMP
, HAH.SELFREP_INST_GPA
, HAH.SELFREP_GRADING_SCALE_ID
, DECODE (HAH.SELFREP_GRADING_SCALE_ID
, NULL
, NULL
, (SELECT NAME
FROM IGS_AD_CODE_CLASSES
WHERE HAH.SELFREP_GRADING_SCALE_ID = CODE_ID) ) SELFREP_GRADING_SCALE
, HAH.SELFREP_WEIGHTED_GPA
, HAH.SELFREP_RANK_IN_CLASS
, HAH.SELFREP_CLASS_SIZE
, HAH.SELFREP_WEIGHED_RANK
, HE.TYPE_OF_SCHOOL
, HAH.ATTRIBUTE_CATEGORY
, HAH.ATTRIBUTE1
, HAH.ATTRIBUTE2
, HAH.ATTRIBUTE3
, HAH.ATTRIBUTE4
, HAH.ATTRIBUTE5
, HAH.ATTRIBUTE6
, HAH.ATTRIBUTE7
, HAH.ATTRIBUTE8
, HAH.ATTRIBUTE9
, HAH.ATTRIBUTE10
, HAH.ATTRIBUTE11
, HAH.ATTRIBUTE12
, HAH.ATTRIBUTE13
, HAH.ATTRIBUTE14
, HAH.ATTRIBUTE15
, HAH.ATTRIBUTE16
, HAH.ATTRIBUTE17
, HAH.ATTRIBUTE18
, HAH.ATTRIBUTE19
, HAH.ATTRIBUTE20
, HE.CREATED_BY
, HE.CREATION_DATE
, HE.LAST_UPDATED_BY
, HE.LAST_UPDATE_DATE
, HE.LAST_UPDATE_LOGIN
, HE.REQUEST_ID
, HE.PROGRAM_APPLICATION_ID
, HE.PROGRAM_ID
, HE.PROGRAM_UPDATE_DATE
, HE.STATUS
, ( SELECT MEANING
FROM FND_LOOKUP_VALUES
WHERE HE.STATUS = LOOKUP_CODE
AND LOOKUP_TYPE = 'REGISTRY_STATUS'
AND VIEW_APPLICATION_ID = 222
AND SECURITY_GROUP_ID = 0
AND LANGUAGE = USERENV('LANG') ) STATUS_MEANING
, HE.OBJECT_VERSION_NUMBER
, HAH.DEGREE_ATTEMPTED
, HE.DEGREE_RECEIVED
FROM HZ_EDUCATION HE
, IGS_AD_HZ_ACAD_HIST HAH
WHERE HE.EDUCATION_ID = HAH.EDUCATION_ID(+)
AND HE.STATUS IN ('A'
, 'I')