VIEW: APPS.IGS_EN_INST_WLST_OPT_V

Source

View Text - Preformatted

SELECT iwo.rowid row_id, iwo.inst_waitlist_id inst_waitlist_id, iwo.cal_type cal_type, NULL sequence_number, ct.description, NULL, NULL, NULL, iwo.waitlist_alwd waitlist_alwd, iwo.smlnes_waitlist_alwd smlnes_waitlist_alwd, iwo.created_by created_by, iwo.creation_date creation_date, iwo.last_updated_by last_updated_by, iwo.last_update_date last_update_date, iwo.last_update_login last_update_login FROM igs_ca_type ct, igs_en_inst_wlst_opt iwo WHERE iwo.cal_type = ct.cal_type AND ct.s_cal_cat = 'LOAD'

View Text - HTML Formatted

SELECT IWO.ROWID ROW_ID
, IWO.INST_WAITLIST_ID INST_WAITLIST_ID
, IWO.CAL_TYPE CAL_TYPE
, NULL SEQUENCE_NUMBER
, CT.DESCRIPTION
, NULL
, NULL
, NULL
, IWO.WAITLIST_ALWD WAITLIST_ALWD
, IWO.SMLNES_WAITLIST_ALWD SMLNES_WAITLIST_ALWD
, IWO.CREATED_BY CREATED_BY
, IWO.CREATION_DATE CREATION_DATE
, IWO.LAST_UPDATED_BY LAST_UPDATED_BY
, IWO.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IWO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_CA_TYPE CT
, IGS_EN_INST_WLST_OPT IWO
WHERE IWO.CAL_TYPE = CT.CAL_TYPE
AND CT.S_CAL_CAT = 'LOAD'