VIEW: APPS.EDW_COLLECTION_DETAIL_LOG_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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