[Home] [Help]
1637: wkitem.execute_end end_time, -- snuthala 28/08/2008 bug #6745580
1638: wkitem.work_item_order wkitem_order,
1639: wkitem.escalated_yn --Added for bug#6981126 by schekuri on 27-Jul-2008
1640: from iex_strategies strat,
1641: iex_strategy_work_items wkitem,
1642: iex_stry_temp_work_items_b stry_temp_wkitem,
1643: IEX_DLN_UWQ_SUMMARY sum
1644: where strat.jtf_object_type = decode(p_level, 'CUSTOMER', 'PARTY', 'ACCOUNT', 'IEX_ACCOUNT', 'BILL_TO', 'IEX_BILLTO')
1645: AND strat.status_code IN('OPEN', 'ONHOLD')
3535: wkitem.execute_end end_time, -- snuthala 28/08/2008 bug #6745580
3536: wkitem.work_item_order wkitem_order,
3537: wkitem.escalated_yn --Added for bug#6981126 by schekuri on 27-Jul-2008
3538: from iex_strategies strat,
3539: iex_strategy_work_items wkitem,
3540: iex_stry_temp_work_items_b stry_temp_wkitem,
3541: iex_pop_uwq_summ_gt temp
3542: where strat.jtf_object_type = temp.object_type
3543: AND strat.status_code IN('OPEN', 'ONHOLD')
4763: wkitem.execute_end end_time,-- snuthala 28/08/2008 bug #6745580
4764: wkitem.work_item_order wkitem_order,
4765: wkitem.escalated_yn --Added for bug#6981126 by schekuri on 27-Jul-2008
4766: from iex_strategies strat,
4767: iex_strategy_work_items wkitem,
4768: iex_stry_temp_work_items_b stry_temp_wkitem,
4769: iex_pop_uwq_summ_gt temp
4770: where strat.jtf_object_type = temp.object_type
4771: AND strat.status_code IN('OPEN', 'ONHOLD')
5986: wkitem.execute_end end_time,-- snuthala 28/08/2008 bug #6745580
5987: wkitem.work_item_order wkitem_order,
5988: wkitem.escalated_yn --Added for bug#6981126 by schekuri on 27-Jul-2008
5989: from iex_strategies strat,
5990: iex_strategy_work_items wkitem,
5991: iex_stry_temp_work_items_b stry_temp_wkitem,
5992: iex_pop_uwq_summ_gt temp
5993: where strat.status_code IN('OPEN', 'ONHOLD')
5994: AND wkitem.strategy_id = strat.strategy_id