List

From the mrs repo

select * from MRX_MAPPINGS

• Lists all the mappings and mapplets available in the Model Repository service.

-- MRX_OBJECT_SUMMARY that has information about all objects in the MRS
SELECT * FROM MRX_OBJECT_SUMMARY where object_typename like '%MappingImp%';

• With create and saved times. FAQ: What is the Query to fetch Last saved timestamps for all mappings in a Model Repository?

SELECT  object_name, to_char(new_time(to_date('1970/01/01','YYYY/MM/DD')+ numtodsinterval(last_updated_time/1000,'SECOND'),'GMT','EST'),'MM/DD/YYYY hh24:mi:ss') lst_update
FROM MRX_OBJECT_SUMMARY A,
(SELECT  mapping_id FROM MRX_MAPPINGS WHERE mapping_type = 'MAPPING') B
WHERE
A.oid = B.mapping_id

Creation

• from query with the developer tool