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_PB_TEMP_IDS

Object Details

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

This table is used in support of the Publishing capability and is used as a vehicle for mapping original record identities to their published copies.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_PB_TEMP_IDS_PK	NORMAL	UNIQUE	APPS_TS_SEED	RUN_ID TABLE_CODE ORIG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
NEW_ID	NUMBER	(9)	Yes	This field records the new ID generated for this object's copy on the remote server
RUN_ID	NUMBER	(9)	Yes	Associates this record with a specific batch run (import, publish, purge, etc.)
TABLE_CODE	VARCHAR2	(3)	Yes	Code identifying the table in which the referenced record resides: PRJ - cz_devl_projects; PSN - cz_ps_nodes
ORIG_ID	NUMBER	(9)	Yes	Numeric ID for this object in the table indicated by TABLE_CODE

Query Text

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


SELECT NEW_ID
,      RUN_ID
,      TABLE_CODE
,      ORIG_ID
FROM CZ.CZ_PB_TEMP_IDS;

Dependencies

[top of page]

CZ.CZ_PB_TEMP_IDS does not reference any database object

CZ.CZ_PB_TEMP_IDS is referenced by following:

APPS: CZ_PB_TEMP_IDS