View: IGS_EN_INST_WLST_OPT

Product:	IGS - Student System
Description:	This view holds all the institution specific wait list options.
Implementation/DBA Data:	APPS.IGS_EN_INST_WLST_OPT

View Text

SELECT ROWID ROW_ID
, ORG_ID
, INST_WAITLIST_ID
, CAL_TYPE
, SEQUENCE_NUMBER
, WAITLIST_ALWD
, SMLNES_WAITLIST_ALWD
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS_EN_INST_WLST_OPT_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB( USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) =NVL(TO_NUMBER(DECODE(SUBSTRB( USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns