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_XFR_RUN_RESULTS

Object Details

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

CZ_XFR_RUN_RESULTS contains a summary of records imported into the Oracle Configurator schema.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: CZ_XFR_RUN_RESULTS_PK

IMP_TABLE
REC_STATUS
RUN_ID
DISPOSITION

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_XFR_RUN_RESULTS_PK	NORMAL	UNIQUE	APPS_TS_SEED	IMP_TABLE REC_STATUS RUN_ID DISPOSITION
CZ_XFR_RUN_RESULTS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	RUN_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RUN_ID	NUMBER	(9)	Yes	Run ID to which this result refers
IMP_TABLE	VARCHAR2	(40)	Yes	Name of the import table for which this record summarizes results
DISPOSITION	VARCHAR2	(1)	Yes	Disposition code in that import table
REC_STATUS	VARCHAR2	(4)	Yes	Rec-status code for that import table
RECORDS	NUMBER	(9)	Yes	Number of records in the table bearing that disposition and status

Query Text

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


SELECT RUN_ID
,      IMP_TABLE
,      DISPOSITION
,      REC_STATUS
,      RECORDS
FROM CZ.CZ_XFR_RUN_RESULTS;

Dependencies

[top of page]

CZ.CZ_XFR_RUN_RESULTS does not reference any database object

CZ.CZ_XFR_RUN_RESULTS is referenced by following:

APPS: CZ_XFR_RUN_RESULTS