eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: CZ.CZ_LOCK_HISTORY

Object Details

Object Name:	CZ_LOCK_HISTORY
Object Type:	TABLE
Owner:	CZ
FND Design Data:	CZ.CZ_LOCK_HISTORY
Subobject Name:
Status:	VALID

CZ_LOCK_HISTORY is used to record the modification and locking of Configurator objects through their lifecycle. Note that lock-controlled access is an optional feature not available in all versions of Configurator. Also note that locking applies exclusively to Configurator Developer objects and not to published objects or saved configurations.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ENTITY_TYPE	NUMBER		Yes	the initial design of this table. Needs more work for Developer to be able to use it (e.g. if a trigger will populate, how will Developer update it?).
INSTANCE_PK1_VALUE	NUMBER		Yes	PK as described in FND_OBJECTS
INSTANCE_PK2_VALUE	NUMBER		Yes	PK as described in FND_OBJECTS
INSTANCE_PK3_VALUE	NUMBER		Yes	PK as described in FND_OBJECTS
INSTANCE_PK4_VALUE	NUMBER		Yes	PK as described in FND_OBJECTS
EVENT	VARCHAR2	(2000)	Yes	Lock/Unlock
EVENT_DATE	DATE		Yes	Date/Time of Lock/Unlock
USER_NAME	VARCHAR2	(100)	Yes
EVENT_NOTE	VARCHAR2	(2000)		Lock/Unlock Note
LAST_UPDATE_LOGIN	NUMBER			Records the login ID under which this record was last updated
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
LAST_UPDATE_DATE	DATE		Yes	Standard field recording the date/time this record was last updated
CREATION_DATE	DATE		Yes	Standard field recording the date this record was created

Query Text

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


SELECT ENTITY_TYPE
,      INSTANCE_PK1_VALUE
,      INSTANCE_PK2_VALUE
,      INSTANCE_PK3_VALUE
,      INSTANCE_PK4_VALUE
,      EVENT
,      EVENT_DATE
,      USER_NAME
,      EVENT_NOTE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
FROM CZ.CZ_LOCK_HISTORY;

Dependencies

[top of page]

CZ.CZ_LOCK_HISTORY does not reference any database object

CZ.CZ_LOCK_HISTORY is referenced by following:

APPS: CZ_LOCK_HISTORY; CZ_LOCK_HISTORY_T1