DBA Data[Home] [Help]

VIEW: APPS.EDW_LOAD_PROGRESS_LOG_V

Source

View Text - Preformatted

SELECT LOG.LOAD_FK , REL.RELATION_LONG_NAME OBJECT_NAME, LOG.SEQ_ID , LOG.OBJ_ID , LOG.LOAD_PROGRESS , LOG.START_DATE , LOG.END_DATE , LOG.CATEGORY , LOG.OPERATION , LOG.LAST_UPDATE_DATE , LOG.CREATION_DATE , LOG.CREATED_BY , LOG.LAST_UPDATE_BY , LOG.LAST_UPDATE_LOGIN from edw_load_progress_log LOG, edw_relations_md_v rel WHERE log.object_name=rel.relation_name with read only
View Text - HTML Formatted

SELECT LOG.LOAD_FK
, REL.RELATION_LONG_NAME OBJECT_NAME
, LOG.SEQ_ID
, LOG.OBJ_ID
, LOG.LOAD_PROGRESS
, LOG.START_DATE
, LOG.END_DATE
, LOG.CATEGORY
, LOG.OPERATION
, LOG.LAST_UPDATE_DATE
, LOG.CREATION_DATE
, LOG.CREATED_BY
, LOG.LAST_UPDATE_BY
, LOG.LAST_UPDATE_LOGIN
FROM EDW_LOAD_PROGRESS_LOG LOG
, EDW_RELATIONS_MD_V REL
WHERE LOG.OBJECT_NAME=REL.RELATION_NAME WITH READ ONLY