APPS.IEX_STRATEGY_DIAG_REPORT dependencies on IEX_STRY_TEMP_WORK_ITEMS_B

Line 577: from iex_strategies str, iex_strategy_work_items wi , IEX_STRY_TEMP_WORK_ITEMS_B witemp

573:
574: -- strategy work items of type automatic and open status without work flow
575: CURSOR c_strwi_witout_fulwf IS
576: select str.strategy_id
577: from iex_strategies str, iex_strategy_work_items wi , IEX_STRY_TEMP_WORK_ITEMS_B witemp
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'

Line 597: from iex_strategies str, iex_strategy_work_items wi , iex_stry_temp_work_items_b witemp

593:
594: -- work items of type automatic in open status for more than 2 days
595: CURSOR c_str_automatic_wait IS
596: select str.strategy_id
597: from iex_strategies str, iex_strategy_work_items wi , iex_stry_temp_work_items_b witemp
598: where str.strategy_id = wi.strategy_id
599: and wi.work_item_template_id = witemp.work_item_temp_id
600: and witemp.work_type = 'AUTOMATIC'
601: and wi.status_code in 'OPEN'

Line 607: from IEX_STRY_TEMP_WORK_ITEMS_B

603:
604: -- work item templates of type automatic and category email or fax without xdo template
605: CURSOR c_witemp_without_xdo IS
606: select work_item_temp_id
607: from IEX_STRY_TEMP_WORK_ITEMS_B
608: where work_type = 'AUTOMATIC'
609: AND category_type IN ('EMAIL','FAX')
610: and xdo_template_id is null;
611:

Line 615: from IEX_STRY_TEMP_WORK_ITEMS_B

611:
612: -- work item templates of type custom work flow without work flow name
613: CURSOR c_witemp_without_wf IS
614: select work_item_temp_id
615: from IEX_STRY_TEMP_WORK_ITEMS_B
616: where work_type='WORKFLOW'
617: and category_type='WORKFLOW' and workflow_item_type is null;
618:
619: -- strategies in open or onhold status with work flow error no performer

Line 669: (select 1 from IEX_STRY_TEMP_WORK_ITEMS_B wt

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
669: (select 1 from IEX_STRY_TEMP_WORK_ITEMS_B wt
670: where wt.work_item_temp_id=wi.work_item_template_id
671: and wt.xdo_template_id is not null);
672:
673:

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 892: (select 1 from IEX_STRY_TEMP_WORK_ITEMS_B wt

888: and iexst.cust_account_id = acct.cust_account_id (+)
889: and iexst.strategy_template_id = stytm.strategy_temp_id
890: and wi.work_item_template_id = stry_temp_wkitem.work_item_temp_id
891: and exists
892: (select 1 from IEX_STRY_TEMP_WORK_ITEMS_B wt
893: where wt.work_item_temp_id=wi.work_item_template_id
894: and wt.xdo_template_id is not null)
895: AND wi.work_item_id = p_work_item_id;
896: