View: IGS_PE_USR_ADISC

Product:	IGS - Student System
Description:	Obsolete - Describes all the columns related to self service user activity setup for discontinuation date alias
Implementation/DBA Data:	APPS.IGS_PE_USR_ADISC

View Text

SELECT UAD.ROWID ROW_ID
, UAD.USR_ACT_DISC_ID USR_ACT_DISC_ID
, UAD.PERSON_TYPE PERSON_TYPE
, UAD.ADMINISTRATIVE_UNIT_STATUS ADMINISTRATIVE_UNIT_STATUS
, AUS.DESCRIPTION DESCRIPTION
, UAD.DISC_DT_ALIAS DISC_DT_ALIAS
, CDV.DESCRIPTION DISC_DT_ALIAS_DESC
, UAD.CREATED_BY CREATED_BY
, UAD.CREATION_DATE CREATION_DATE
, UAD.LAST_UPDATED_BY LAST_UPDATED_BY
, UAD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UAD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PE_USR_ADISC_ALL UAD
, IGS_AD_ADM_UNIT_STAT AUS
, IGS_CA_DA_V CDV
WHERE UAD.ADMINISTRATIVE_UNIT_STATUS = AUS. ADMINISTRATIVE_UNIT_STATUS
AND UAD.DISC_DT_ALIAS = CDV.DT_ALIAS
AND (NVL (UAD.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