VIEW: APPS.IGS_EN_STDNT_PS_ATT_V

Source

View Text - Preformatted

SELECT IGS.ROWID ROW_ID, IGS.PERSON_ID, PEV.PERSON_NUMBER, IGS.COURSE_CD, IGS.VERSION_NUMBER, IGS.CAL_TYPE, IGS.LOCATION_CD, IGS.ATTENDANCE_MODE, IGS.ATTENDANCE_TYPE, IGS.COURSE_ATTEMPT_STATUS, IGS.CREATED_BY, IGS.CREATION_DATE, IGS.LAST_UPDATED_BY, IGS.LAST_UPDATE_DATE, IGS.LAST_UPDATE_LOGIN, LKUP.FEE_ASS_IND, IGS.FEE_CAT, FCAT.CURRENCY_CD CURRENCY_CD FROM IGS_EN_STDNT_PS_ATT IGS, igs_pe_person_base_v pev, IGS_LOOKUPS_VIEW LKUP , IGS_FI_FEE_CAT FCAT WHERE (IGS.COURSE_ATTEMPT_STATUS = LKUP.LOOKUP_CODE OR IGS.COURSE_ATTEMPT_STATUS IS NULL) AND LKUP.LOOKUP_TYPE = 'CRS_ATTEMPT_STATUS' AND IGS.FEE_CAT = FCAT.FEE_CAT(+) AND igs.person_id = pev.person_id

View Text - HTML Formatted

SELECT IGS.ROWID ROW_ID
, IGS.PERSON_ID
, PEV.PERSON_NUMBER
, IGS.COURSE_CD
, IGS.VERSION_NUMBER
, IGS.CAL_TYPE
, IGS.LOCATION_CD
, IGS.ATTENDANCE_MODE
, IGS.ATTENDANCE_TYPE
, IGS.COURSE_ATTEMPT_STATUS
, IGS.CREATED_BY
, IGS.CREATION_DATE
, IGS.LAST_UPDATED_BY
, IGS.LAST_UPDATE_DATE
, IGS.LAST_UPDATE_LOGIN
, LKUP.FEE_ASS_IND
, IGS.FEE_CAT
, FCAT.CURRENCY_CD CURRENCY_CD
FROM IGS_EN_STDNT_PS_ATT IGS
, IGS_PE_PERSON_BASE_V PEV
, IGS_LOOKUPS_VIEW LKUP
, IGS_FI_FEE_CAT FCAT
WHERE (IGS.COURSE_ATTEMPT_STATUS = LKUP.LOOKUP_CODE OR IGS.COURSE_ATTEMPT_STATUS IS NULL)
AND LKUP.LOOKUP_TYPE = 'CRS_ATTEMPT_STATUS'
AND IGS.FEE_CAT = FCAT.FEE_CAT(+)
AND IGS.PERSON_ID = PEV.PERSON_ID