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: BIS.EDW_COLLECTION_DETAIL_LOG

Object Details

Object Name:	EDW_COLLECTION_DETAIL_LOG
Object Type:	TABLE
Owner:	BIS
FND Design Data:	BIS.EDW_COLLECTION_DETAIL_LOG
Subobject Name:
Status:	VALID

Log table for load process

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EDW_COLLECTION_DETAIL_LOG_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_TYPE
EDW_COLLECTION_DETAIL_LOG_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_NAME
EDW_COLLECTION_DETAIL_LOG_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOAD_PK
EDW_COLLECTION_DETAIL_LOG_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_ID

Columns

Name	Datatype	Length	Comments
COLL_LOG_FK	NUMBER		Description
NO_OF_READY_RECORDS	NUMBER		Description
COLLECTION_REQUEST_ID	NUMBER		Description
COLLECTION_CONC_ID	NUMBER		Description
OBJECT_NAME	VARCHAR2	(400)	Description
OBJECT_TYPE	VARCHAR2	(100)	Description
COLLECTION_START_DATE	DATE		Description
COLLECTION_END_DATE	DATE		Description
NO_ACTUALLY_COLLECTED	NUMBER		Description
NO_OF_SUCC_PROCESSED_RECORDS	NUMBER		Description
COLLECTION_STATUS	VARCHAR2	(40)	Description
COLLECTION_EXCEPTION_MESSAGE	VARCHAR2	(4000)	Description
CREATION_DATE	DATE		Standard who column - date when this row was created.
CREATED_BY	NUMBER		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_BY	NUMBER		Description
COLLECTION_CONCURRENT_ID	NUMBER		Description
LOAD_PK	NUMBER		Description
NUMBER_INSERT	NUMBER		Description
NUMBER_UPDATE	NUMBER		Description
NUMBER_DELETE	NUMBER		Description
OBJECT_ID	NUMBER	(9)	Description

Query Text

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


SELECT COLL_LOG_FK
,      NO_OF_READY_RECORDS
,      COLLECTION_REQUEST_ID
,      COLLECTION_CONC_ID
,      OBJECT_NAME
,      OBJECT_TYPE
,      COLLECTION_START_DATE
,      COLLECTION_END_DATE
,      NO_ACTUALLY_COLLECTED
,      NO_OF_SUCC_PROCESSED_RECORDS
,      COLLECTION_STATUS
,      COLLECTION_EXCEPTION_MESSAGE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_BY
,      COLLECTION_CONCURRENT_ID
,      LOAD_PK
,      NUMBER_INSERT
,      NUMBER_UPDATE
,      NUMBER_DELETE
,      OBJECT_ID
FROM BIS.EDW_COLLECTION_DETAIL_LOG;

Dependencies

[top of page]

BIS.EDW_COLLECTION_DETAIL_LOG does not reference any database object

BIS.EDW_COLLECTION_DETAIL_LOG is referenced by following:

APPS: EDW_COLLECTION_DETAIL_LOG