WF_ITEM_ACTIVITY_STATUSES_V. This view contains denormalized information about a workflow process and its activities’ statuses. Use this view to create custom queries and reports on the status of a particular item or process. The following table describes the columns of the view.
Description. Deletes from the tables WF_ITEM_ACTIVITY_STATUSES and WF_ITEM_ACTIVITY_STATUSES_H all rows of data associated with the specified item type and whose value for END_DATE is less than or equal to the specified end date. Arguments (input) itemtypeItem type associated with the activity statuses you want to delete. Leave this argument null …
4/27/2014 · The WF_ITEM_ACTIVITY_STATUSES TABLE is the runtime table for a work item. Each row includes the start and end date, result code, and any error information an activity generates. ITEM_TYPE (PK), ITEM_KEY (PK), PROCESS_ACTIVITY (PK), 7/30/2015 · WF_ITEM_ACTIVITY_STATUSES: The WF_ITEM_ACTIVITY_STATUSES TABLE is the runtime table for a work item. Each row includes the start and end date, result code, and any error information an activity generates. WF_ITEM_ACTIVITY_STATUSES_H: The WF_ITEM_ACTIVITY_STATUSES_H table stores the history of the.
The WF_ ITEM_ACTIVITY _STATUSES_H – It stores the history of the WF_ ITEM_ACTIVITY _STATUSES table. ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY. WF_NOTIFICATIONS. WF_NOTIFICATIONS – It containds the runtime information about a specific instance of a sent message. A new row is created in the table each time a message is sent.
7/17/2016 · a .wf_ item_activity _statuses_n1 b. wf_ item_activity _statuses_n3 c. wf_ item_activity _statuses_pk d. wf_ item_activity _statuses_n2 e. wf_ item_activity _statuses_n4 f. wf_item_attribute_values_pk g. wf_notifications_attr_pk, 10/12/2015 · from wf_notifications wn, wf_ item_activity _statuses wias where wn.group_id = wias.notification_id and wias.item_type = ‘&item_type’ and wias.item_key = ‘&item_key’; / SQL Query To Find the Activity Statuses For All Workflow Activities For A Particular Item Type and Item key: SELECT execution_time, to_char(ias.begin_date,, 7/7/2010 · WF_ ITEM_ACTIVITY _STATUSES_H. The WF_ ITEM_ACTIVITY _STATUSES_H table stores the history of the WF_ ITEM_ACTIVITY _STATUSES table. ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY. WF_PROCESS_ACTIVITIES. WF_PROCESS_ACTIVITIES stores the data for an activity within a specific process.
5/17/2017 · from wf_ item_activity _statuses where item_type = ‘erp’ and item_key =’63865′) select * from wf_item_types select * from wf_lookups_tl select * from wf_notifications where message_type =’erp’ order by begin_date desc select * from wf_notification_attributes select * from wf_messages, Select * from wf_ item_activity _statuses where item_type= ‘APINVAPR’ AND TRUNC(BEGIN_DATE)=TRUNC(SYSDATE) Or. Select Invoice_id from ap_invoices_all where invoice_num=’test19sep10′ From above query will get a invoice_id(1524287) Select * from wf_ item_activity _statuses where item_key like ‘1524287%’ …
