eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_STRATEGY_DIAG_REPORT dependencies on WF_ITEMS

Line 563: AND not exists ( select 1 from wf_items wf

559: CURSOR c_str_without_wf IS
560: select strategy_id
561: from iex_strategies str
562: where str.status_code IN ('OPEN','ONHOLD')
563: AND not exists ( select 1 from wf_items wf
564: where wf.item_key = str.strategy_id and wf.item_type='IEXSTRY');
565:
566: -- strategies in open or onhold status without work items
567: CURSOR c_str_without_wi IS

Line 582: and not exists ( select 1 from wf_items wf

578: where str.strategy_id = wi.strategy_id
579: and wi.work_item_template_id = witemp.work_item_temp_id
580: and witemp.work_type='AUTOMATIC'
581: and wi.status_code = 'OPEN'
582: and not exists ( select 1 from wf_items wf
583: where wf.item_key = wi.work_item_id
584: and wf.item_type in ('IEXSTFFM','IEXSTCM'));
585:
586: -- strategy work items in error check notify status

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'