VIEW: APPS.IGF_AP_ATTEND_MAP_V

Source

View Text - Preformatted

SELECT ATMMV.ROW_ID, ATMMV.ATM_ID, ATMMV.ATTENDANCE_TYPE, ATMMV.PELL_ATT_CODE, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_RFMS_ENROL_STAT', ATMMV.PELL_ATT_CODE), ATMMV.CL_ATT_CODE, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_ENROL_STATUS', ATMMV.CL_ATT_CODE), ATMMV.AP_ATT_CODE, IGF_AW_GEN.LOOKUP_DESC('IGF_AP_ENRL_STAT', ATMMV.AP_ATT_CODE), ATMMV.CREATED_BY, ATMMV.CREATION_DATE, ATMMV.LAST_UPDATED_BY, ATMMV.LAST_UPDATE_DATE, ATMMV.LAST_UPDATE_LOGIN, ATMMV.ORG_ID, ATMMV.CAL_TYPE, ATMMV.SEQUENCE_NUMBER, CA.ALTERNATE_CODE, CA.START_DT, CA.END_DT FROM IGF_AP_ATTEND_MAP ATMMV, IGS_CA_INST CA WHERE CA.CAL_TYPE = ATMMV.CAL_TYPE AND CA.SEQUENCE_NUMBER = ATMMV.SEQUENCE_NUMBER

View Text - HTML Formatted

SELECT ATMMV.ROW_ID
, ATMMV.ATM_ID
, ATMMV.ATTENDANCE_TYPE
, ATMMV.PELL_ATT_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_RFMS_ENROL_STAT'
, ATMMV.PELL_ATT_CODE)
, ATMMV.CL_ATT_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_ENROL_STATUS'
, ATMMV.CL_ATT_CODE)
, ATMMV.AP_ATT_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_AP_ENRL_STAT'
, ATMMV.AP_ATT_CODE)
, ATMMV.CREATED_BY
, ATMMV.CREATION_DATE
, ATMMV.LAST_UPDATED_BY
, ATMMV.LAST_UPDATE_DATE
, ATMMV.LAST_UPDATE_LOGIN
, ATMMV.ORG_ID
, ATMMV.CAL_TYPE
, ATMMV.SEQUENCE_NUMBER
, CA.ALTERNATE_CODE
, CA.START_DT
, CA.END_DT
FROM IGF_AP_ATTEND_MAP ATMMV
, IGS_CA_INST CA
WHERE CA.CAL_TYPE = ATMMV.CAL_TYPE
AND CA.SEQUENCE_NUMBER = ATMMV.SEQUENCE_NUMBER