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


TABLE: BNE.BNE_ATTRIBUTES

Object Details
Object Name: BNE_ATTRIBUTES
Object Type: TABLE
Owner: BNE
FND Design Data: TableBNE.BNE_ATTRIBUTES
Subobject Name:
Status: VALID


BNE_ATTRIBUTES stores generic information about paramter lists entities which could not be anticipated. There are thirty ATTRIBUTE columns that allow the storage of any data in character form that the developer may wish. The attributes may be saved against a parameter list, list item or list item definition.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BNE_ATTRIBUTES_UK1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPLICATION_ID
ColumnATTRIBUTE_CODE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Yes Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
ATTRIBUTE_CODE VARCHAR2 (30) Yes Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Yes Object Version Number
ATTRIBUTE1 VARCHAR2 (2000)
Attribute 1
ATTRIBUTE2 VARCHAR2 (2000)
Attribute 2
ATTRIBUTE3 VARCHAR2 (2000)
Attribute 3
ATTRIBUTE4 VARCHAR2 (2000)
Attribute 4
ATTRIBUTE5 VARCHAR2 (2000)
Attribute 5
ATTRIBUTE6 VARCHAR2 (2000)
Attribute 6
ATTRIBUTE7 VARCHAR2 (2000)
Attribute 7
ATTRIBUTE8 VARCHAR2 (2000)
Attribute 8
ATTRIBUTE9 VARCHAR2 (2000)
Attribute 9
ATTRIBUTE10 VARCHAR2 (2000)
Attribute 110
ATTRIBUTE11 VARCHAR2 (2000)
Attribute 11
ATTRIBUTE12 VARCHAR2 (2000)
Attribute 12
ATTRIBUTE13 VARCHAR2 (2000)
Attribute 13
ATTRIBUTE14 VARCHAR2 (2000)
Attribute 14
ATTRIBUTE15 VARCHAR2 (2000)
Attribute 15
ATTRIBUTE16 VARCHAR2 (2000)
Attribute 16
ATTRIBUTE17 VARCHAR2 (2000)
Attribute 17
ATTRIBUTE18 VARCHAR2 (2000)
Attribute 18
ATTRIBUTE19 VARCHAR2 (2000)
Attribute 19
ATTRIBUTE20 VARCHAR2 (2000)
Attribute 20
ATTRIBUTE21 VARCHAR2 (2000)
Attribute 21
ATTRIBUTE22 VARCHAR2 (2000)
Attribute 22
ATTRIBUTE23 VARCHAR2 (2000)
Attribute 23
ATTRIBUTE24 VARCHAR2 (2000)
Attribute 24
ATTRIBUTE25 VARCHAR2 (2000)
Attribute 25
ATTRIBUTE26 VARCHAR2 (2000)
Attribute 26
ATTRIBUTE27 VARCHAR2 (2000)
Attribute 27
ATTRIBUTE28 VARCHAR2 (2000)
Attribute 28
ATTRIBUTE29 VARCHAR2 (2000)
Attribute 29
ATTRIBUTE30 VARCHAR2 (2000)
Attribute 30
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE_NAME1 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME2 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME3 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME4 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME5 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME6 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME7 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME8 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME9 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME10 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME11 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME12 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME13 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME14 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME15 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME16 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME17 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME18 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME19 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME20 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME21 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME22 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME23 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME24 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME25 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME26 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME27 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME28 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME29 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME30 VARCHAR2 (30)
Name for corresponding attribute
Query Text

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


SELECT APPLICATION_ID
,      ATTRIBUTE_CODE
,      OBJECT_VERSION_NUMBER
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_NAME1
,      ATTRIBUTE_NAME2
,      ATTRIBUTE_NAME3
,      ATTRIBUTE_NAME4
,      ATTRIBUTE_NAME5
,      ATTRIBUTE_NAME6
,      ATTRIBUTE_NAME7
,      ATTRIBUTE_NAME8
,      ATTRIBUTE_NAME9
,      ATTRIBUTE_NAME10
,      ATTRIBUTE_NAME11
,      ATTRIBUTE_NAME12
,      ATTRIBUTE_NAME13
,      ATTRIBUTE_NAME14
,      ATTRIBUTE_NAME15
,      ATTRIBUTE_NAME16
,      ATTRIBUTE_NAME17
,      ATTRIBUTE_NAME18
,      ATTRIBUTE_NAME19
,      ATTRIBUTE_NAME20
,      ATTRIBUTE_NAME21
,      ATTRIBUTE_NAME22
,      ATTRIBUTE_NAME23
,      ATTRIBUTE_NAME24
,      ATTRIBUTE_NAME25
,      ATTRIBUTE_NAME26
,      ATTRIBUTE_NAME27
,      ATTRIBUTE_NAME28
,      ATTRIBUTE_NAME29
,      ATTRIBUTE_NAME30
FROM BNE.BNE_ATTRIBUTES;

Dependencies

[top of page]

BNE.BNE_ATTRIBUTES does not reference any database object

BNE.BNE_ATTRIBUTES is referenced by following:

SchemaAPPS
SynonymBNE_ATTRIBUTES