EBS中部分工作流的应用
下面的SQL可以查当前系统中所有的工作流:
SELECT b.NAME, t.display_name, t.description
FROM wf_item_types b, wf_item_types_tl t
WHERE b.NAME = t.NAME
AND t.LANGUAGE = 'US'
ORDER BY 1
Sample Output(Inventory Workflow)
NAME | DISPLAY_NAME |
INVADJTO | Inventory Adjustment XML Outbound |
INVCDNTF | Consigned Inventory Diagnostics |
INVDATNT | Inventory Date Notification | <