FND Design Data [Home] [Help]

View: IGS_PS_FACLTY_UNIT_V

Product: IGS - Student System (Obsolete)
Description:
Implementation/DBA Data: Not implemented in this database
View Text

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'

Columns

Name
ROW_ID
DISPLN_UNIT_ID
DISPLN_UNIT_CD
PERSON_ID
DISPLN_UNIT_TYPE
DESCRIPTION
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN