VIEW: APPS.EDW_PUSH_DETAIL_LOG_V

Source

View Text - Preformatted

SELECT log.INSTANCE_CODE , log.PUSH_CONCURRENT_ID , log.OBJECT_TYPE , log.PUSH_STATUS , log.PUSH_START_DATE , log.PUSH_END_DATE , log.WH_PUSH_START_DATE , log.WH_PUSH_END_DATE , log.NO_OF_PUSHED_RECORDS , log.PUSH_EXCEPTION_MESSAGE , log.CREATION_DATE , log.CREATED_BY , log.LAST_UPDATE_DATE , log.LAST_UPDATE_LOGIN , log.LAST_UPDATE_BY , log.PERIOD_START , log.PERIOD_END , log.PUSH_LOG_PK, rel.relation_long_name object_name from edw_push_detail_log log, edw_relations_md_v rel WHERE log.object_name=rel.relation_name with read only

View Text - HTML Formatted

SELECT LOG.INSTANCE_CODE
, LOG.PUSH_CONCURRENT_ID
, LOG.OBJECT_TYPE
, LOG.PUSH_STATUS
, LOG.PUSH_START_DATE
, LOG.PUSH_END_DATE
, LOG.WH_PUSH_START_DATE
, LOG.WH_PUSH_END_DATE
, LOG.NO_OF_PUSHED_RECORDS
, LOG.PUSH_EXCEPTION_MESSAGE
, LOG.CREATION_DATE
, LOG.CREATED_BY
, LOG.LAST_UPDATE_DATE
, LOG.LAST_UPDATE_LOGIN
, LOG.LAST_UPDATE_BY
, LOG.PERIOD_START
, LOG.PERIOD_END
, LOG.PUSH_LOG_PK
, REL.RELATION_LONG_NAME OBJECT_NAME
FROM EDW_PUSH_DETAIL_LOG LOG
, EDW_RELATIONS_MD_V REL
WHERE LOG.OBJECT_NAME=REL.RELATION_NAME WITH READ ONLY