DBA Data[Home] [Help]

APPS.IEX_STRATEGY_DIAG_REPORT dependencies on IEX_UTILITIES

Line 308: iex_utilities.get_lookup_meaning('IEX_STRATEGY_WORK_STATUS',swi.status_code) STATUS_MEANING,

304: sty.score_value,
305: tpl.strategy_name,
306: to_char(sty.creation_date , 'YYYY-MM-DD') creation_date,
307: stry_temp_wkitem.name,
308: iex_utilities.get_lookup_meaning('IEX_STRATEGY_WORK_STATUS',swi.status_code) STATUS_MEANING,
309: jtf.source_name
310: from iex_strategies sty,
311: iex_strategy_templates_tl tpl,
312: iex_strategy_work_items swi,

Line 351: iex_utilities.get_lookup_meaning('IEX_STRATEGY_WORK_STATUS',(decode(stry_temp_wkitem.pre_execution_wait,0,'OPEN','PRE-WAIT'))) STATUS_MEANING

347: cursor c_first_work_item (l_sty_template_id number)
348: is
349: select stry_temp_wkitem.name,
350: stry_temp_wkitem.work_item_temp_id,
351: iex_utilities.get_lookup_meaning('IEX_STRATEGY_WORK_STATUS',(decode(stry_temp_wkitem.pre_execution_wait,0,'OPEN','PRE-WAIT'))) STATUS_MEANING
352: from iex_strategy_work_temp_xref xref
353: ,iex_stry_temp_work_items_vl stry_temp_wkitem
354: where xref.work_item_temp_id = stry_temp_wkitem.work_item_temp_id
355: and xref.strategy_temp_id = l_sty_template_id