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: AK.AK_WEB_USER_SEC_ATTR_VALUES

Object Details

Object Name:	AK_WEB_USER_SEC_ATTR_VALUES
Object Type:	TABLE
Owner:	AK
FND Design Data:	AK.AK_WEB_USER_SEC_ATTR_VALUES
Subobject Name:
Status:	VALID

AK_WEB_USER_SEC_ATTR_VALUES contains user IDs, attributes and
attributes values that define if an attribute is secure for a specific
user. You need one row for each user/attribute/value that you want to
secure.
AK_QUERY_PKG uses this table in conjunction with the
AK_RESP_SECURITY_ATTRIBUTES table. Together, both tables dictates to
AK_QUERY_PKG what rows should be returned.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AK_WEB_USER_SEC_ATTR_VALUES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	WEB_USER_ID ATTRIBUTE_CODE ATTRIBUTE_APPLICATION_ID VARCHAR2_VALUE DATE_VALUE NUMBER_VALUE
AK_WEB_USER_SEC_ATTR_VALUES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WEB_USER_ID ATTRIBUTE_CODE ATTRIBUTE_APPLICATION_ID
AK_WEB_USER_SEC_ATTR_VALUES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTRIBUTE_CODE ATTRIBUTE_APPLICATION_ID VARCHAR2_VALUE
AK_WEB_USER_SEC_ATTR_VALUES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTRIBUTE_CODE ATTRIBUTE_APPLICATION_ID NUMBER_VALUE
AK_WEB_USER_SEC_ATTR_VALUES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTRIBUTE_CODE ATTRIBUTE_APPLICATION_ID DATE_VALUE

Columns

Name	Datatype	Length	Mandatory	Comments
WEB_USER_ID	NUMBER		Yes	User ID
ATTRIBUTE_CODE	VARCHAR2	(30)	Yes	Attribute identifier of the secured attribute
ATTRIBUTE_APPLICATION_ID	NUMBER	(15)	Yes	Product team's application Id which the attribute belong to
VARCHAR2_VALUE	VARCHAR2	(240)		Varchar value used to determine if the user can view this secured attribute
DATE_VALUE	DATE			Date value used to determine if the user can view this secured attribute
NUMBER_VALUE	NUMBER			Number value used to determine if the user can view this secured attribute
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column

Query Text

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


SELECT WEB_USER_ID
,      ATTRIBUTE_CODE
,      ATTRIBUTE_APPLICATION_ID
,      VARCHAR2_VALUE
,      DATE_VALUE
,      NUMBER_VALUE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM AK.AK_WEB_USER_SEC_ATTR_VALUES;

Dependencies

[top of page]

AK.AK_WEB_USER_SEC_ATTR_VALUES does not reference any database object

AK.AK_WEB_USER_SEC_ATTR_VALUES is referenced by following:

APPS: AK_WEB_USER_SEC_ATTR_VALUES