how-to list who changed what in the informatica repository with sql

-- get who has saved what from the informatica repository

SELECT 

   REP_VERSION_PROPS.user_id 

 , REP_USERS.user_name 

 , REP_VERSION_PROPS.OBJECT_ID

   -- , REP_VERSION_PROPS.object_type

 , OPB_SUBJECT.subj_name

 , REP_VERSION_PROPS.object_name 

 , OPB_OBJECT_TYPE.object_type_name 

 , to_date(REP_VERSION_PROPS.last_saved, 'MM/DD/YYYY HH24:MI:SS') AS LAST_UPDATE_TIME

FROM REP_VERSION_PROPS JOIN REP_USERS 

ON ( REP_VERSION_PROPS.USER_ID = REP_USERS.USER_ID )

JOIN OPB_SUBJECT 

ON ( REP_VERSION_PROPS.SUBJECT_ID = OPB_SUBJECT.SUBJ_ID )

JOIN OPB_OBJECT_TYPE 

ON ( REP_VERSION_PROPS.OBJECT_TYPE = OPB_OBJECT_TYPE.object_type_id )

WHERE 1=1

-- define the types of objects to track

AND REP_VERSION_PROPS.object_type IN (1,2,21,65,68,70,71)

-- filter by the time saved 

AND to_date(REP_VERSION_PROPS.last_saved, 'MM/DD/YYYY HH24:MI:SS') > (sysdate -12)

-- filter by informatica folder

and SUBJ_NAME = 'IMATICA_FOLDER'

-- filter by 

-- AND OBJECT_NAME = 's_m_sess_name'

ORDER BY LAST_UPDATE_TIME DESC

;