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:
- View accounting query in oracle apps R12
- Query to get AR invoice SLA and GL details
- Accounting entries not transferred to the General Ledger
- Query to find all APIs of Oracle Apps modules
- R12 AR cash receipt SLA and GL details query
- Oracle apps AR Applications and SLA details
- Oracle EBS query to get AP Invoice SLA Details
- Oracle EBS query to get AR Invoice SLA Details
- Oracle AR Remit to address query
- Oracle Apps iExpense credit card details query
- Query to get customer tax registration details in R12
- Purchase Requisition Vertex debug xml query in Oracle EBS