VIEW: APPS.IGS_PE_USR_ADISC

Source

View Text - Preformatted

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) )

View Text - HTML Formatted

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) )