[Home] [Help] [Dependency Information]
Object Name: | CZ_CONFIG_EXT_ATTRIBUTES |
---|---|
Object Type: | TABLE |
Owner: | CZ |
FND Design Data: | CZ.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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CZ_CONFIG_EXT_ATTRIBUTES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CONFIG_HDR_ID
CONFIG_REV_NBR CONFIG_ITEM_ID ATTRIBUTE_NAME |
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 |
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;
CZ.CZ_CONFIG_EXT_ATTRIBUTES does not reference any database object
CZ.CZ_CONFIG_EXT_ATTRIBUTES is referenced by following:
|
|
|