DBA Data[Home] [Help]

APPS.AZW_ARCHIVE dependencies on WF_NOTIFICATIONS

Line 273: ,wf_notifications wn

269: ,wiasv.execution_time
270: ,wn.user_comment
271: FROM wf_item_activity_statuses_v wiasv
272: ,wf_notification_attributes wna
273: ,wf_notifications wn
274: WHERE wiasv.item_type = l_item_type
275: AND wiasv.item_key = l_item_key
276: AND wiasv.notification_id = wn.notification_id (+)
277: AND wn.notification_id = wna.notification_id (+)

Line 300: ,wf_notifications wn

296: ,wn.user_comment
297: FROM wf_item_activities_history_v wiasv
298: ,wf_item_activity_statuses_h wiash
299: ,wf_notification_attributes wna
300: ,wf_notifications wn
301: WHERE wiasv.item_type = l_item_type
302: AND wiasv.item_key = l_item_key
303: AND wiasv.item_type = wiash.item_type
304: AND wiasv.item_key = wiash.item_key