you can do a reference to the result of another data provide in the where clause like e.g.:
<variable_name> IN @dpvalue(‘A’, DP3.DO1)
sometimes this procedure behaves a bit “bullheaded”, but is works
BUT: not mor than 999 instances may be contained in that list (is I think at least a “hard” Oracle restriction)
Rgds