[Home] [Help] [Dependency Information]
Object Name: | CZ_ARCHIVES |
---|---|
Object Type: | TABLE |
Owner: | CZ |
FND Design Data: | CZ.CZ_ARCHIVES |
Subobject Name: | |
Status: | VALID |
CZ_ARCHIVES is the table that stores uploaded binary objects for use in Configurator models and publications, specifically, Configurator Extensions.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CZ_ARCHIVES_PK | NORMAL | UNIQUE | APPS_TS_SEED | ARCHIVE_ID |
SYS_IL0000324853C00005$$ | LOB | UNIQUE | APPS_TS_SEED |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ARCHIVE_ID | NUMBER | Yes | PK | |
NAME | VARCHAR2 | (255) | Yes | Holds the archive name |
DESCRIPTION | VARCHAR2 | (2000) | Description of the code archive. | |
ARCHIVE_TYPE | NUMBER | Yes | URL.Type of the archive. Determines the source of the archive: 0 = BLOB - jar/zip file in BLOB; 1 = URL – jar/zip file from URL. | |
ARCHIVE_BLOB | BLOB | (4000) | If archive_type = BLOB, this is the content of the archive. | |
ARCHIVE_URL | VARCHAR2 | (2000) | If archive_type = URL, this is the URL specifying the archive file. | |
PERSISTENT_ARCHIVE_ID | NUMBER | Yes | Persistent ID of this archive, i.e. remaining constant through copies and publication | |
DELETED_FLAG | VARCHAR2 | (1) | Yes | 0 - not deleted; 1 - deleted (Standard) |
LAST_UPDATE_LOGIN | NUMBER | Standard footprint field. Login identity of user that last updated this record. | ||
LAST_UPDATE_DATE | DATE | Yes | Date this record was last updated | |
CREATION_DATE | DATE | Yes | Date this record was created | |
CREATED_BY | NUMBER | Yes | Standard field recording the ID of the user that created this record | |
LAST_UPDATED_BY | NUMBER | Yes | Standard field recording the ID of the user that last updated this record | |
DOCUMENTATION_URL | VARCHAR2 | (2000) | URL of documentation for the archive (e.g. javadoc). |
Cut, paste (and edit) the following text to query this object:
SELECT ARCHIVE_ID
, NAME
, DESCRIPTION
, ARCHIVE_TYPE
, ARCHIVE_BLOB
, ARCHIVE_URL
, PERSISTENT_ARCHIVE_ID
, DELETED_FLAG
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, DOCUMENTATION_URL
FROM CZ.CZ_ARCHIVES;
CZ.CZ_ARCHIVES does not reference any database object
CZ.CZ_ARCHIVES is referenced by following:
|
|
|