VIEW: APPS.IGS_AS_MSHT_SU_ATMPT_V

Source

View Text - Preformatted

SELECT MS.ROWID ROW_ID, P.PARTY_NUMBER PERSON_NUMBER, MS.SHEET_NUMBER SHEET_NUMBER, MS.PERSON_ID PERSON_ID, MS.COURSE_CD COURSE_CD, MS.UNIT_CD UNIT_CD, MS.CAL_TYPE CAL_TYPE, MS.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER, MS.LOCATION_CD LOCATION_CD, MS.UNIT_MODE UNIT_MODE, MS.UNIT_CLASS UNIT_CLASS, MS.STUDENT_SEQUENCE STUDENT_SEQUENCE, MS.CREATED_BY CREATED_BY, MS.CREATION_DATE CREATION_DATE, MS.LAST_UPDATED_BY LAST_UPDATED_BY, MS.LAST_UPDATE_DATE LAST_UPDATE_DATE, MS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MS.REQUEST_ID REQUEST_ID, MS.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, MS.PROGRAM_ID PROGRAM_ID, MS.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, MS.UOO_ID FROM IGS_AS_MSHT_SU_ATMPT MS, HZ_PARTIES P WHERE MS.PERSON_ID = P.PARTY_ID

View Text - HTML Formatted

SELECT MS.ROWID ROW_ID
, P.PARTY_NUMBER PERSON_NUMBER
, MS.SHEET_NUMBER SHEET_NUMBER
, MS.PERSON_ID PERSON_ID
, MS.COURSE_CD COURSE_CD
, MS.UNIT_CD UNIT_CD
, MS.CAL_TYPE CAL_TYPE
, MS.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, MS.LOCATION_CD LOCATION_CD
, MS.UNIT_MODE UNIT_MODE
, MS.UNIT_CLASS UNIT_CLASS
, MS.STUDENT_SEQUENCE STUDENT_SEQUENCE
, MS.CREATED_BY CREATED_BY
, MS.CREATION_DATE CREATION_DATE
, MS.LAST_UPDATED_BY LAST_UPDATED_BY
, MS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MS.REQUEST_ID REQUEST_ID
, MS.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, MS.PROGRAM_ID PROGRAM_ID
, MS.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, MS.UOO_ID
FROM IGS_AS_MSHT_SU_ATMPT MS
, HZ_PARTIES P
WHERE MS.PERSON_ID = P.PARTY_ID