[Home] [Help] [Dependency Information]
Object Name: | CZ_DB_SETTINGS |
---|---|
Object Type: | TABLE |
Owner: | CZ |
FND Design Data: | CZ.CZ_DB_SETTINGS |
Subobject Name: | |
Status: | VALID |
CZ_DB_SETTINGS contains information about Oracle Configurator system settings. System settings are organized by section names and identified using setting names. An example of a system setting is "OracleSequenceIncr" in section "SCHEMA". It indicates the increment used in Configurator sequence objects.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CZ_DB_SETTINGS_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
SECTION_NAME
SETTING_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SETTING_ID | VARCHAR2 | (40) | Yes | Data base setting identifier |
SECTION_NAME | VARCHAR2 | (30) | Yes | Data base setting name |
DATA_TYPE | NUMBER | (8) | Data type of this DB setting 1-integer;2-decimal;3-boolean;4-text -- cf CZ_PROPERTIES | |
VALUE | VARCHAR2 | (255) | The active value for this database settings | |
DESC_TEXT | VARCHAR2 | (255) | Data base setting description |
Cut, paste (and edit) the following text to query this object:
SELECT SETTING_ID
, SECTION_NAME
, DATA_TYPE
, VALUE
, DESC_TEXT
FROM CZ.CZ_DB_SETTINGS;
CZ.CZ_DB_SETTINGS does not reference any database object
CZ.CZ_DB_SETTINGS is referenced by following:
|
|
|