DBA Data[Home] [Help]

APPS.IEX_STRATEGY_DIAG_REPORT dependencies on IEX_DUNNINGS

Line 664: from iex_strategy_work_items wi,iex_dunnings dunn ,iex_stry_temp_work_items_vl stry_temp_wkitem

660:
661: -- automatic work items processed in sysdate
662: CURSOR c_auto_wi_processed IS
663: Select wi.work_item_id
664: from iex_strategy_work_items wi,iex_dunnings dunn ,iex_stry_temp_work_items_vl stry_temp_wkitem
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

Line 881: hz_parties hzp, hz_cust_accounts acct, iex_dunnings dunn ,

877: dunn.delivery_status,
878: stytm.strategy_name strategy_name,
879: stry_temp_wkitem.name workitem_name
880: from iex_strategies iexst, iex_strategy_work_items wi,
881: hz_parties hzp, hz_cust_accounts acct, iex_dunnings dunn ,
882: iex_strategy_templates_vl stytm,
883: iex_stry_temp_work_items_vl stry_temp_wkitem
884: where wi.last_update_date>(sysdate-1)
885: and wi.strategy_id = iexst.strategy_id