Get Source Database (Extract) Information from Target side (Replicate)

           There might be few other ways you can find as I know below one of the way you can get the source database information. If you set it up heart beat table in target & Source side. By logging into target database  where replicates are running there is way too you can find source databases information by querying  heart beat table.  

select * from gguser.ggs_heartbeat;

select SRC_DB,EXTRACT_NAME from gguser.ggs_heartbeat;

-- To find last  Commit information

SELECT

    ggs_heartbeat.src_db AS src_db,

    ggs_heartbeat.extract_name AS extract_name,

    ggs_heartbeat.source_commit AS source_commit,

    ggs_heartbeat.target_commit AS target_commit

FROM

    gguser.ggs_heartbeat

WHERE

    ggs_heartbeat.src_db LIKE 'SUNIL%';