Query to find AP invoice workflow item key in oracle apps

By admin

Query to find AP invoice workflow item key in oracle apps
AP invoice workflow item key in Oracle EBS
APINVAPR workflow item key in Oracle R12
AP invoice workflow details
AP invoice workflow activity history

SQL Querysql
1SELECT ITEM_TYPE,
2         ITEM_KEY,
3         invoice_num,
4         BEGIN_DATE,
5         Q.END_DATE,
6         ROOT_ACTIVITY
7    FROM apps.WF_ITEMS Q, apps.AP_INVOICES_ALL
8   WHERE     Q.ITEM_TYPE = 'APINVAPR'
9         --AND Q.END_DATE IS NULL
10         AND REGEXP_SUBSTR (Q.ITEM_KEY,'[^-]+',1,1) = TO_CHAR (INVOICE_ID)
11         AND invoice_num IN ('123123')
12ORDER BY 3, 2;

Use query in the below post to get workflow activity history

Related posts: