[Home] [Help] [Dependency Information]
Object Name: | CZ_LOOKUP_VALUES |
---|---|
Object Type: | TABLE |
Owner: | CZ |
FND Design Data: | CZ.CZ_LOOKUP_VALUES |
Subobject Name: | |
Status: | VALID |
CZ_LOOKUP_VALUES is used to record lists of seeded data values for use in Configurator Developer. It records symbolic and numeric values grouped in lists. Values are labelled with type IDs from the Configurator type system.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CZ_LOOKUP_VALUES_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED |
LIST_NAME
DATA_VALUE DELETED_FLAG NULL_VALUE_FLAG VALUE_SEQ |
CZ_LOOKUP_VALUES_N2 | NORMAL | NONUNIQUE | APPS_TS_SEED |
DELETED_FLAG
LIST_NAME DATA_VALUE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LIST_NAME | VARCHAR2 | (50) | Yes | PK |
DATA_VALUE | VARCHAR2 | (255) | Yes | PK |
VALUE_SEQ | NUMBER | Optional field provides partial ordering on LOV members as alternative to ordering by VALUE_LABEL or DATA_VALUE | ||
DATA_TYPE_ID | NUMBER | Yes | ||
NULL_VALUE_FLAG | VARCHAR2 | (1) | Default '0', only one member of LIST_NAME can have non-'0' | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
CREATION_DATE | DATE | Yes | Standard field recording the date this record was created | |
LAST_UPDATE_DATE | DATE | Yes | Standard field recording the date/time this record was last updated | |
CREATED_BY | NUMBER | (15) | Yes | Standard field recording the ID of the user that created this record |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard field recording the ID of the user that last updated this record |
DELETED_FLAG | VARCHAR2 | (1) | Yes | 0 - not deleted; 1 - deleted (Standard) |
NUMERIC_ID_VALUE | NUMBER | Stores numeric value of DATA_VALUE, when applicable. | ||
SEEDED_FLAG | VARCHAR2 | (1) | Yes | '1' indicates this is a seeded expr node |
Cut, paste (and edit) the following text to query this object:
SELECT LIST_NAME
, DATA_VALUE
, VALUE_SEQ
, DATA_TYPE_ID
, NULL_VALUE_FLAG
, LAST_UPDATE_LOGIN
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, DELETED_FLAG
, NUMERIC_ID_VALUE
, SEEDED_FLAG
FROM CZ.CZ_LOOKUP_VALUES;
CZ.CZ_LOOKUP_VALUES does not reference any database object
CZ.CZ_LOOKUP_VALUES is referenced by following:
|
|
|