How to find custom workflow in oracle apps
In this post , We will discuss about how to find the custom workflow in oracle apps. In oracle apps , We can create our custom workflow with the help of Workflow Builder but to find the how many and what are the custom workflows in oracle apps then we should have some method and way. for this We can use this below sql query to find out all the custom workflow in oracle apps. To create any custom workflow first we need to create the Item Type. So Here also we will be try to find all the workflow in our data base with the help of this Item Type.
2 Methods to find custom workflow in oracle apps
Method1:- Usually we create the Custom Object Starting with XX_Name of the Object. So We can use this below sql query for the same.
SELECT * FROM WF_ITEM_TYPES where name Like 'XX%'; --PO Approval (POAPPRV) ; PO Requisition Approval (REQAPPRV);
Method2:- If we don't know the Item Type name but we know the workflow actual name then we can use this below sql Query.
SELECT * FROM WF_ITEM_TYPES_VL where display_name like '%Custom%Approval%'
1 comments:
but this will not give accurate results ..??
Post a Comment