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

TABLE: CZ.CZ_CONFIG_EXT_ATTRIBUTES

Object Details
Object Name: CZ_CONFIG_EXT_ATTRIBUTES
Object Type: TABLE
Owner: CZ
FND Design Data: TableCZ.CZ_CONFIG_EXT_ATTRIBUTES
Subobject Name:
Status: VALID


The CZ_CONFIG_EXT_ATTRIBUTES table is used to attach attribute values to Saved Configuration Items in fully-normalized { name, value } form.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: CZ_CONFIG_EXT_ATTRIBUTES_PK
  1. ColumnCONFIG_HDR_ID
  2. ColumnCONFIG_REV_NBR
  3. ColumnCONFIG_ITEM_ID
  4. ColumnATTRIBUTE_NAME
Indexes
Index Type Uniqueness Tablespace Column
CZ_CONFIG_EXT_ATTRIBUTES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONFIG_HDR_ID
ColumnCONFIG_REV_NBR
ColumnCONFIG_ITEM_ID
ColumnATTRIBUTE_NAME
Columns
Name Datatype Length Mandatory Comments
CONFIG_HDR_ID NUMBER
Yes Identifies the Saved Configuration Header for the item to which this attribute is attached.
CONFIG_REV_NBR NUMBER
Yes Specifies the Revision for this attribute's Configuration
CONFIG_ITEM_ID NUMBER
Yes Attaches this attribute to a specific item in the Saved Configuration
ATTRIBUTE_NAME VARCHAR2 (255) Yes Name for this Extended Attribute. Cf. IB Extended Attribute Name
ATTRIBUTE_GROUP VARCHAR2 (255)
Group for this Extended Attribute. Cf. IB Extended Attribute Group
ATTRIBUTE_VALUE VARCHAR2 (255)
Value of this attribute.
DELETED_FLAG VARCHAR2 (1) Yes Standard flag indicating whether this record is active ('0') or deleted ('1'). Other values are reserved for Oracle use.
CREATION_DATE DATE
Yes Standard footprint field. Date this record was created.
CREATED_BY NUMBER
Yes Standard footprint field. 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. Applications user that last updated this record.
LAST_UPDATE_LOGIN NUMBER

Standard footprint field. Login identity of user that last updated this record.
SEQUENCE_NBR NUMBER

Query Text

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


SELECT CONFIG_HDR_ID
,      CONFIG_REV_NBR
,      CONFIG_ITEM_ID
,      ATTRIBUTE_NAME
,      ATTRIBUTE_GROUP
,      ATTRIBUTE_VALUE
,      DELETED_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SEQUENCE_NBR
FROM CZ.CZ_CONFIG_EXT_ATTRIBUTES;

Dependencies

[top of page]

CZ.CZ_CONFIG_EXT_ATTRIBUTES does not reference any database object

CZ.CZ_CONFIG_EXT_ATTRIBUTES is referenced by following:

SchemaAPPS
SynonymCZ_CONFIG_EXT_ATTRIBUTES
TriggerCZ_CONFIG_EXT_ATTRIBUTES_T1