VIEW: APPS.IGS_AS_ESE_VENUE_V

Source

View Text - Preformatted

SELECT DISTINCT ei.exam_cal_type, ei.exam_ci_sequence_number, ei.dt_alias, ei.dai_sequence_number, IGS_CA_GEN_001.calp_get_alias_val(ei.dt_alias,ei.dai_sequence_number,ei.exam_cal_type,ei.exam_ci_sequence_number), ei.start_time, ei.end_time, ei.ese_id, ei.venue_cd, ve.exam_location_cd, ese.exam_session_number, ei.created_by, ei.creation_date, ei.last_updated_by, ei.last_update_date, ei.last_update_login FROM IGS_AS_EXAM_INSTANCE ei, IGS_AS_EXAM_SESSION ese, IGS_GR_VENUE ve WHERE ei.ese_id = ese.ese_id AND ei.venue_cd = ve.venue_cd

View Text - HTML Formatted

SELECT DISTINCT EI.EXAM_CAL_TYPE
, EI.EXAM_CI_SEQUENCE_NUMBER
, EI.DT_ALIAS
, EI.DAI_SEQUENCE_NUMBER
, IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(EI.DT_ALIAS
, EI.DAI_SEQUENCE_NUMBER
, EI.EXAM_CAL_TYPE
, EI.EXAM_CI_SEQUENCE_NUMBER)
, EI.START_TIME
, EI.END_TIME
, EI.ESE_ID
, EI.VENUE_CD
, VE.EXAM_LOCATION_CD
, ESE.EXAM_SESSION_NUMBER
, EI.CREATED_BY
, EI.CREATION_DATE
, EI.LAST_UPDATED_BY
, EI.LAST_UPDATE_DATE
, EI.LAST_UPDATE_LOGIN
FROM IGS_AS_EXAM_INSTANCE EI
, IGS_AS_EXAM_SESSION ESE
, IGS_GR_VENUE VE
WHERE EI.ESE_ID = ESE.ESE_ID
AND EI.VENUE_CD = VE.VENUE_CD