DBA Data[Home] [Help]

APPS.IEX_UWQ_POP_SUM_TBL_PVT dependencies on IEX_STRY_TEMP_WORK_ITEMS_B

Line 1642: iex_stry_temp_work_items_b stry_temp_wkitem,

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')
1646: AND wkitem.strategy_id = strat.strategy_id

Line 3540: iex_stry_temp_work_items_b stry_temp_wkitem,

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')
3544: AND wkitem.strategy_id = strat.strategy_id

Line 4768: iex_stry_temp_work_items_b stry_temp_wkitem,

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')
4772: AND wkitem.strategy_id = strat.strategy_id

Line 5991: iex_stry_temp_work_items_b stry_temp_wkitem,

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
5995: AND wkitem.status_code IN('OPEN', 'ONHOLD')