DBA Data[Home] [Help]

APPS.IEX_STRATEGY_DIAG_REPORT dependencies on WF_ITEM_ACTIVITY_STATUSES_V

Line 625: WF_ITEM_ACTIVITY_STATUSES_V wfia

621: CURSOR c_wi_no_performer IS
622: select b.strategy_id
623: from iex_strategy_work_items wi,
624: IEX_STRATEGIES b,
625: WF_ITEM_ACTIVITY_STATUSES_V wfia
626: where wi.work_item_id = wfia.item_key
627: and wfia.item_type='IEXSTFFM'
628: and wfia.activity_label = 'FULFILLMENT FAILED'
629: and wfia.error_name ='WFENG_NOTIFICATION_PERFORMER'

Line 639: WF_ITEM_ACTIVITY_STATUSES_V wfia,

635:
636: CURSOR c_wi_no_role IS
637: select str.strategy_id
638: from iex_strategy_work_items wi,
639: WF_ITEM_ACTIVITY_STATUSES_V wfia,
640: iex_strategies str
641: where wi.work_item_id = wfia.item_key
642: and wfia.error_name = 'WFNTF_ROLE'
643: and wfia.activity_status_code='ERROR'