DBA Data[Home] [Help]

APPS.IEX_UWQ_POP_SUM_TBL_PVT dependencies on IEX_STRY_TEMP_WORK_ITEMS_B

Line 4639: iex_stry_temp_work_items_b stry_temp_wkitem,

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

Line 4674: iex_stry_temp_work_items_b stry_temp_wkitem,

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

Line 4709: iex_stry_temp_work_items_b stry_temp_wkitem,

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

Line 9700: iex_stry_temp_work_items_b stry_temp_wkitem,

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

Line 11026: iex_stry_temp_work_items_b stry_temp_wkitem,

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

Line 12339: iex_stry_temp_work_items_b stry_temp_wkitem,

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