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_MODEL_USAGES

Object Details

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

This table records the USAGES that govern the participation of psnodes and rules in model execution. These usages are also part of model APPLICABILITY in a publication. There is currently a limit of 64 usages.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: CZ_MODEL_USAGES_PK

MODEL_USAGE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_MODEL_USAGES_PK	NORMAL	UNIQUE	APPS_TS_SEED	MODEL_USAGE_ID
CZ_MODEL_USAGES_U1	NORMAL	UNIQUE	APPS_TS_SEED	NAME IN_USE

Columns

Name	Datatype	Length	Mandatory	Comments
MODEL_USAGE_ID	NUMBER	(9)	Yes	Provides a numeric identity for this usage. (Allowed values 0-63)
NAME	VARCHAR2	(255)	Yes	The name of this object
DESCRIPTION	VARCHAR2	(2000)		Descriptive text
NOTE	VARCHAR2	(2000)		Note text
IN_USE	VARCHAR2	(1)	Yes	Default '1'. Indicates this Usage is 'in use,'if '0' it is visible, but can be deleted and reused. 'X' will indicatea complete logical delete (before reuse). TAKES PLACE OF STANDARD DELETED_FLAG.
CREATED_BY	NUMBER	(9)	Yes	Standard field recording the ID of the user that created this record
CREATION_DATE	DATE		Yes	Standard field recording the date this record was created
LAST_UPDATED_BY	NUMBER	(9)	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
LAST_UPDATE_LOGIN	NUMBER			Standard field recording the user/number this record was last login

Query Text

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


SELECT MODEL_USAGE_ID
,      NAME
,      DESCRIPTION
,      NOTE
,      IN_USE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM CZ.CZ_MODEL_USAGES;

Dependencies

[top of page]

CZ.CZ_MODEL_USAGES does not reference any database object

CZ.CZ_MODEL_USAGES is referenced by following:

APPS: CZ_MODEL_USAGES; CZ_MODEL_USAGES_T1; CZ_MODEL_USAGES_T2; CZ_MODEL_USAGES_T3