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: CZ.CZ_CONFIG_ATTRIBUTES

Object Details

Object Name:	CZ_CONFIG_ATTRIBUTES
Object Type:	TABLE
Owner:	CZ
FND Design Data:	CZ.CZ_CONFIG_ATTRIBUTES
Subobject Name:
Status:	VALID

The CZ_CONFIG_ATTRIBUTES table is used to attach, to configuration items, arbitrary sets of data, defined either by customer requirements or integrating applications. The structure supports the flexfield format but note that the inclusion of ATTRIBUTE_CATEGORY in the primary key allows multiple 'flexfield' attachments to any single item for additional flexibility ("extensible attributes")

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: CZ_CONFIG_ATTRIBUTES_PK

CONFIG_HDR_ID
CONFIG_REV_NBR
CONFIG_ITEM_ID
ATTRIBUTE_CATEGORY

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_CONFIG_ATTRIBUTES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CONFIG_HDR_ID CONFIG_REV_NBR CONFIG_ITEM_ID ATTRIBUTE_CATEGORY

Columns

Name	Datatype	Length	Mandatory	Comments
CONFIG_HDR_ID	NUMBER		Yes	Identifies this attribute record with a Configuration Header
CONFIG_REV_NBR	NUMBER		Yes	Specifies the configuration revision under which this attributes record is attached
CONFIG_ITEM_ID	NUMBER		Yes	Attaches this attributes record to the specified configuration item
ATTRIBUTE_CATEGORY	VARCHAR2	(240)	Yes	Categorizes the set of attributes defined in this record.
DELETED_FLAG	VARCHAR2	(1)	Yes	Standard flag indicating whether this record is active ('0') or deleted ('1'). Other values are reserved to Oracle internal use.
CREATION_DATE	DATE		Yes	Standard 'footprint' field. Date this record was created
CREATED_BY	NUMBER		Yes	Standard 'footprint' field. Identifies the Applications user that created this record
LAST_UPDATE_DATE	DATE		Yes	Standard 'footprint' field. Date this record was last updated
LAST_UPDATED_BY	NUMBER		Yes	Standard 'footprint' field. Identifies the Applications user that last updated this record
LAST_UPDATE_LOGIN	NUMBER			Standard 'footprint' field. Provides login identity of user that last updated this record.
ATTRIBUTE1	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE2	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE3	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE4	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE5	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE6	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE7	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE8	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE9	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE10	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE11	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE12	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE13	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE14	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE15	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE16	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE17	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE18	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE19	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE20	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE21	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE22	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE23	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE24	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE25	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE26	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE27	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE28	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE29	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.
ATTRIBUTE30	VARCHAR2	(4000)		This field contains an attribute to be attached to the Configuration Item. Its meaning and usage are inferred from the value of the ATTRIBUTE_CATEGORY field.

Query Text

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


SELECT CONFIG_HDR_ID
,      CONFIG_REV_NBR
,      CONFIG_ITEM_ID
,      ATTRIBUTE_CATEGORY
,      DELETED_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      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
FROM CZ.CZ_CONFIG_ATTRIBUTES;

Dependencies

[top of page]

CZ.CZ_CONFIG_ATTRIBUTES does not reference any database object

CZ.CZ_CONFIG_ATTRIBUTES is referenced by following:

APPS: CZ_CONFIG_ATTRIBUTES; CZ_CONFIG_ATTRIBUTES_T1