DBA Data[Home] [Help]

APPS.IEX_STRATEGY_CNT_PUB dependencies on IEX_STRY_TEMP_WORK_ITEMS_VL

Line 3615: iex_stry_temp_work_items_vl stry_temp_wkitem,

3611: sty.strategy_level strategy_level
3612: from iex_strategies sty,
3613: iex_strategy_templates_tl tpl,
3614: iex_strategy_work_items swi,
3615: iex_stry_temp_work_items_vl stry_temp_wkitem,
3616: jtf_rs_resource_extns jtf
3617: where sty.strategy_id = p_strategy_id
3618: and sty.strategy_template_id = tpl.strategy_temp_id
3619: and tpl.language = userenv('LANG')

Line 3661: ,iex_stry_temp_work_items_vl stry_temp_wkitem

3657: select stry_temp_wkitem.name,
3658: stry_temp_wkitem.work_item_temp_id,
3659: iex_utilities.get_lookup_meaning('IEX_STRATEGY_WORK_STATUS',(decode(stry_temp_wkitem.pre_execution_wait,0,'OPEN','PRE-WAIT'))) STATUS_MEANING
3660: from iex_strategy_work_temp_xref xref
3661: ,iex_stry_temp_work_items_vl stry_temp_wkitem
3662: where xref.work_item_temp_id = stry_temp_wkitem.work_item_temp_id
3663: and xref.strategy_temp_id = l_sty_template_id
3664: and stry_temp_wkitem.language = userenv('LANG')
3665: order by xref.work_item_order;