VIEW: APPS.IGS_AS_EXM_SES_VN_SP_V

Source

View Text - Preformatted

SELECT ESV.ROWID ROW_ID, PV.PERSON_NUMBER PERSON_NUMBER, ESV.PERSON_ID PERSON_ID, ESV.EXAM_CAL_TYPE EXAM_CAL_TYPE, ESV.EXAM_CI_SEQUENCE_NUMBER EXAM_CI_SEQUENCE_NUMBER, ESV.DT_ALIAS DT_ALIAS, ESV.DAI_SEQUENCE_NUMBER DAI_SEQUENCE_NUMBER, ESV.START_TIME START_TIME, ESV.END_TIME END_TIME, ESV.ESE_ID ESE_ID, ESV.VENUE_CD VENUE_CD, ESV.EXAM_SUPERVISOR_TYPE EXAM_SUPERVISOR_TYPE, ESV.OVERRIDE_START_TIME OVERRIDE_START_TIME, ESV.OVERRIDE_END_TIME OVERRIDE_END_TIME, ESV.CREATED_BY CREATED_BY, ESV.CREATION_DATE CREATION_DATE, ESV.LAST_UPDATED_BY LAST_UPDATED_BY, ESV.LAST_UPDATE_DATE LAST_UPDATE_DATE, ESV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_AS_EXM_SES_VN_SP ESV, IGS_PE_PERSON_V PV WHERE ESV.PERSON_ID = PV.PERSON_ID

View Text - HTML Formatted

SELECT ESV.ROWID ROW_ID
, PV.PERSON_NUMBER PERSON_NUMBER
, ESV.PERSON_ID PERSON_ID
, ESV.EXAM_CAL_TYPE EXAM_CAL_TYPE
, ESV.EXAM_CI_SEQUENCE_NUMBER EXAM_CI_SEQUENCE_NUMBER
, ESV.DT_ALIAS DT_ALIAS
, ESV.DAI_SEQUENCE_NUMBER DAI_SEQUENCE_NUMBER
, ESV.START_TIME START_TIME
, ESV.END_TIME END_TIME
, ESV.ESE_ID ESE_ID
, ESV.VENUE_CD VENUE_CD
, ESV.EXAM_SUPERVISOR_TYPE EXAM_SUPERVISOR_TYPE
, ESV.OVERRIDE_START_TIME OVERRIDE_START_TIME
, ESV.OVERRIDE_END_TIME OVERRIDE_END_TIME
, ESV.CREATED_BY CREATED_BY
, ESV.CREATION_DATE CREATION_DATE
, ESV.LAST_UPDATED_BY LAST_UPDATED_BY
, ESV.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ESV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AS_EXM_SES_VN_SP ESV
, IGS_PE_PERSON_V PV
WHERE ESV.PERSON_ID = PV.PERSON_ID