VIEW: APPS.IGS_EN_TIMESLOT_PARA_V

Source

View Text - Preformatted

SELECT tsp.rowid , tsp.igs_en_timeslot_para_id, tsp.program_type_group_cd, ptg.description , tsp.cal_type, tsp.sequence_number, tsp.timeslot_calendar, tsp.timeslot_st_time, tsp.timeslot_end_time , ct.description , ci.start_dt, ci.end_dt, tsp.student_type, lkup.meaning , tsp.ts_mode, tsp.max_head_count, tsp.length_of_time, tsp.created_by, tsp.creation_date, tsp.last_updated_by, tsp.last_update_date, tsp.last_update_login, tsp.ORG_ID FROM igs_en_timeslot_para tsp, igs_ca_inst ci, igs_ca_type ct, igs_ps_type_grp ptg, igs_lookups_view lkup WHERE tsp.cal_type = ci.cal_type AND tsp.sequence_number = ci.sequence_number AND ci.cal_type = ct.cal_type AND tsp.program_type_group_cd = ptg.course_type_group_cd AND (lkup.lookup_type = 'TIMESLOT_STUDENT_TYPE' AND tsp.student_type = lkup.lookup_code) AND NVL(tsp.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 TSP.ROWID
, TSP.IGS_EN_TIMESLOT_PARA_ID
, TSP.PROGRAM_TYPE_GROUP_CD
, PTG.DESCRIPTION
, TSP.CAL_TYPE
, TSP.SEQUENCE_NUMBER
, TSP.TIMESLOT_CALENDAR
, TSP.TIMESLOT_ST_TIME
, TSP.TIMESLOT_END_TIME
, CT.DESCRIPTION
, CI.START_DT
, CI.END_DT
, TSP.STUDENT_TYPE
, LKUP.MEANING
, TSP.TS_MODE
, TSP.MAX_HEAD_COUNT
, TSP.LENGTH_OF_TIME
, TSP.CREATED_BY
, TSP.CREATION_DATE
, TSP.LAST_UPDATED_BY
, TSP.LAST_UPDATE_DATE
, TSP.LAST_UPDATE_LOGIN
, TSP.ORG_ID
FROM IGS_EN_TIMESLOT_PARA TSP
, IGS_CA_INST CI
, IGS_CA_TYPE CT
, IGS_PS_TYPE_GRP PTG
, IGS_LOOKUPS_VIEW LKUP
WHERE TSP.CAL_TYPE = CI.CAL_TYPE
AND TSP.SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND CI.CAL_TYPE = CT.CAL_TYPE
AND TSP.PROGRAM_TYPE_GROUP_CD = PTG.COURSE_TYPE_GROUP_CD
AND (LKUP.LOOKUP_TYPE = 'TIMESLOT_STUDENT_TYPE'
AND TSP.STUDENT_TYPE = LKUP.LOOKUP_CODE)
AND NVL(TSP.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)