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.IGSFV_STUDENT_PROGRAM_TERMS

Source

View Text - Preformatted


SELECT SPAT.TERM_RECORD_ID,SPAT.PERSON_ID,HP.PARTY_NUMBER,HP.PARTY_NAME,SPAT.PROGRAM_CD, SPAT.PROGRAM_VERSION,PV.TITLE,SPAT.ACAD_CAL_TYPE,CT.DESCRIPTION,SPAT.TERM_CAL_TYPE,CT1.DESCRIPTION, SPAT.TERM_SEQUENCE_NUMBER,CI.START_DT,CI.END_DT,CI.DESCRIPTION,SPAT.KEY_PROGRAM_FLAG, '_LA:KEY_PROGRAM_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING',SPAT.LOCATION_CD, LOC.DESCRIPTION, SPAT.ATTENDANCE_MODE,AM.DESCRIPTION,SPAT.ATTENDANCE_TYPE,ATT.DESCRIPTION,SPAT.FEE_CAT,FC.DESCRIPTION, SPAT.COO_ID,SPAT.CLASS_STANDING_ID,PCS.CLASS_STANDING,'_DF:IGS:IGS_EN_SPA_TERMS_FLEX:SPAT',SPAT.CREATED_BY, SPAT.CREATION_DATE,SPAT.LAST_UPDATED_BY,SPAT.LAST_UPDATE_DATE FROM IGS_EN_SPA_TERMS SPAT, HZ_PARTIES HP, IGS_PS_VER_ALL PV, IGS_CA_INST_ALL CI, IGS_CA_TYPE CT, IGS_CA_TYPE CT1, IGS_AD_LOCATION_ALL LOC, IGS_EN_ATD_MODE_ALL AM, IGS_EN_ATD_TYPE_ALL ATT, IGS_FI_FEE_CAT_ALL FC, IGS_PR_CLASS_STD PCS WHERE SPAT.PERSON_ID = HP.PARTY_ID AND SPAT.PROGRAM_CD = PV.COURSE_CD AND SPAT.PROGRAM_VERSION = PV.VERSION_NUMBER AND SPAT.ACAD_CAL_TYPE = CT.CAL_TYPE AND SPAT.TERM_CAL_TYPE = CT1.CAL_TYPE AND SPAT.TERM_CAL_TYPE = CI.CAL_TYPE AND SPAT.TERM_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND SPAT.LOCATION_CD = LOC.LOCATION_CD AND SPAT.ATTENDANCE_MODE = AM.ATTENDANCE_MODE AND SPAT.ATTENDANCE_TYPE = ATT.ATTENDANCE_TYPE AND SPAT.FEE_CAT = FC.FEE_CAT(+) AND SPAT.CLASS_STANDING_ID = PCS.IGS_PR_CLASS_STD_ID(+) WITH READ ONLY

View Text - HTML Formatted

SELECT SPAT.TERM_RECORD_ID
, SPAT.PERSON_ID
, HP.PARTY_NUMBER
, HP.PARTY_NAME
, SPAT.PROGRAM_CD
, SPAT.PROGRAM_VERSION
, PV.TITLE
, SPAT.ACAD_CAL_TYPE
, CT.DESCRIPTION
, SPAT.TERM_CAL_TYPE
, CT1.DESCRIPTION
, SPAT.TERM_SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.DESCRIPTION
, SPAT.KEY_PROGRAM_FLAG
, '_LA:KEY_PROGRAM_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, SPAT.LOCATION_CD
, LOC.DESCRIPTION
, SPAT.ATTENDANCE_MODE
, AM.DESCRIPTION
, SPAT.ATTENDANCE_TYPE
, ATT.DESCRIPTION
, SPAT.FEE_CAT
, FC.DESCRIPTION
, SPAT.COO_ID
, SPAT.CLASS_STANDING_ID
, PCS.CLASS_STANDING
, '_DF:IGS:IGS_EN_SPA_TERMS_FLEX:SPAT'
, SPAT.CREATED_BY
, SPAT.CREATION_DATE
, SPAT.LAST_UPDATED_BY
, SPAT.LAST_UPDATE_DATE
FROM IGS_EN_SPA_TERMS SPAT
, HZ_PARTIES HP
, IGS_PS_VER_ALL PV
, IGS_CA_INST_ALL CI
, IGS_CA_TYPE CT
, IGS_CA_TYPE CT1
, IGS_AD_LOCATION_ALL LOC
, IGS_EN_ATD_MODE_ALL AM
, IGS_EN_ATD_TYPE_ALL ATT
, IGS_FI_FEE_CAT_ALL FC
, IGS_PR_CLASS_STD PCS
WHERE SPAT.PERSON_ID = HP.PARTY_ID
AND SPAT.PROGRAM_CD = PV.COURSE_CD
AND SPAT.PROGRAM_VERSION = PV.VERSION_NUMBER
AND SPAT.ACAD_CAL_TYPE = CT.CAL_TYPE
AND SPAT.TERM_CAL_TYPE = CT1.CAL_TYPE
AND SPAT.TERM_CAL_TYPE = CI.CAL_TYPE
AND SPAT.TERM_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND SPAT.LOCATION_CD = LOC.LOCATION_CD
AND SPAT.ATTENDANCE_MODE = AM.ATTENDANCE_MODE
AND SPAT.ATTENDANCE_TYPE = ATT.ATTENDANCE_TYPE
AND SPAT.FEE_CAT = FC.FEE_CAT(+)
AND SPAT.CLASS_STANDING_ID = PCS.IGS_PR_CLASS_STD_ID(+) WITH READ ONLY