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: IEX.IEX_STRATEGY_TEMPLATE_GROUPS#

Source

View Text - Preformatted


select STRATEGY_GROUP_ID STRATEGY_GROUP_ID, STRATEGY_GROUP_NAME STRATEGY_GROUP_NAME, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, STRATEGY_TEMP_ID STRATEGY_TEMP_ID, STRATEGY_ORDER_ID STRATEGY_ORDER_ID, GROUP_ID GROUP_ID, GROUP_NAME GROUP_NAME, STRATEGY_RANK STRATEGY_RANK, ENABLED_FLAG ENABLED_FLAG, CATEGORY_TYPE CATEGORY_TYPE, CHANGE_STRATEGY_YN CHANGE_STRATEGY_YN, CHECK_LIST_YN CHECK_LIST_YN, CHECK_LIST_TEMP_ID CHECK_LIST_TEMP_ID, VALID_FROM_DT VALID_FROM_DT, VALID_TO_DT VALID_TO_DT, OBJECT_FILTER_ID OBJECT_FILTER_ID, SCORING_ENGINE_ID SCORING_ENGINE_ID, STRATEGY_LEVEL STRATEGY_LEVEL, SCORE_TOLERANCE SCORE_TOLERANCE, ZD_EDITION_NAME ZD_EDITION_NAME from "IEX"."IEX_STRATEGY_TEMPLATE_GROUPS"

View Text - HTML Formatted

SELECT STRATEGY_GROUP_ID STRATEGY_GROUP_ID
, STRATEGY_GROUP_NAME STRATEGY_GROUP_NAME
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, STRATEGY_TEMP_ID STRATEGY_TEMP_ID
, STRATEGY_ORDER_ID STRATEGY_ORDER_ID
, GROUP_ID GROUP_ID
, GROUP_NAME GROUP_NAME
, STRATEGY_RANK STRATEGY_RANK
, ENABLED_FLAG ENABLED_FLAG
, CATEGORY_TYPE CATEGORY_TYPE
, CHANGE_STRATEGY_YN CHANGE_STRATEGY_YN
, CHECK_LIST_YN CHECK_LIST_YN
, CHECK_LIST_TEMP_ID CHECK_LIST_TEMP_ID
, VALID_FROM_DT VALID_FROM_DT
, VALID_TO_DT VALID_TO_DT
, OBJECT_FILTER_ID OBJECT_FILTER_ID
, SCORING_ENGINE_ID SCORING_ENGINE_ID
, STRATEGY_LEVEL STRATEGY_LEVEL
, SCORE_TOLERANCE SCORE_TOLERANCE
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "IEX"."IEX_STRATEGY_TEMPLATE_GROUPS"