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: BIX.BIX_DM_COLLECT_LOG

Object Details

Object Name:	BIX_DM_COLLECT_LOG
Object Type:	TABLE
Owner:	BIX
Subobject Name:
Status:	VALID

This table contains collection log information.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
COLLECT_ID	NUMBER		Yes	Unique identifier
COLLECT_CONCUR_ID	NUMBER			Collection concurrent program identifier
OBJECT_NAME	VARCHAR2	(400)		Collection object name
OBJECT_TYPE	VARCHAR2	(100)		Collection object type
COLLECT_START_DATE	DATE			Collection start date
COLLECT_END_DATE	DATE			Collection end date
RUN_START_DATE	DATE			Collection program run start date
RUN_END_DATE	DATE			Collection program run end date
COLLECT_STATUS	VARCHAR2	(100)		Collection status
COLLECT_EXCEP_MESG	VARCHAR2	(4000)		Collection exception message
ROWS_INSERTED	NUMBER			Number of rows inserted
ROWS_DELETED	NUMBER			Number of rows deleted
ROWS_UPDATED	NUMBER			Number of rows updated
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
SECURITY_GROUP_ID	NUMBER			Subscriber id for CRM Online Services use
REQUEST_ID	NUMBER			Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	NUMBER			Application identifier of last concurrent program to update this record
PROGRAM_ID	NUMBER			Identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE	DATE			Date when a concurrent program last updated this record

Query Text

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


SELECT COLLECT_ID
,      COLLECT_CONCUR_ID
,      OBJECT_NAME
,      OBJECT_TYPE
,      COLLECT_START_DATE
,      COLLECT_END_DATE
,      RUN_START_DATE
,      RUN_END_DATE
,      COLLECT_STATUS
,      COLLECT_EXCEP_MESG
,      ROWS_INSERTED
,      ROWS_DELETED
,      ROWS_UPDATED
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM BIX.BIX_DM_COLLECT_LOG;

Dependencies

[top of page]

BIX.BIX_DM_COLLECT_LOG does not reference any database object

BIX.BIX_DM_COLLECT_LOG is referenced by following:

APPS: BIX_DM_COLLECT_LOG