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_INST_ATTRIBUTE_VALUES

Object Details

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

AK_INST_ATTRIBUTE_VALUES is used by the Configurator (CZ) team and is
used to store items.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AK_INST_ATTRIBUTE_VALUES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DATABASE_OBJECT_NAME KEY_VALUE1 KEY_VALUE2 KEY_VALUE3
AK_INST_ATTRIBUTE_VALUES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTRIBUTE_CODE ATTRIBUTE_APPLICATION_ID DATABASE_OBJECT_NAME
AK_INST_ATTRIBUTE_VALUES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DATABASE_OBJECT_NAME KEY_VALUE1 KEY_VALUE2 ATTRIBUTE_APPLICATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DATABASE_OBJECT_NAME	VARCHAR2	(30)	Yes	Database object identifier
KEY_VALUE1	VARCHAR2	(100)	Yes	First key value of database object
KEY_VALUE2	VARCHAR2	(100)		Second key value of database object
KEY_VALUE3	VARCHAR2	(100)		Third key value of database object
KEY_VALUE4	VARCHAR2	(100)		Fourth key value of database object
KEY_VALUE5	VARCHAR2	(100)	Yes	Fifth key value of database object
KEY_VALUE6	VARCHAR2	(100)	Yes	Sixth key value of database object
KEY_VALUE7	VARCHAR2	(100)		Seventh key value of database object
KEY_VALUE8	VARCHAR2	(100)		Eigth key value of database object
KEY_VALUE9	VARCHAR2	(100)		Ninth key value of database object
KEY_VALUE10	VARCHAR2	(100)		Tenth key value of database object
ATTRIBUTE_CODE	VARCHAR2	(30)	Yes	Attribute identifier
ATTRIBUTE_APPLICATION_ID	NUMBER	(15)	Yes	Product team's application Id which the attribute belong to
VALUE_VARCHAR2	VARCHAR2	(240)		Value of attribute if the attribute is a varchar
VALUE_DATE	DATE			Value of attribute if the attribute is a date
VALUE_NUMBER	NUMBER	(15)		Value of attribute if the attribute is a number
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 DATABASE_OBJECT_NAME
,      KEY_VALUE1
,      KEY_VALUE2
,      KEY_VALUE3
,      KEY_VALUE4
,      KEY_VALUE5
,      KEY_VALUE6
,      KEY_VALUE7
,      KEY_VALUE8
,      KEY_VALUE9
,      KEY_VALUE10
,      ATTRIBUTE_CODE
,      ATTRIBUTE_APPLICATION_ID
,      VALUE_VARCHAR2
,      VALUE_DATE
,      VALUE_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM AK.AK_INST_ATTRIBUTE_VALUES;

Dependencies

[top of page]

AK.AK_INST_ATTRIBUTE_VALUES does not reference any database object

AK.AK_INST_ATTRIBUTE_VALUES is referenced by following:

APPS: AK_INST_ATTRIBUTE_VALUES