VIEW: APPS.IGS_AS_STD_EXM_INSTN_V

Source

View Text - Preformatted

SELECT SE.ROWID ROW_ID, P.PARTY_NUMBER PERSON_NUMBER, SE.ASS_ID ASS_ID, SE.EXAM_CAL_TYPE EXAM_CAL_TYPE, SE.EXAM_CI_SEQUENCE_NUMBER EXAM_CI_SEQUENCE_NUMBER, SE.DT_ALIAS DT_ALIAS, SE.DAI_SEQUENCE_NUMBER DAI_SEQUENCE_NUMBER, SE.START_TIME START_TIME, SE.END_TIME END_TIME, SE.ESE_ID ESE_ID, SE.VENUE_CD VENUE_CD, SE.PERSON_ID PERSON_ID, SE.COURSE_CD COURSE_CD, SE.UNIT_CD UNIT_CD, SE.CAL_TYPE CAL_TYPE, SE.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER, SE.CREATION_DT CREATION_DT, SE.ATTENDANCE_IND ATTENDANCE_IND, SE.TIMESLOT TIMESLOT, SE.TIMESLOT_DURATION TIMESLOT_DURATION, SE.SEAT_NUMBER SEAT_NUMBER, SE.CREATED_BY CREATED_BY, SE.CREATION_DATE CREATION_DATE, SE.LAST_UPDATED_BY LAST_UPDATED_BY, SE.LAST_UPDATE_DATE LAST_UPDATE_DATE, SE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SE.UOO_ID FROM IGS_AS_STD_EXM_INSTN SE, HZ_PARTIES P WHERE SE.PERSON_ID = P.PARTY_ID

View Text - HTML Formatted

SELECT SE.ROWID ROW_ID
, P.PARTY_NUMBER PERSON_NUMBER
, SE.ASS_ID ASS_ID
, SE.EXAM_CAL_TYPE EXAM_CAL_TYPE
, SE.EXAM_CI_SEQUENCE_NUMBER EXAM_CI_SEQUENCE_NUMBER
, SE.DT_ALIAS DT_ALIAS
, SE.DAI_SEQUENCE_NUMBER DAI_SEQUENCE_NUMBER
, SE.START_TIME START_TIME
, SE.END_TIME END_TIME
, SE.ESE_ID ESE_ID
, SE.VENUE_CD VENUE_CD
, SE.PERSON_ID PERSON_ID
, SE.COURSE_CD COURSE_CD
, SE.UNIT_CD UNIT_CD
, SE.CAL_TYPE CAL_TYPE
, SE.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, SE.CREATION_DT CREATION_DT
, SE.ATTENDANCE_IND ATTENDANCE_IND
, SE.TIMESLOT TIMESLOT
, SE.TIMESLOT_DURATION TIMESLOT_DURATION
, SE.SEAT_NUMBER SEAT_NUMBER
, SE.CREATED_BY CREATED_BY
, SE.CREATION_DATE CREATION_DATE
, SE.LAST_UPDATED_BY LAST_UPDATED_BY
, SE.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SE.UOO_ID
FROM IGS_AS_STD_EXM_INSTN SE
, HZ_PARTIES P
WHERE SE.PERSON_ID = P.PARTY_ID