DBA Data[Home] [Help]

APPS.WF_ADVANCED_WORKLIST dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 58: from wf_item_activity_statuses ias,

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

Line 59: wf_item_activity_statuses_h iash,

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