DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IGS_PE_USR_ADISC

Object Details
Object Name: IGS_PE_USR_ADISC
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_PE_USR_ADISC
Subobject Name:
Status: VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.


Obsolete - Describes all the columns related to self service user activity setup for discontinuation date alias


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier for this view
USR_ACT_DISC_ID NUMBER (15) Yes System generated number to uniquely identify the user activity for discontinution
PERSON_TYPE VARCHAR2 (30) Yes Person type
ADMINISTRATIVE_UNIT_STATUS VARCHAR2 (10) Yes Administrative unit status
DESCRIPTION VARCHAR2 (60) Yes Administrative unit status description
DISC_DT_ALIAS VARCHAR2 (10) Yes Discontinuation date alias
DISC_DT_ALIAS_DESC VARCHAR2 (60)
Discontinuation date alias description
CREATED_BY NUMBER (15) Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO column
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      USR_ACT_DISC_ID
,      PERSON_TYPE
,      ADMINISTRATIVE_UNIT_STATUS
,      DESCRIPTION
,      DISC_DT_ALIAS
,      DISC_DT_ALIAS_DESC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_PE_USR_ADISC;

Dependencies

[top of page]

APPS.IGS_PE_USR_ADISC references the following:

SchemaAPPS
ViewIGS_AD_ADM_UNIT_STAT
ViewIGS_CA_DA_V
SynonymIGS_PE_USR_ADISC_ALL

APPS.IGS_PE_USR_ADISC is not referenced by any database object