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

TABLE: CZ.CZ_ARCHIVE_REFS

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


CZ_ARCHIVE_REFS provides an ordered list of archives to be used in the context of a specific model. When a Configurator Extension is invoked within that model, its implementation is found by searching this list in order (SEQ_NBR).


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Primary Key: CZ_ARCHIVE_REFS_PK
  1. ColumnDEVL_PROJECT_ID
  2. ColumnSEQ_NBR
Indexes
Index Type Uniqueness Tablespace Column
CZ_ARCHIVE_REFS_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnDEVL_PROJECT_ID
ColumnSEQ_NBR
CZ_ARCHIVE_REFS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnDEVL_PROJECT_ID
ColumnARCHIVE_ID
Columns
Name Datatype Length Mandatory Comments
DEVL_PROJECT_ID NUMBER
Yes PK points to associated DEVL_PROJECT_ID
SEQ_NBR NUMBER
Yes PK. Sequence no of the scope
ARCHIVE_ID NUMBER
Yes Points to the code archive
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
Query Text

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


SELECT DEVL_PROJECT_ID
,      SEQ_NBR
,      ARCHIVE_ID
,      DELETED_FLAG
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
FROM CZ.CZ_ARCHIVE_REFS;

Dependencies

[top of page]

CZ.CZ_ARCHIVE_REFS does not reference any database object

CZ.CZ_ARCHIVE_REFS is referenced by following:

SchemaAPPS
SynonymCZ_ARCHIVE_REFS
TriggerCZ_ARCHIVE_REFS_T1