[Home] [Help]
View: IGS_EN_USEC_STAT_DSP_V
Product: | IGS - Student System (Obsolete) |
Description: | Contains the Unit section statuses what are to be displayed to the self service user for enrollment based on whether displayed is set to yes/no. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT USTAT.ROWID ROW_ID
, LKUP.LOOKUP_CODE
, LKUP.MEANING
, NVL(USTAT.DISPLAYED
, 'N')
, USTAT.CREATED_BY
, USTAT.CREATION_DATE
, USTAT.LAST_UPDATED_BY
, USTAT.LAST_UPDATE_DATE
, USTAT.LAST_UPDATE_LOGIN
FROM IGS_EN_USEC_STAT_DSP USTAT
, IGS_LOOKUPS_VIEW LKUP
WHERE LKUP.LOOKUP_CODE = USTAT.UNIT_SECTION_STATUS(+)
AND LKUP.LOOKUP_TYPE = 'UNIT_SECTION_STATUS'
Columns
Name |
ROW_ID |
UNIT_SECTION_STATUS |
MEANING |
DISPLAYED |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |