VIEW: APPS.IEX_STRATEGY_TEMPLATES_VL

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'