VIEW: APPS.IGS_PS_FACLTY_DEGRS_V

Source

View Text - Preformatted

SELECT fd.rowid row_id, fd.faclty_degrd_id faclty_degrd_id, fd.degree_cd degree_cd, pd.description description, fd.person_id person_id, fd.program program, fd.institution_cd institution_cd, ins.name institution_name, fd.degree_date degree_date, fd.created_by created_by, fd.creation_date creation_date, fd.last_updated_by last_updated_by, fd.last_update_date last_update_date, fd.last_update_login last_update_login FROM igs_ps_faclty_degrs fd, igs_or_institution ins, igs_ps_degrees pd WHERE fd.institution_cd = ins.institution_cd AND fd.degree_cd = pd.degree_cd

View Text - HTML Formatted

SELECT FD.ROWID ROW_ID
, FD.FACLTY_DEGRD_ID FACLTY_DEGRD_ID
, FD.DEGREE_CD DEGREE_CD
, PD.DESCRIPTION DESCRIPTION
, FD.PERSON_ID PERSON_ID
, FD.PROGRAM PROGRAM
, FD.INSTITUTION_CD INSTITUTION_CD
, INS.NAME INSTITUTION_NAME
, FD.DEGREE_DATE DEGREE_DATE
, FD.CREATED_BY CREATED_BY
, FD.CREATION_DATE CREATION_DATE
, FD.LAST_UPDATED_BY LAST_UPDATED_BY
, FD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, FD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_FACLTY_DEGRS FD
, IGS_OR_INSTITUTION INS
, IGS_PS_DEGREES PD
WHERE FD.INSTITUTION_CD = INS.INSTITUTION_CD
AND FD.DEGREE_CD = PD.DEGREE_CD