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

TABLE: AK.AK_RESP_SECURITY_ATTR_VALUES

Object Details
Object Name: AK_RESP_SECURITY_ATTR_VALUES
Object Type: TABLE
Owner: AK
FND Design Data: TableAK.AK_RESP_SECURITY_ATTR_VALUES
Subobject Name:
Status: VALID


This table is used for storing values for securing attributes at the responsibility level.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AK_RESP_SECURITY_ATTR_VALUES_U NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESPONSIBILITY_ID
ColumnRESP_APPLICATION_ID
ColumnATTRIBUTE_CODE
ColumnATTRIBUTE_APPLICATION_ID
ColumnVARCHAR2_VALUE
ColumnDATE_VALUE
ColumnNUMBER_VALUE
AK_RESP_SECURITY_ATTR_VALUES_N NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnATTRIBUTE_CODE
ColumnATTRIBUTE_APPLICATION_ID
ColumnRESPONSIBILITY_ID
Columns
Name Datatype Length Mandatory Comments
RESPONSIBILITY_ID NUMBER (15) Yes FND Responsibility ID
RESP_APPLICATION_ID NUMBER (15) Yes FND Application ID to which the responsibility belongs.
ATTRIBUTE_CODE VARCHAR2 (30) Yes AK Attribute Code
ATTRIBUTE_APPLICATION_ID NUMBER (15) Yes FND Application ID to which the attribute belongs.
VARCHAR2_VALUE VARCHAR2 (240)
Securing attribute varchar2 value for the current attribute and responsibility.
DATE_VALUE DATE

Securing attribute date value for the current attribute and responsibility.
NUMBER_VALUE NUMBER (15)
Securing attribute number value for the current attribute and responsibility.
Query Text

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


SELECT RESPONSIBILITY_ID
,      RESP_APPLICATION_ID
,      ATTRIBUTE_CODE
,      ATTRIBUTE_APPLICATION_ID
,      VARCHAR2_VALUE
,      DATE_VALUE
,      NUMBER_VALUE
FROM AK.AK_RESP_SECURITY_ATTR_VALUES;

Dependencies

[top of page]

AK.AK_RESP_SECURITY_ATTR_VALUES does not reference any database object

AK.AK_RESP_SECURITY_ATTR_VALUES is referenced by following:

SchemaAK
ViewAK_RESP_SECURITY_ATTR_VALUES#