IEX_STRATEGY_TEMPLATES

Details

Schema: FUSION
Object owner: IEX
Object type: VIEW

Columns

Name
STRATEGY_TEMP_ID STRATEGY_RANK ENABLED_FLAG CATEGORY_TYPE CATEGORY_TYPE_MEANING CHANGE_STRATEGY_YN CHECK_LIST_YN VALID_FROM_DT VALID_TO_DT OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN REQUEST_ID PROGRAM_APPLICATION_ID PROGRAM_ID PROGRAM_UPDATE_DATE STRATEGY_TEMP_GROUP_ID OBJECT_FILTER_ID STRATEGY_NAME CHECK_LIST_TEMP_ID STRATEGY_LEVEL SCORE_TOLERANCE GROUP_SUBNAME STRATEGY_ORDER_ID

Name

STRATEGY_TEMP_ID

STRATEGY_RANK

ENABLED_FLAG

CATEGORY_TYPE

CATEGORY_TYPE_MEANING

CHANGE_STRATEGY_YN

CHECK_LIST_YN

VALID_FROM_DT

VALID_TO_DT

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

REQUEST_ID

PROGRAM_APPLICATION_ID

PROGRAM_ID

PROGRAM_UPDATE_DATE

STRATEGY_TEMP_GROUP_ID

OBJECT_FILTER_ID

STRATEGY_NAME

CHECK_LIST_TEMP_ID

STRATEGY_LEVEL

SCORE_TOLERANCE

GROUP_SUBNAME

STRATEGY_ORDER_ID

Query

SQL_Statement
SELECT B.STRATEGY_TEMP_ID STRATEGY_TEMP_ID, B.STRATEGY_RANK STRATEGY_RANK, B.ENABLED_FLAG ENABLED_FLAG, B.CATEGORY_TYPE CATEGORY_TYPE, LK.MEANING CATEGORY_TYPE_MEANING, B.CHANGE_STRATEGY_YN CHANGE_STRATEGY_YN, B.CHECK_LIST_YN CHECK_LIST_YN, B.VALID_FROM_DT VALID_FROM_DT, B.VALID_TO_DT VALID_TO_DT, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.REQUEST_ID REQUEST_ID, B.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, B.PROGRAM_ID PROGRAM_ID, B.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, B.STRATEGY_TEMP_GROUP_ID STRATEGY_TEMP_GROUP_ID, B.OBJECT_FILTER_ID OBJECT_FILTER_ID, TL.STRATEGY_NAME STRATEGY_NAME, B.CHECK_LIST_TEMP_ID CHECK_LIST_TEMP_ID, B.STRATEGY_LEVEL STRATEGY_LEVEL, B.SCORE_TOLERANCE SCORE_TOLERANCE, B.group_subname group_subname, B.strategy_order_id strategy_order_id FROM IEX_STRATEGY_TEMPLATES_B B ,IEX_STRATEGY_TEMPLATES_TL TL ,IEX_LOOKUPS_V LK WHERE B.strategy_temp_id =TL.strategy_temp_id and TL.LANGUAGE = userenv('LANG') and LK.lookup_code = B.category_type and LK.lookup_type = 'IEX_DELINQUENCY_STATUS' and LK.enabled_flag = 'Y'

SQL_Statement

SELECT B.STRATEGY_TEMP_ID STRATEGY_TEMP_ID, B.STRATEGY_RANK STRATEGY_RANK, B.ENABLED_FLAG ENABLED_FLAG, B.CATEGORY_TYPE CATEGORY_TYPE, LK.MEANING CATEGORY_TYPE_MEANING, B.CHANGE_STRATEGY_YN CHANGE_STRATEGY_YN, B.CHECK_LIST_YN CHECK_LIST_YN, B.VALID_FROM_DT VALID_FROM_DT, B.VALID_TO_DT VALID_TO_DT, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.REQUEST_ID REQUEST_ID, B.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, B.PROGRAM_ID PROGRAM_ID, B.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, B.STRATEGY_TEMP_GROUP_ID STRATEGY_TEMP_GROUP_ID, B.OBJECT_FILTER_ID OBJECT_FILTER_ID, TL.STRATEGY_NAME STRATEGY_NAME, B.CHECK_LIST_TEMP_ID CHECK_LIST_TEMP_ID, B.STRATEGY_LEVEL STRATEGY_LEVEL, B.SCORE_TOLERANCE SCORE_TOLERANCE, B.group_subname group_subname, B.strategy_order_id strategy_order_id FROM IEX_STRATEGY_TEMPLATES_B B ,IEX_STRATEGY_TEMPLATES_TL TL ,IEX_LOOKUPS_V LK WHERE B.strategy_temp_id =TL.strategy_temp_id and TL.LANGUAGE = userenv('LANG') and LK.lookup_code = B.category_type and LK.lookup_type = 'IEX_DELINQUENCY_STATUS' and LK.enabled_flag = 'Y'