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.

VIEW: APPLSYS.AD_CHECK_FILE_TEMP#

Source

View Text - Preformatted


select APP_SHORT_NAME APP_SHORT_NAME, SUBDIR SUBDIR, FILENAME FILENAME, MANIFEST_VERS MANIFEST_VERS, TRANSLATION_LEVEL TRANSLATION_LEVEL, EFFECTIVE_DATE EFFECTIVE_DATE, DISTINGUISHER DISTINGUISHER, JUNK JUNK, FILE_ID FILE_ID, FILE_VERSION_ID FILE_VERSION_ID, CHECK_FILE_ID CHECK_FILE_ID, MANIFEST_VERS_HIGHER MANIFEST_VERS_HIGHER, ACTIVE_FLAG ACTIVE_FLAG, MANIFEST_VERS_2 MANIFEST_VERS_2, FILE_VERSION_ID_2 FILE_VERSION_ID_2, APP_SHORT_NAME_1 APP_SHORT_NAME_1, SUBDIR_1 SUBDIR_1, FILENAME_1 FILENAME_1, FILE_SIZE FILE_SIZE, CHECK_SUM CHECK_SUM, INCONSISTENT_FLAG INCONSISTENT_FLAG, APPL_TOP_ID APPL_TOP_ID, DEST_FILE_ID DEST_FILE_ID, DEST_APPS_SHORT_NAME DEST_APPS_SHORT_NAME, DEST_SUBDIR DEST_SUBDIR, DEST_FILENAME DEST_FILENAME, FILE_TYPE_FLAG FILE_TYPE_FLAG, SERVER_TYPE_ADMIN_FLAG SERVER_TYPE_ADMIN_FLAG, SERVER_TYPE_FORMS_FLAG SERVER_TYPE_FORMS_FLAG, SERVER_TYPE_NODE_FLAG SERVER_TYPE_NODE_FLAG, SERVER_TYPE_WEB_FLAG SERVER_TYPE_WEB_FLAG, LANGUAGE LANGUAGE from "APPLSYS"."AD_CHECK_FILE_TEMP"

View Text - HTML Formatted

SELECT APP_SHORT_NAME APP_SHORT_NAME
, SUBDIR SUBDIR
, FILENAME FILENAME
, MANIFEST_VERS MANIFEST_VERS
, TRANSLATION_LEVEL TRANSLATION_LEVEL
, EFFECTIVE_DATE EFFECTIVE_DATE
, DISTINGUISHER DISTINGUISHER
, JUNK JUNK
, FILE_ID FILE_ID
, FILE_VERSION_ID FILE_VERSION_ID
, CHECK_FILE_ID CHECK_FILE_ID
, MANIFEST_VERS_HIGHER MANIFEST_VERS_HIGHER
, ACTIVE_FLAG ACTIVE_FLAG
, MANIFEST_VERS_2 MANIFEST_VERS_2
, FILE_VERSION_ID_2 FILE_VERSION_ID_2
, APP_SHORT_NAME_1 APP_SHORT_NAME_1
, SUBDIR_1 SUBDIR_1
, FILENAME_1 FILENAME_1
, FILE_SIZE FILE_SIZE
, CHECK_SUM CHECK_SUM
, INCONSISTENT_FLAG INCONSISTENT_FLAG
, APPL_TOP_ID APPL_TOP_ID
, DEST_FILE_ID DEST_FILE_ID
, DEST_APPS_SHORT_NAME DEST_APPS_SHORT_NAME
, DEST_SUBDIR DEST_SUBDIR
, DEST_FILENAME DEST_FILENAME
, FILE_TYPE_FLAG FILE_TYPE_FLAG
, SERVER_TYPE_ADMIN_FLAG SERVER_TYPE_ADMIN_FLAG
, SERVER_TYPE_FORMS_FLAG SERVER_TYPE_FORMS_FLAG
, SERVER_TYPE_NODE_FLAG SERVER_TYPE_NODE_FLAG
, SERVER_TYPE_WEB_FLAG SERVER_TYPE_WEB_FLAG
, LANGUAGE LANGUAGE
FROM "APPLSYS"."AD_CHECK_FILE_TEMP"