Oracle Apps Workflow Tables…
WF_ACTIVITIES table stores the definition of an activity. Activities can be processes, notifications, functions or folders. A process activity is a modelled workflow process, which can be included as an activity in other processes to represent a subprocess. A notification activity sends a message to a performer. A functions activity performs an automated function that is written as a PL/SQL stored procedure. A folder activity is not part of a process, it provides a means of grouping activities.
WF_ITEMS table is the runtime table for workflow processes. Each row defines one work item within the system.
WF_ITEM_ATTRIBUTES table stores definitions of attributes associated with a process. Each row includes the sequence in which the attribute is used as well as the format of the attribute data.
WF_NOTIFICATIONS table holds 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.
SELECT * FROM wf_user_role_assignments
SELECT * FROM wf_user_roles
SELECT * FROM wf_roles
SELECT * FROM wf_items
SELECT * FROM wf_item_attributes
SELECT * FROM wf_item_attribute_values
SELECT * FROM wf_item_attributes_tl
SELECT * FROM wf_activities
SELECT * FROM wf_activities_tl
SELECT * FROM wf_activity_attributes
SELECT * FROM wf_activity_attributes_tl
SELECT * FROM wf_activity_transitions
SELECT * FROM wf_deferred–wf_control
SELECT * FROM WF_ACTIVITY_ATTR_VALUES WHERE NAME LIKE ‘%MAST%’ AND PROCESS_ACTIVITY_ID IN(SELECT *– PROCESS_ACTIVITY FROM WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE = ‘OEOH’ AND ITEM_KEY =’62348′)
SELECT * FROM WF_ITEM_TYPES
SELECT * FROM WF_LOOKUPS_TL
SELECT * FROM WF_NOTIFICATIONS WHERE MESSAGE_TYPE =’TEST’ ORDER BY BEGIN_DATE DESC
SELECT * FROM WF_NOTIFICATION_ATTRIBUTES
SELECT * FROM WF_MESSAGES
SELECT * FROM WF_MESSAGES_TL
SELECT * FROM WF_MESSAGE_ATTRIBUTES
SELECT * FROM WF_MESSAGE_ATTRIBUTES_TL
SELECT * FROM WF_ETS
SELECT * FROM WF_PROCESS_ACTIVITIES
List of activity notifications that are pending:
SELECT SUM(TOTAL_PENDING) PENDING_LESS_THAN_5DAYS FROM (SELECT B.ACTIVITY_NAME, TRUNC(SYSDATE) - TRUNC(BEGIN_DATE) PENDING_FROM_NO_OF_DAYS, COUNT(B.ACTIVITY_NAME) TOTAL_PENDING FROM WF_ITEM_ACTIVITY_STATUSES A, WF_PROCESS_ACTIVITIES B WHERE A.PROCESS_ACTIVITY = B.INSTANCE_ID AND B.PROCESS_ITEM_TYPE = A.ITEM_TYPE AND A.ITEM_TYPE = 'ERP' --AND A.ITEM_KEY = 1131 AND END_DATE IS NULL AND ACTIVITY_STATUS != 'ERROR' AND ACTIVITY_NAME IN ('PLANNING','PURCHASING','MFGFINANCE','CSD','TAX') GROUP BY ACTIVITY_NAME, TRUNC(SYSDATE) - TRUNC(BEGIN_DATE) ORDER BY ACTIVITY_NAME, PENDING_FROM_NO_OF_DAYS ) FIVE_DAYS WHERE FIVE_DAYS.PENDING_FROM_NO_OF_DAYS <
Nagulu Polagani
Latest posts by Nagulu Polagani (see all)
- Application does not have any Components in it - October 5, 2018
- Launch EC2 Instance using Ansible - August 13, 2018
- Install Ansible on AWS Red Hat Enterprise Linux - August 9, 2018