DBA Data[Home] [Help]

APPS.AZW_ARCHIVE dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 272: ,wf_notification_attributes wna

268: ,wiasv.activity_end_date end_date
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 (+)

Line 299: ,wf_notification_attributes wna

295: ,wiasv.execution_time
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