[Home] [Help]
View: IGS_AD_INQ_PROG_UNIT_SETS_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | This view contains all the inquiry program unit sets - Obsolete |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT IPU.ROWID
, IPU.INQ_PROG_UNIT_SET_ID
, IPU.INQ_PROG_CODE_ID
, IPU.INQ_UNIT_SET_CODE_ID
, IU.INQ_UNIT_SET_CODE
, IU.DESCRIPTION
, IPU.CLOSED_IND
, IPU.CREATED_BY
, IPU.CREATION_DATE
, IPU.LAST_UPDATED_BY
, IPU.LAST_UPDATE_DATE
, IPU.LAST_UPDATE_LOGIN
FROM IGS_AD_I_PRG_U_SET IPU
, IGS_AD_INQ_UNIT_SETS IU
WHERE IPU.INQ_UNIT_SET_CODE_ID = IU. INQ_UNIT_SET_CODE_ID
Columns
| Name |
| ROW_ID |
| INQ_PROG_UNIT_SET_ID |
| INQ_PROG_CODE_ID |
| INQ_UNIT_SET_CODE_ID |
| INQ_UNIT_SET_CODE |
| UNIT_SET_CODE_DESCRIPTION |
| CLOSED_IND |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |