VIEW: APPS.IGS_AS_ESE_EXMVNUS_UNAVLBL_V

Source

View Text - Preformatted

SELECT ve.venue_cd, ese.exam_cal_type, ese.exam_ci_sequence_number, ese.dt_alias, ese.dai_sequence_number, ese.exam_session_number, IGS_CA_GEN_001.calp_get_alias_val(ese.dt_alias,ese.dai_sequence_number,ese.exam_cal_type,ese.exam_ci_sequence_number), ese.start_time, ese.end_time, ese.ese_id, ese.created_by, ese.creation_date, ese.last_updated_by, ese.last_update_date, ese.last_update_login FROM IGS_GR_VENUE ve, IGS_AS_EXAM_SESSION ese WHERE ve.closed_ind = 'N' AND EXISTS (SELECT location_cd FROM IGS_AD_LOCATION loc, IGS_AD_LOCATION_TYPE lt WHERE loc.location_cd = ve.exam_location_cd AND lt.location_type = loc.location_type AND lt.s_location_type = 'EXAM_CTR' ) AND NOT EXISTS (SELECT ese_id FROM IGS_AS_EXMVNU_SESAVL WHERE venue_cd = ve.venue_cd AND ese_id = ese.ese_id )

View Text - HTML Formatted

SELECT VE.VENUE_CD
, ESE.EXAM_CAL_TYPE
, ESE.EXAM_CI_SEQUENCE_NUMBER
, ESE.DT_ALIAS
, ESE.DAI_SEQUENCE_NUMBER
, ESE.EXAM_SESSION_NUMBER
, IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(ESE.DT_ALIAS
, ESE.DAI_SEQUENCE_NUMBER
, ESE.EXAM_CAL_TYPE
, ESE.EXAM_CI_SEQUENCE_NUMBER)
, ESE.START_TIME
, ESE.END_TIME
, ESE.ESE_ID
, ESE.CREATED_BY
, ESE.CREATION_DATE
, ESE.LAST_UPDATED_BY
, ESE.LAST_UPDATE_DATE
, ESE.LAST_UPDATE_LOGIN
FROM IGS_GR_VENUE VE
, IGS_AS_EXAM_SESSION ESE
WHERE VE.CLOSED_IND = 'N'
AND EXISTS (SELECT LOCATION_CD
FROM IGS_AD_LOCATION LOC
, IGS_AD_LOCATION_TYPE LT
WHERE LOC.LOCATION_CD = VE.EXAM_LOCATION_CD
AND LT.LOCATION_TYPE = LOC.LOCATION_TYPE
AND LT.S_LOCATION_TYPE = 'EXAM_CTR' )
AND NOT EXISTS (SELECT ESE_ID
FROM IGS_AS_EXMVNU_SESAVL
WHERE VENUE_CD = VE.VENUE_CD
AND ESE_ID = ESE.ESE_ID )