Query to find all External Dependencies

Document ID : KB000089304
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Query to find all External Dependencies
Resolution:
Detailed Description and Symptoms

?Some customers would like a Query to see all the External Dependencies they in WorkFlows.

 
Solution

?select oh.oh_client as Client, oh.oh_name as Workflow, jpp.jpp_object as Task from oh,jpp where oh_idnr=jpp_oh_idnr and jpp_otype='<XTRNL>'