select ib."REPLICAT_NAME",ib."SERVER_NAME",ib."APPLY_USER",ib."USER_COMMENT",ib."CREATE_DATE",ib."STATUS"
from dba_goldengate_inbound ib, all_apply a
where a.apply_name = ib.server_name
View Text - HTML Formatted
SELECT IB."REPLICAT_NAME" , IB."SERVER_NAME" , IB."APPLY_USER" , IB."USER_COMMENT" , IB."CREATE_DATE" , IB."STATUS"
FROM DBA_GOLDENGATE_INBOUND IB , ALL_APPLY A
WHERE A.APPLY_NAME = IB.SERVER_NAME