Product: | BIS - Applications BIS |
---|---|
Description: | EDW_COLLECTION_DETAIL_LOG_V |
Implementation/DBA Data: | APPS.EDW_COLLECTION_DETAIL_LOG_V |
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