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

VIEW: APPS.IGS_DA_PURGE_V

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

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view is to give the user information into all the degree audit requests that were made and purged from the system. The information will be saved as each request has been purged. --Obsolete


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
rowid
BATCH_ID NUMBER
Yes batch id
PURGE_STATUS VARCHAR2 (1) Yes Purge status
REQUEST_STATUS VARCHAR2 (3) Yes Request Status
REQUEST_TYPE VARCHAR2 (30) Yes request Type
REQUEST_MODE VARCHAR2 (1) Yes request Mode
REPORT_STATUS VARCHAR2 (1)
Report status
REQUESTOR_SURNAME VARCHAR2 (30) Yes requestor surname
REQUESTOR_GIVENNAME VARCHAR2 (30) Yes requestor given name
REQUESTOR_TYPE VARCHAR2 (30) Yes Requestor type
REQUEST_MADE_DATE DATE
Yes request made date
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
Query Text

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


SELECT ROW_ID
,      BATCH_ID
,      PURGE_STATUS
,      REQUEST_STATUS
,      REQUEST_TYPE
,      REQUEST_MODE
,      REPORT_STATUS
,      REQUESTOR_SURNAME
,      REQUESTOR_GIVENNAME
,      REQUESTOR_TYPE
,      REQUEST_MADE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
FROM APPS.IGS_DA_PURGE_V;

Dependencies

[top of page]

APPS.IGS_DA_PURGE_V references the following:

SchemaAPPS
SynonymIGS_DA_PURGE

APPS.IGS_DA_PURGE_V is not referenced by any database object