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: AP.AP_WEB_PROXY_ASSIGNMENTS

Object Details

Object Name:	AP_WEB_PROXY_ASSIGNMENTS
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_WEB_PROXY_ASSIGNMENTS
Subobject Name:
Status:	VALID

This tables stores the reporting access rights
relationships that are created whenever an assignor grants or updates
reporting access rights to an assignee.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_WEB_PROXY_ASSIGNMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ID
AP_WEB_PROXY_ASSIGNMENTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ASSIGNOR_ID ASSIGNEE_ID RESPONSIBILITY_ID ASSIGNMENT_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
ASSIGNMENT_ID	NUMBER	(15)	Yes	Unique sequence number.
ASSIGNOR_ID	NUMBER	(15)	Yes	Application user identifier.
ASSIGNEE_ID	NUMBER	(15)	Yes	Application user identifier.
RESPONSIBILITY_ID	NUMBER	(15)	Yes	Responsibility assigned to the user.
RESPONSIBILITY_APP_ID	NUMBER	(15)	Yes	Unique sequence number.
SECURITY_GROUP_ID	NUMBER	(15)	Yes	Security group identifier.
EFFECTIVE_START_DATE	DATE		Yes	The date the responsibility assignment begins.
EFFECTIVE_END_DATE	DATE			The date the responsibility assignment expires.
ASSIGNMENT_TYPE	VARCHAR2	(30)	Yes	Identifies the record source.
LAST_UPDATE_DATE	DATE			Standard WHO column
LAST_UPDATED_BY	NUMBER			Standard WHO column
LAST_UPDATE_LOGIN	NUMBER			Standard WHO column
CREATED_BY	NUMBER			Standard WHO column
CREATION_DATE	DATE			Standard WHO column

Query Text

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


SELECT ASSIGNMENT_ID
,      ASSIGNOR_ID
,      ASSIGNEE_ID
,      RESPONSIBILITY_ID
,      RESPONSIBILITY_APP_ID
,      SECURITY_GROUP_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      ASSIGNMENT_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM AP.AP_WEB_PROXY_ASSIGNMENTS;

Dependencies

[top of page]

AP.AP_WEB_PROXY_ASSIGNMENTS does not reference any database object

AP.AP_WEB_PROXY_ASSIGNMENTS is referenced by following:

AP: AP_WEB_PROXY_ASSIGNMENTS#