SQL Query to list all External Dependencies

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

?Sometimes Users require a report on all External Dependencies they have set.

Solution

?SQL can be used in Internal Variable or directly against the database.

 

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>'