VIEW: APPS.IGS_PS_FACLTY_UNIT_V

Source

View Text - Preformatted

SELECT DISTINCT fds.rowid row_id, fds.displn_unit_id displn_unit_id, fds.displn_unit_cd displn_unit_cd, fds.person_id person_id, fds.displn_unit_type displn_unit_type, unt.title description, fds.created_by created_by, fds.creation_date creation_date, fds.last_updated_by last_updated_by, fds.last_update_date last_update_date, fds.last_update_login last_update_login FROM igs_ps_faclty_disp fds, igs_ps_unit_ver unt WHERE fds.displn_unit_cd = unt.unit_cd and fds.displn_unit_type = 'UNIT'

View Text - HTML Formatted

SELECT DISTINCT FDS.ROWID ROW_ID
, FDS.DISPLN_UNIT_ID DISPLN_UNIT_ID
, FDS.DISPLN_UNIT_CD DISPLN_UNIT_CD
, FDS.PERSON_ID PERSON_ID
, FDS.DISPLN_UNIT_TYPE DISPLN_UNIT_TYPE
, UNT.TITLE DESCRIPTION
, FDS.CREATED_BY CREATED_BY
, FDS.CREATION_DATE CREATION_DATE
, FDS.LAST_UPDATED_BY LAST_UPDATED_BY
, FDS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, FDS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_FACLTY_DISP FDS
, IGS_PS_UNIT_VER UNT
WHERE FDS.DISPLN_UNIT_CD = UNT.UNIT_CD
AND FDS.DISPLN_UNIT_TYPE = 'UNIT'