APPS.IEX_STRATEGY_DIAG_REPORT dependencies on IEX_STRY_TEMP_WORK_ITEMS_VL

Line 313: iex_stry_temp_work_items_vl stry_temp_wkitem,

309: jtf.source_name
310: from iex_strategies sty,
311: iex_strategy_templates_tl tpl,
312: iex_strategy_work_items swi,
313: iex_stry_temp_work_items_vl stry_temp_wkitem,
314: jtf_rs_resource_extns jtf
315: where sty.strategy_id = p_strategy_id
316: and sty.strategy_template_id = tpl.strategy_temp_id
317: and tpl.language = userenv('LANG')

Line 353: ,iex_stry_temp_work_items_vl stry_temp_wkitem

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
356: and stry_temp_wkitem.language = userenv('LANG')
357: order by xref.work_item_order;

Line 653: iex_strategies str,iex_strategy_work_items wi, iex_stry_temp_work_items_vl wit, wf_items wfi

649:
650: -- strategy work items with IEXSTFFM work flow and work item template is not automatic
651: CURSOR c_wi_wf_not_auto IS
652: select str.strategy_id from
653: iex_strategies str,iex_strategy_work_items wi, iex_stry_temp_work_items_vl wit, wf_items wfi
654: where str.strategy_id = wi.strategy_id
655: and str.status_code in ('OPEN','ONHOLD')
656: and wi.work_item_template_id = wit.work_item_temp_id
657: and wit.work_type <> 'AUTOMATIC'

Line 664: from iex_strategy_work_items wi,iex_dunnings dunn ,iex_stry_temp_work_items_vl stry_temp_wkitem

660:
661: -- automatic work items processed in sysdate
662: CURSOR c_auto_wi_processed IS
663: Select wi.work_item_id
664: from iex_strategy_work_items wi,iex_dunnings dunn ,iex_stry_temp_work_items_vl stry_temp_wkitem
665: where wi.last_update_date>(sysdate-1)
666: and dunn.object_id (+) = wi.work_item_id
667: and wi.work_item_template_id = stry_temp_wkitem.work_item_temp_id
668: and exists

Line 823: from IEX_STRY_TEMP_WORK_ITEMS_B ist , IEX_STRY_TEMP_WORK_ITEMS_VL istv

819: PROCEDURE gen_xml_body_wi (p_work_item_temp_id NUMBER , p_wi_temp_status VARCHAR2)
820: IS
821: CURSOR c_wi_temp(p_wi_temp_id number) IS
822: select ist.work_item_temp_id , istv.name,to_char(ist.creation_date , 'YYYY-MM-DD') creation_date, ist.work_type,ist.category_type,ist.xdo_template_id,ist.workflow_item_type
823: from IEX_STRY_TEMP_WORK_ITEMS_B ist , IEX_STRY_TEMP_WORK_ITEMS_VL istv
824: where ist.work_item_temp_id = istv.work_item_temp_id
825: and ist.work_item_temp_id = p_wi_temp_id;
826:
827: l_wi_temp_id NUMBER;

Line 883: iex_stry_temp_work_items_vl stry_temp_wkitem

879: stry_temp_wkitem.name workitem_name
880: from iex_strategies iexst, iex_strategy_work_items wi,
881: hz_parties hzp, hz_cust_accounts acct, iex_dunnings dunn ,
882: iex_strategy_templates_vl stytm,
883: iex_stry_temp_work_items_vl stry_temp_wkitem
884: where wi.last_update_date>(sysdate-1)
885: and wi.strategy_id = iexst.strategy_id
886: AND hzp.party_id = iexst.party_id
887: and dunn.object_id (+) = wi.work_item_id