DBA Data[Home] [Help]

APPS.WF_MAIL dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 1550: from wf_item_activity_statuses ias

1546: and owner_role is not null
1547: union all
1548: select ntf.begin_date begin_date, ntf.recipient_role role
1549: from (select notification_id
1550: from wf_item_activity_statuses ias
1551: where ias.item_type = itemType
1552: and ias.item_key = itemKey
1553: union all
1554: select notification_id

Line 1555: from wf_item_activity_statuses_h ias

1551: where ias.item_type = itemType
1552: and ias.item_key = itemKey
1553: union all
1554: select notification_id
1555: from wf_item_activity_statuses_h ias
1556: where ias.item_type = itemType
1557: and ias.item_key = itemKey) intf, wf_notifications ntf
1558: where intf.notification_id = ntf.group_id)
1559: where role <> current_role