DBA Data[Home] [Help]

APPS.PO_APPROVAL_LIST_HISTORY_SV dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 217: WF_ITEM_ACTIVITY_STATUSES WIAS

213:
214: SELECT NVL(MAX(wf.notification_id), -9995)
215: INTO x_notification_id
216: FROM WF_NOTIFICATIONS WF,
217: WF_ITEM_ACTIVITY_STATUSES WIAS
218: WHERE WIAS.ITEM_TYPE = itemtype AND
219: WIAS.ITEM_KEY = itemkey AND
220: WIAS.NOTIFICATION_ID = WF.group_id;
221: