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_PUSH_DETAIL_LOG_V

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

View Text

SELECT 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

Columns

Name
INSTANCE_CODE
PUSH_CONCURRENT_ID
OBJECT_TYPE
PUSH_STATUS
PUSH_START_DATE
PUSH_END_DATE
WH_PUSH_START_DATE
WH_PUSH_END_DATE
NO_OF_PUSHED_RECORDS
PUSH_EXCEPTION_MESSAGE
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
LAST_UPDATE_BY
PERIOD_START
PERIOD_END
PUSH_LOG_PK
OBJECT_NAME