VIEW: APPS.IGS_EN_TIMESLOT_REVW_V

Source

View Text - Preformatted

SELECT tsr.rowid row_id, tsr.person_id, tsr.start_dt_time, tsr.end_dt_time, tsp.cal_type, ct.description cal_type_desc, tsp.timeslot_calendar, tsp.ts_mode, lkup.meaning FROM igs_en_timeslot_rslt tsr, igs_ca_type ct, igs_en_timeslot_para tsp, igs_lookups_view lkup WHERE tsp.igs_en_timeslot_para_id = tsr.igs_en_timeslot_para_id and tsp.cal_type = ct.cal_type and (tsp.ts_mode = lkup.lookup_code and lkup.lookup_type = 'TIMESLOT_MODE')

View Text - HTML Formatted

SELECT TSR.ROWID ROW_ID
, TSR.PERSON_ID
, TSR.START_DT_TIME
, TSR.END_DT_TIME
, TSP.CAL_TYPE
, CT.DESCRIPTION CAL_TYPE_DESC
, TSP.TIMESLOT_CALENDAR
, TSP.TS_MODE
, LKUP.MEANING
FROM IGS_EN_TIMESLOT_RSLT TSR
, IGS_CA_TYPE CT
, IGS_EN_TIMESLOT_PARA TSP
, IGS_LOOKUPS_VIEW LKUP
WHERE TSP.IGS_EN_TIMESLOT_PARA_ID = TSR.IGS_EN_TIMESLOT_PARA_ID
AND TSP.CAL_TYPE = CT.CAL_TYPE
AND (TSP.TS_MODE = LKUP.LOOKUP_CODE
AND LKUP.LOOKUP_TYPE = 'TIMESLOT_MODE')