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.

[Home] [Help]

View: EDW_COLLECTION_DETAIL_LOG_V

Product:	BIS - Applications BIS
Description:	EDW_COLLECTION_DETAIL_LOG_V
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SELECT LOG.COLLECTION_CONCURRENT_ID
, LOG.OBJECT_TYPE
, LOG.LOAD_PK
, LOG.COLLECTION_START_DATE
, LOG.COLLECTION_END_DATE
, LOG.COLLECTION_STATUS
, LOG.COLLECTION_EXCEPTION_MESSAGE
, LOG.CREATION_DATE
, LOG.CREATED_BY
, LOG.LAST_UPDATE_DATE
, LOG.LAST_UPDATE_LOGIN
, LOG.LAST_UPDATE_BY
, LOG.COLL_LOG_FK
, LOG.NO_OF_READY_RECORDS
, LOG.COLLECTION_REQUEST_ID
, LOG.NO_ACTUALLY_COLLECTED
, LOG.NO_OF_SUCC_PROCESSED_RECORDS
, REL.RELATION_LONG_NAME OBJECT_NAME
FROM EDW_COLLECTION_DETAIL_LOG LOG
, EDW_RELATIONS_MD_V REL
WHERE LOG.OBJECT_NAME=REL.RELATION_NAME WITH READ ONLY

Columns

Name
COLLECTION_CONCURRENT_ID
OBJECT_TYPE
LOAD_PK
COLLECTION_START_DATE
COLLECTION_END_DATE
COLLECTION_STATUS
COLLECTION_EXCEPTION_MESSAGE
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
LAST_UPDATE_BY
COLL_LOG_FK
NO_OF_READY_RECORDS
COLLECTION_REQUEST_ID
NO_ACTUALLY_COLLECTED
NO_OF_SUCC_PROCESSED_RECORDS
OBJECT_NAME