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.AMW_VIOLATIONS_V

Object Details

Object Name:	AMW_VIOLATIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMW.AMW_VIOLATIONS_V
Subobject Name:
Status:	VALID

View Type

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

this view returns information about Segregation of Duties Constraint Violation

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CONSTRAINT_NAME	VARCHAR2	(240)	Yes	Constraint Name
CONSTRAINT_REV_ID	NUMBER		Yes	Constraint Revision Identifier
REQUEST_ID	NUMBER			Request Identifier
REQUEST_DATE	DATE			Request Date
VIOLATOR_NUM	NUMBER			Number of Violator
REQUESTED_BY_ID	NUMBER			Requested By Which User
REQUESTED_BY_NAME	VARCHAR2	(240)		Employee Full Name
STATUS_MEANING	VARCHAR2	(80)	Yes	Violation Status
STATUS_CODE	VARCHAR2	(30)		Violation Status Code
TYPE_DESCRIPTION	VARCHAR2	(240)		Constraint Type Description
VIOLATION_ID	NUMBER		Yes	Unique Identifier

Query Text

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


SELECT CONSTRAINT_NAME
,      CONSTRAINT_REV_ID
,      REQUEST_ID
,      REQUEST_DATE
,      VIOLATOR_NUM
,      REQUESTED_BY_ID
,      REQUESTED_BY_NAME
,      STATUS_MEANING
,      STATUS_CODE
,      TYPE_DESCRIPTION
,      VIOLATION_ID
FROM APPS.AMW_VIOLATIONS_V;

Dependencies

[top of page]

APPS.AMW_VIOLATIONS_V references the following:

APPS: AMW_CONSTRAINTS_VL; AMW_EMPLOYEES_CURRENT_V; AMW_LOOKUPS; AMW_VIOLATIONS

APPS.AMW_VIOLATIONS_V is not referenced by any database object