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_MODEL_EXPORTS

Object Details

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

This table is used to hold and sequence the export of models for Publication. Whereas the CZ_MODEL_PUBLICATIONS table only contains a single row per model publication, even if that model contains referenced child models, the CZ_PB_MODEL_EXPORTS table contains a row for the top model and all models enclosed (transitively) by referencing.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: CZ_PB_MODEL_EXPORTS_PK

EXPORT_ID
EXPORT_SEQ

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_PB_MODEL_EXPORTS_PK	NORMAL	UNIQUE	APPS_TS_SEED	EXPORT_ID EXPORT_SEQ
CZ_PB_MODEL_EXPORTS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	MODEL_ID STATUS

Columns

Name	Datatype	Length	Mandatory	Comments
EXPORT_ID	NUMBER		Yes	Identifies a group of records involved in publishing/exporting a single model
EXPORT_SEQ	NUMBER		Yes	Distinguishes a particular model export in the EXPORT_ID group
MODEL_ID	NUMBER		Yes	Associates this record with a configurator Model/Project
ROOT_MODEL_ID	NUMBER		Yes	Model ID of the root model in this publication export
SERVER_ID	NUMBER		Yes	Associates this record with a database-server instance
PUBLICATION_ID	NUMBER			Identifies a publication for this record
REMOTE_MODEL_ID	NUMBER			Records the model ID into which this exported model was copied on the remote server
EXPORT_REVERSE_SEQ	NUMBER		Yes	Assigns a top-down ordering of model exports, which is the reverse of the actual order in which they are exported
STATUS	VARCHAR2	(3)		Status code for this model export: 'PEN' - export is pending; 'PRC' - export is being processed; 'OK' - export has completed; 'PUP' - update is pending; 'ERR' - export has failed
SUPERSEDED_FLAG	VARCHAR2	(1)	Yes	Default '0'. A value of '1' indicates a later export of the samemodel has superseded this export.
LAST_XFR_ACTIVITY	DATE			Timestamp of the last export action on this model export
CREATION_DATE	DATE		Yes	Standard field recording the date this record was created
CREATED_BY	NUMBER		Yes	Standard field recording the ID of the user that created this record
LAST_UPDATE_DATE	DATE		Yes	Standard field recording the date/time this record was last updated
LAST_UPDATED_BY	NUMBER		Yes	Standard field recording the ID of the user that last updated this record
MIGRATION_GROUP_ID	NUMBER			De-normalization from CZ_MODEL_PUBLICATUIONS

Query Text

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


SELECT EXPORT_ID
,      EXPORT_SEQ
,      MODEL_ID
,      ROOT_MODEL_ID
,      SERVER_ID
,      PUBLICATION_ID
,      REMOTE_MODEL_ID
,      EXPORT_REVERSE_SEQ
,      STATUS
,      SUPERSEDED_FLAG
,      LAST_XFR_ACTIVITY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      MIGRATION_GROUP_ID
FROM CZ.CZ_PB_MODEL_EXPORTS;

Dependencies

[top of page]

CZ.CZ_PB_MODEL_EXPORTS does not reference any database object

CZ.CZ_PB_MODEL_EXPORTS is referenced by following:

APPS: CZ_PB_MODEL_EXPORTS