To get the list of CSR's before Refresh.

1. Login on PSUNX server with your oracle user id and password.
2. Export ORACLE_SID=XXXXX
3. sqlplus '/as sysdba'
4. Run the below SQL in PSUNX server of that particular environment.

SELECT A.CSR_ID,A.CSR_STATUS_CD,B.WRKFLW_NAME FROM CSR_STATUS A,CSR_WRKFLW_DEFN B WHERE A.CSR_ID=B.CSR_ID AND A.SD_CD=B.SD_CD  AND A.CSR_STATUS_CD='ACTST' AND A.SD_CD='XX' AND A.CSR_ID IN (SELECT DISTINCT(CSR_ID) FROM CSR_WF_STATUS_MIGRDB WHERE SD_CD='XX' AND DB_CD IN (select DB_CD from STAT_PSDB_CONFIG where DB_NAME='XXACT'));

Note: when doing refresh of TST environment, we need to check for CSR’s in ACT and TST. Similarly for DEV, we need to check for CSR’s in ACT, TST and DEV.

Once refresh gets completed you need to reapply all the CSR.