DBA Data[Home] [Help]

APPS.IEX_UWQ_POP_SUM_TBL_PVT dependencies on IEX_STRATEGY_WORK_ITEMS

Line 4638: iex_strategy_work_items wkitem,

4634: wkitem.execute_end end_time, -- snuthala 28/08/2008 bug #6745580
4635: wkitem.work_item_order wkitem_order,
4636: wkitem.escalated_yn --Added for bug#6981126 by schekuri on 27-Jul-2008
4637: from iex_strategies strat,
4638: iex_strategy_work_items wkitem,
4639: iex_stry_temp_work_items_b stry_temp_wkitem,
4640: IEX_DLN_UWQ_SUMMARY sum
4641: where strat.jtf_object_type = 'PARTY'
4642: AND strat.status_code IN('OPEN', 'ONHOLD')

Line 4673: iex_strategy_work_items wkitem,

4669: wkitem.execute_end end_time, -- snuthala 28/08/2008 bug #6745580
4670: wkitem.work_item_order wkitem_order,
4671: wkitem.escalated_yn --Added for bug#6981126 by schekuri on 27-Jul-2008
4672: from iex_strategies strat,
4673: iex_strategy_work_items wkitem,
4674: iex_stry_temp_work_items_b stry_temp_wkitem,
4675: IEX_DLN_UWQ_SUMMARY sum
4676: where strat.jtf_object_type ='IEX_ACCOUNT'
4677: AND strat.status_code IN('OPEN', 'ONHOLD')

Line 4708: iex_strategy_work_items wkitem,

4704: wkitem.execute_end end_time, -- snuthala 28/08/2008 bug #6745580
4705: wkitem.work_item_order wkitem_order,
4706: wkitem.escalated_yn --Added for bug#6981126 by schekuri on 27-Jul-2008
4707: from iex_strategies strat,
4708: iex_strategy_work_items wkitem,
4709: iex_stry_temp_work_items_b stry_temp_wkitem,
4710: IEX_DLN_UWQ_SUMMARY sum
4711: where strat.jtf_object_type = 'IEX_BILLTO'
4712: AND strat.status_code IN('OPEN', 'ONHOLD')

Line 9699: iex_strategy_work_items wkitem,

9695: wkitem.execute_end end_time, -- snuthala 28/08/2008 bug #6745580
9696: wkitem.work_item_order wkitem_order,
9697: wkitem.escalated_yn --Added for bug#6981126 by schekuri on 27-Jul-2008
9698: from iex_strategies strat,
9699: iex_strategy_work_items wkitem,
9700: iex_stry_temp_work_items_b stry_temp_wkitem,
9701: iex_pop_uwq_summ_gt temp
9702: where strat.jtf_object_type = temp.object_type
9703: AND strat.status_code IN('OPEN', 'ONHOLD')

Line 11025: iex_strategy_work_items wkitem,

11021: wkitem.execute_end end_time,-- snuthala 28/08/2008 bug #6745580
11022: wkitem.work_item_order wkitem_order,
11023: wkitem.escalated_yn --Added for bug#6981126 by schekuri on 27-Jul-2008
11024: from iex_strategies strat,
11025: iex_strategy_work_items wkitem,
11026: iex_stry_temp_work_items_b stry_temp_wkitem,
11027: iex_pop_uwq_summ_gt temp
11028: where strat.jtf_object_type = temp.object_type
11029: AND strat.status_code IN('OPEN', 'ONHOLD')

Line 12338: iex_strategy_work_items wkitem,

12334: wkitem.execute_end end_time,-- snuthala 28/08/2008 bug #6745580
12335: wkitem.work_item_order wkitem_order,
12336: wkitem.escalated_yn --Added for bug#6981126 by schekuri on 27-Jul-2008
12337: from iex_strategies strat,
12338: iex_strategy_work_items wkitem,
12339: iex_stry_temp_work_items_b stry_temp_wkitem,
12340: iex_pop_uwq_summ_gt temp
12341: where strat.status_code IN('OPEN', 'ONHOLD')
12342: AND wkitem.strategy_id = strat.strategy_id