eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.CN_PROCESS_AUDITS_V

Object Details

Object Name:	CN_PROCESS_AUDITS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

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

CN_PROCESS_AUDITS_V is a view that shows details of processes run by t
he user. e.g. Calculation
If a process has spawned children these children have their own proces
s audit record. PARENT_PROCESS_ID links children to a parent

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
MODULE_TYPE	VARCHAR2	(80)	Yes	Process name
MODULE_TYPE_CODE	VARCHAR2	(30)	Yes	Process code
TIMESTAMP_START	DATE		Yes	Date and time the process began
TIMESTAMP_END	DATE			Date and time the process finished
PROCESS_AUDIT_ID	NUMBER	(15)	Yes	Unique identifier
PARENT_PROCESS_AUDIT_ID	NUMBER	(15)		Unique identifier of any parent process
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
BATCH_ID	NUMBER	(15)		Not currently used
CREATION_DATE	DATE			Standard who column - date when this row was created.
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY	NUMBER	(15)		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).

Query Text

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


SELECT MODULE_TYPE
,      MODULE_TYPE_CODE
,      TIMESTAMP_START
,      TIMESTAMP_END
,      PROCESS_AUDIT_ID
,      PARENT_PROCESS_AUDIT_ID
,      REQUEST_ID
,      BATCH_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      CREATED_BY
FROM APPS.CN_PROCESS_AUDITS_V;

Dependencies

[top of page]

APPS.CN_PROCESS_AUDITS_V references the following:

APPS: CN_LOOKUPS; CN_PROCESS_AUDITS

APPS.CN_PROCESS_AUDITS_V is not referenced by any database object