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: AMS.AMS_LIST_SELECT_ACTIONS#

Source

View Text - Preformatted


select LIST_SELECT_ACTION_ID LIST_SELECT_ACTION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LIST_HEADER_ID LIST_HEADER_ID, ORDER_NUMBER ORDER_NUMBER, LIST_ACTION_TYPE LIST_ACTION_TYPE, INCL_OBJECT_NAME INCL_OBJECT_NAME, ARC_INCL_OBJECT_FROM ARC_INCL_OBJECT_FROM, INCL_OBJECT_ID INCL_OBJECT_ID, INCL_OBJECT_WB_SHEET INCL_OBJECT_WB_SHEET, INCL_OBJECT_WB_OWNER INCL_OBJECT_WB_OWNER, INCL_OBJECT_CELL_CODE INCL_OBJECT_CELL_CODE, RANK RANK, NO_OF_ROWS_AVAILABLE NO_OF_ROWS_AVAILABLE, NO_OF_ROWS_REQUESTED NO_OF_ROWS_REQUESTED, NO_OF_ROWS_USED NO_OF_ROWS_USED, DISTRIBUTION_PCT DISTRIBUTION_PCT, RESULT_TEXT RESULT_TEXT, DESCRIPTION DESCRIPTION, SECURITY_GROUP_ID SECURITY_GROUP_ID, ARC_ACTION_USED_BY ARC_ACTION_USED_BY, ACTION_USED_BY_ID ACTION_USED_BY_ID, INCL_CONTROL_GROUP INCL_CONTROL_GROUP, NO_OF_ROWS_TARGETED NO_OF_ROWS_TARGETED, NO_OF_ROWS_DUPLICATES NO_OF_ROWS_DUPLICATES, RUNNING_TOTAL RUNNING_TOTAL, DELTA DELTA, ZD_EDITION_NAME ZD_EDITION_NAME from "AMS"."AMS_LIST_SELECT_ACTIONS"

View Text - HTML Formatted

SELECT LIST_SELECT_ACTION_ID LIST_SELECT_ACTION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LIST_HEADER_ID LIST_HEADER_ID
, ORDER_NUMBER ORDER_NUMBER
, LIST_ACTION_TYPE LIST_ACTION_TYPE
, INCL_OBJECT_NAME INCL_OBJECT_NAME
, ARC_INCL_OBJECT_FROM ARC_INCL_OBJECT_FROM
, INCL_OBJECT_ID INCL_OBJECT_ID
, INCL_OBJECT_WB_SHEET INCL_OBJECT_WB_SHEET
, INCL_OBJECT_WB_OWNER INCL_OBJECT_WB_OWNER
, INCL_OBJECT_CELL_CODE INCL_OBJECT_CELL_CODE
, RANK RANK
, NO_OF_ROWS_AVAILABLE NO_OF_ROWS_AVAILABLE
, NO_OF_ROWS_REQUESTED NO_OF_ROWS_REQUESTED
, NO_OF_ROWS_USED NO_OF_ROWS_USED
, DISTRIBUTION_PCT DISTRIBUTION_PCT
, RESULT_TEXT RESULT_TEXT
, DESCRIPTION DESCRIPTION
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, ARC_ACTION_USED_BY ARC_ACTION_USED_BY
, ACTION_USED_BY_ID ACTION_USED_BY_ID
, INCL_CONTROL_GROUP INCL_CONTROL_GROUP
, NO_OF_ROWS_TARGETED NO_OF_ROWS_TARGETED
, NO_OF_ROWS_DUPLICATES NO_OF_ROWS_DUPLICATES
, RUNNING_TOTAL RUNNING_TOTAL
, DELTA DELTA
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "AMS"."AMS_LIST_SELECT_ACTIONS"