DBA Data[Home] [Help]

APPS.ENG_WORKFLOW_UTIL dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 1916: from WF_ITEM_ACTIVITY_STATUSES WIAS

1912: -- , WIAS.DUE_DATE,
1913: -- , WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE,
1914: -- , WIAS.ERROR_STACK
1915: into x_activity_status
1916: from WF_ITEM_ACTIVITY_STATUSES WIAS
1917: , WF_PROCESS_ACTIVITIES PA
1918: , WF_ACTIVITIES A
1919: where WIAS.ITEM_TYPE = p_item_type
1920: and WIAS.ITEM_KEY = p_item_key

Line 8309: FROM WF_ITEM_ACTIVITY_STATUSES wias,

8305: SELECT ntf.NOTIFICATION_ID,
8306: ntf.RECIPIENT_ROLE,
8307: ntf.MESSAGE_NAME,
8308: ntf.message_type
8309: FROM WF_ITEM_ACTIVITY_STATUSES wias,
8310: WF_NOTIFICATIONS ntf ,
8311: WF_NOTIFICATIONS orig_ntf
8312: WHERE ntf.STATUS = 'OPEN'
8313: AND wias.NOTIFICATION_ID = ntf.group_id

Line 11132: FROM WF_ITEM_ACTIVITY_STATUSES wias,

11128: SELECT ntf.NOTIFICATION_ID,
11129: ntf.RECIPIENT_ROLE,
11130: ntf.MESSAGE_NAME,
11131: ntf.message_type
11132: FROM WF_ITEM_ACTIVITY_STATUSES wias,
11133: WF_NOTIFICATIONS ntf
11134: WHERE ntf.STATUS = 'OPEN'
11135: AND wias.NOTIFICATION_ID = ntf.group_id
11136: AND wias.NOTIFICATION_ID IS NOT NULL