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: JTF_IMP_SSUMMARY_VL

Product:	JTF - CRM Foundation
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT X.SNAPSHOT_ID SNAPSHOT_ID
, X.SNAPSHOT_NAME SNAPSHOT_NAME
, X.SNAPSHOT_TYPE SNAPSHOT_TYPE
, X.APPL_TOP_ID APPL_TOP_ID
, Y.NAME APPL_TOP_NAME
, Y.DESCRIPTION APPL_TOP_DESC FROM AD_SNAPSHOTS X
, AD_APPL_TOPS Y
WHERE X.APPL_TOP_ID = Y.APPL_TOP_ID(+)

Columns

Name
SNAPSHOT_ID
SNAPSHOT_NAME
SNAPSHOT_TYPE
APPL_TOP_ID
APPL_TOP_NAME
APPL_TOP_DESC