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]

TABLE: AMW.AMW_VIOLATION_RESP

Object Details

Object Name:	AMW_VIOLATION_RESP
Object Type:	TABLE
Owner:	AMW
FND Design Data:	AMW.AMW_VIOLATION_RESP
Subobject Name:
Status:	VALID

Stores information of responsibility violation for each violation

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMW_VIOLATION_RESP_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VIOLATION_ID RESP_VIOLATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RESP_VIOLATION_ID	NUMBER		Yes	Stores the responsibility violation identifier
VIOLATION_ID	NUMBER		Yes	Stores the violation id of the constraint violation to which the responsibility violation is associated
RESPONSIBILITY_ID	NUMBER			Stores the responsibility id of the responsibility violation
APPLICATION_ID	NUMBER	(15)		Stores the responsibility application id
ROLE_NAME	VARCHAR2	(320)		Stores the name of the role which violations the constraint
WAIVED_FLAG	VARCHAR2	(1)		Stores Y or N. Y = The responsibility violation is waived. N or NULL = The responsibility violation is not waived
CORRECTED_FLAG	VARCHAR2	(1)		Stores if the responsibility violations is corrected ot not. Possible values Y - The responsibility violation is corrected. N or NULL - The responsibility violation is not corrected yet.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
SECURITY_GROUP_ID	NUMBER			Used in hosted environments

Query Text

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


SELECT RESP_VIOLATION_ID
,      VIOLATION_ID
,      RESPONSIBILITY_ID
,      APPLICATION_ID
,      ROLE_NAME
,      WAIVED_FLAG
,      CORRECTED_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      SECURITY_GROUP_ID
FROM AMW.AMW_VIOLATION_RESP;

Dependencies

[top of page]

AMW.AMW_VIOLATION_RESP does not reference any database object

AMW.AMW_VIOLATION_RESP is referenced by following:

APPS: AMW_VIOLATION_RESP