APPS.WF_ENGINE dependencies on WF_ITEM_ACTIVITY_STATUSES_H

Line 4468: FROM wf_notifications wn, WF_ITEM_ACTIVITY_STATUSES_H iash

4464: AND ias.notification_id = wn.group_id
4465: AND wn.status = 'OPEN'
4466: UNION
4467: SELECT wn.notification_id
4468: FROM wf_notifications wn, WF_ITEM_ACTIVITY_STATUSES_H iash
4469: WHERE iash.item_type = itemtype
4470: AND iash.item_key = itemkey
4471: AND iash.notification_id is not null
4472: AND iash.notification_id = wn.notification_id

Line 5197: from wf_item_activity_statuses_h

5193: ASSIGNED_USER, NOTIFICATION_ID,
5194: BEGIN_DATE, END_DATE, EXECUTION_TIME,
5195: ERROR_NAME, ERROR_MESSAGE, ERROR_STACK,
5196: OUTBOUND_QUEUE_ID, DUE_DATE
5197: from wf_item_activity_statuses_h
5198: where item_type = itemtype
5199: and item_key = copy_itemkey;
5200:
5201:

Line 5416: insert into wf_item_activity_statuses_h

5412: hist.item_key, itemkey, nid);
5413: end if;
5414:
5415: -- now insert the status
5416: insert into wf_item_activity_statuses_h
5417: (ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY,
5418: ACTIVITY_STATUS, ACTIVITY_RESULT_CODE,
5419: ASSIGNED_USER, NOTIFICATION_ID,
5420: BEGIN_DATE, END_DATE, EXECUTION_TIME,

Line 7319: FROM wf_item_activity_statuses_h wiash

7315: AND wias.process_activity = wpa.instance_id
7316: AND wias.activity_status = 'ERROR'
7317: AND x_max_retry >=
7318: (SELECT count(1)
7319: FROM wf_item_activity_statuses_h wiash
7320: WHERE wiash.item_type = wias.item_type
7321: AND wiash.item_key = wias.item_key
7322: AND wiash.process_activity = wias.process_activity
7323: AND wiash.action = 'RETRY');