VIEW: APPS.IGS_EN_TIMESLOT_STUP_V

Source

View Text - Preformatted

SELECT ets.rowid row_id, ets.org_id org_id, ets.igs_en_timeslot_stup_id igs_en_timeslot_stup_id, ets.program_type_group_cd program_type_group_cd, ptg.description program_type_group, ets.cal_type cal_type, ct.description cal_type_desc, ets.sequence_number sequence_number, ci.alternate_code alternate_cd, ci.start_dt start_dt, ci.end_dt end_dt, ets.student_type student_type, lkup.meaning student_type_meaning, ets.surname_alphabet surname_alphabet, ets.assign_randomly assign_randomly, ets.created_by created_by, ets.creation_date creation_date, ets.last_updated_by last_updated_by, ets.last_update_date last_update_date, ets.last_update_login last_update_login FROM igs_ca_type ct, igs_ca_inst ci, igs_ps_type_grp ptg, igs_lookups_view lkup, igs_en_timeslot_stup ets WHERE ets.cal_type = ci.cal_type AND ets.sequence_number = ci.sequence_number AND ets.program_type_group_cd = ptg.course_type_group_cd AND (lkup.lookup_type = 'TIMESLOT_STUDENT_TYPE' AND ets.student_type = lkup.lookup_code) AND ct.cal_type = ci.cal_type AND ci.cal_status in ('ACTIVE','PLANNED') AND ct.s_cal_cat IN ( 'TEACHING','LOAD') AND NVL (ets.org_id , NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

View Text - HTML Formatted

SELECT ETS.ROWID ROW_ID
, ETS.ORG_ID ORG_ID
, ETS.IGS_EN_TIMESLOT_STUP_ID IGS_EN_TIMESLOT_STUP_ID
, ETS.PROGRAM_TYPE_GROUP_CD PROGRAM_TYPE_GROUP_CD
, PTG.DESCRIPTION PROGRAM_TYPE_GROUP
, ETS.CAL_TYPE CAL_TYPE
, CT.DESCRIPTION CAL_TYPE_DESC
, ETS.SEQUENCE_NUMBER SEQUENCE_NUMBER
, CI.ALTERNATE_CODE ALTERNATE_CD
, CI.START_DT START_DT
, CI.END_DT END_DT
, ETS.STUDENT_TYPE STUDENT_TYPE
, LKUP.MEANING STUDENT_TYPE_MEANING
, ETS.SURNAME_ALPHABET SURNAME_ALPHABET
, ETS.ASSIGN_RANDOMLY ASSIGN_RANDOMLY
, ETS.CREATED_BY CREATED_BY
, ETS.CREATION_DATE CREATION_DATE
, ETS.LAST_UPDATED_BY LAST_UPDATED_BY
, ETS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ETS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_CA_TYPE CT
, IGS_CA_INST CI
, IGS_PS_TYPE_GRP PTG
, IGS_LOOKUPS_VIEW LKUP
, IGS_EN_TIMESLOT_STUP ETS
WHERE ETS.CAL_TYPE = CI.CAL_TYPE
AND ETS.SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND ETS.PROGRAM_TYPE_GROUP_CD = PTG.COURSE_TYPE_GROUP_CD
AND (LKUP.LOOKUP_TYPE = 'TIMESLOT_STUDENT_TYPE'
AND ETS.STUDENT_TYPE = LKUP.LOOKUP_CODE)
AND CT.CAL_TYPE = CI.CAL_TYPE
AND CI.CAL_STATUS IN ('ACTIVE'
, 'PLANNED')
AND CT.S_CAL_CAT IN ( 'TEACHING'
, 'LOAD')
AND NVL (ETS.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)