BDM - Mapping
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
- from query with the developer tool