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_PUBLICATION_USAGES

Object Details

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

This table lists the model-usages that are part the applicability of each Publication. Note in some versions of Oracle Configurator a USAGE_ID value of -1 indicates 'all usages'.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: CZ_PUBLICATION_USAGES_PK

PUBLICATION_ID
USAGE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_PUBLICATION_USAGES_PK	NORMAL	UNIQUE	APPS_TS_SEED	PUBLICATION_ID USAGE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PUBLICATION_ID	NUMBER	(9)	Yes	Identifies a publication for this record
USAGE_ID	NUMBER	(9)	Yes	Identifies a Usage ID in the publication's applicability

Query Text

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


SELECT PUBLICATION_ID
,      USAGE_ID
FROM CZ.CZ_PUBLICATION_USAGES;

Dependencies

[top of page]

CZ.CZ_PUBLICATION_USAGES does not reference any database object

CZ.CZ_PUBLICATION_USAGES is referenced by following:

APPS: CZ_PUBLICATION_USAGES