DBA Data[Home] [Help]

APPS.WF_ADVANCED_WORKLIST dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 56: from wf_item_activity_statuses ias,

52: select 1
53: into dummy
54: from sys.dual
55: where exists ( select null
56: from wf_item_activity_statuses ias,
57: wf_item_activity_statuses_h iash,
58: wf_notifications ntf
59: where ntf.status = 'OPEN'
60: and ias.notification_id = ntf.notification_id

Line 57: wf_item_activity_statuses_h iash,

53: into dummy
54: from sys.dual
55: where exists ( select null
56: from wf_item_activity_statuses ias,
57: wf_item_activity_statuses_h iash,
58: wf_notifications ntf
59: where ntf.status = 'OPEN'
60: and ias.notification_id = ntf.notification_id
61: and ias.item_type = iash.item_type