Mapping Metadata Extensions

Displays metadata extensions associated with a mapping and the properties of the metadata extensions.

Click on the text to copy the query report to your clipboard.


select "DOMAIN_DESCRIPTION",
"MAPPING_NAME",
"METADATA_EXTN_DESCRIPTION",
"METADATA_EXTN_NAME",
"SUBJECT_AREA",
"METADATA_EXTN_VALUE",
"DOMAIN_NAME",
"REPOSITORY_NAME"
from (SELECT  DISTINCT MAPPING_REPOSIT_INFO.REPOSITORY_NAME,  ALL_MAPPINGS.SUBJECT_AREA,  ALL_MAPPINGS.MAPPING_NAME,  MAPPING_METADATA_EXTNS.DOMAIN_NAME,  MAPPING_METADATA_EXTNS.DOMAIN_DESCRIPTION as DOMAIN_DESCRIPTION,  MAPPING_METADATA_EXTNS.METADATA_EXTN_NAME ,  MAPPING_METADATA_EXTNS.METADATA_EXTN_VALUE as METADATA_EXTN_VALUE,  MAPPING_METADATA_EXTNS.METADATA_EXTN_DESCRIPTION as  METADATA_EXTN_DESCRIPTION FROM  REP_ALL_MAPPINGS ALL_MAPPINGS,  REP_REPOSIT_INFO MAPPING_REPOSIT_INFO,  REP_METADATA_EXTNS MAPPING_METADATA_EXTNS  WHERE  (ALL_MAPPINGS.PARENT_MAPPING_ID <> MAPPING_REPOSIT_INFO.REPOSITORY_ID AND  ALL_MAPPINGS.PARENT_MAPPING_ID = MAPPING_METADATA_EXTNS.  METADATA_EXTN_OBJECT_ID AND  ALL_MAPPINGS.PARENT_MAPPING_VERSION_NUMBER = MAPPING_METADATA_EXTNS.  VERSION_NUMBER AND  ALL_MAPPINGS.SUBJECT_ID = MAPPING_METADATA_EXTNS.SUBJECT_ID AND  MAPPING_METADATA_EXTNS.METADATA_EXTN_OBJECT_TYPE = 21)) "query"
where "SUBJECT_AREA" in ('<Folder_Name>') and "MAPPING_NAME" in ('<Mapping_Name>')
order by "REPOSITORY_NAME", "SUBJECT_AREA"