VIEW: APPS.IGS_PE_USR_ARG

Source

View Text - Preformatted

SELECT uarg.rowid ROW_ID, uarg.usr_act_re_gs_id USR_ACT_RE_GS_ID, uarg.person_type PERSON_TYPE, uarg.record_open_dt_alias RECORD_OPEN_DT_ALIAS, cdv1.description RECORD_OPEN_DT_ALIAS_DESC, uarg.record_cutoff_dt_alias RECORD_CUTOFF_DT_ALIAS, cdv2.description RECORD_CUTOFF_DT_ALIAS_DESC, uarg.grad_sch_dt_alias GRAD_SCH_DT_ALIAS, cdv3.description GRAD_SCH_DT_ALIAS_DESC, uarg.upd_audit_dt_alias UPD_AUDIT_DT_ALIAS, cdv4.description UPD_AUDIT_DT_ALIAS_DESC, uarg.created_by CREATED_BY, uarg.creation_date CREATION_DATE, uarg.last_updated_by LAST_UPDATED_BY, uarg.last_update_date LAST_UPDATE_DATE, uarg.last_update_login LAST_UPDATE_LOGIN FROM IGS_PE_USR_ARG_ALL uarg, igs_ca_da_v cdv1, igs_ca_da_v cdv2, igs_ca_da_v cdv3, igs_ca_da_v cdv4 WHERE uarg.record_open_dt_alias = cdv1.dt_alias (+) AND uarg.record_cutoff_dt_alias = cdv2.dt_alias (+) AND uarg.grad_sch_dt_alias = cdv3.dt_alias (+) AND uarg.upd_audit_dt_alias = cdv4.dt_alias (+) AND (NVL (uarg.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 UARG.ROWID ROW_ID
, UARG.USR_ACT_RE_GS_ID USR_ACT_RE_GS_ID
, UARG.PERSON_TYPE PERSON_TYPE
, UARG.RECORD_OPEN_DT_ALIAS RECORD_OPEN_DT_ALIAS
, CDV1.DESCRIPTION RECORD_OPEN_DT_ALIAS_DESC
, UARG.RECORD_CUTOFF_DT_ALIAS RECORD_CUTOFF_DT_ALIAS
, CDV2.DESCRIPTION RECORD_CUTOFF_DT_ALIAS_DESC
, UARG.GRAD_SCH_DT_ALIAS GRAD_SCH_DT_ALIAS
, CDV3.DESCRIPTION GRAD_SCH_DT_ALIAS_DESC
, UARG.UPD_AUDIT_DT_ALIAS UPD_AUDIT_DT_ALIAS
, CDV4.DESCRIPTION UPD_AUDIT_DT_ALIAS_DESC
, UARG.CREATED_BY CREATED_BY
, UARG.CREATION_DATE CREATION_DATE
, UARG.LAST_UPDATED_BY LAST_UPDATED_BY
, UARG.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UARG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PE_USR_ARG_ALL UARG
, IGS_CA_DA_V CDV1
, IGS_CA_DA_V CDV2
, IGS_CA_DA_V CDV3
, IGS_CA_DA_V CDV4
WHERE UARG.RECORD_OPEN_DT_ALIAS = CDV1.DT_ALIAS (+)
AND UARG.RECORD_CUTOFF_DT_ALIAS = CDV2.DT_ALIAS (+)
AND UARG.GRAD_SCH_DT_ALIAS = CDV3.DT_ALIAS (+)
AND UARG.UPD_AUDIT_DT_ALIAS = CDV4.DT_ALIAS (+)
AND (NVL (UARG.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) )