Invalid Mapping Targets

Displays targets in an invalid mapping by repository and folder.

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


select case when ("IS_SHORTCUT" = 1) then ('Yes') else ('No') end as "Calc_IS_SHORTCUT",
"SUBJECT_AREA",
"TARGET_VERSION_NUMBER",
"REPOSITORY_NAME", "TARGET_NAME",
"PARENT_TARGET_DATABASE_TYPE", "TARGET_DESC",
"PARENT_TARGET_BUSINESS_NAME",
"MAPPING_NAME",
case when ("TARGET_VERSION_STATUS" = 0) then ('Active') else (case when ("TARGET_VERSION_STATUS" = 9) then ('Logically Deleted') else (case when ("TARGET_VERSION_STATUS" = 10) then ('Physically Deleted') else ('') end) end) end as "Calc_TARGET_VERSION_STATUS"
from (SELECT  DISTINCT MAPPING_REPOSIT_INFO.REPOSITORY_NAME,  ALL_MAPPINGS.SUBJECT_AREA,  ALL_MAPPINGS.MAPPING_NAME,  MAPPING_ALL_TARGETS.TARGET_NAME,  MAPPING_ALL_TARGETS.PARENT_TARGET_BUSINESS_NAME,  MAPPING_ALL_TARGETS.TARGET_DESCRIPTION as TARGET_DESC,  MAPPING_ALL_TARGETS.TARGET_VERSION_NUMBER,      MAPPING_ALL_TARGETS.TARGET_VERSION_STATUS,  MAPPING_ALL_TARGETS.PARENT_TARGET_DATABASE_TYPE,      MAPPING_ALL_TARGETS.IS_SHORTCUT,      ALL_MAPPINGS.PARENT_MAPPING_IS_VALID as VALIDFLAG   FROM  REP_ALL_TARGETS MAPPING_ALL_TARGETS,  REP_WIDGET_INST MAPPING_WIDGET_INST,  REP_ALL_MAPPINGS ALL_MAPPINGS,  REP_REPOSIT_INFO MAPPING_REPOSIT_INFO   WHERE  (MAPPING_ALL_TARGETS.PARENT_TARGET_ID = MAPPING_WIDGET_INST.WIDGET_ID AND  MAPPING_ALL_TARGETS.SUBJECT_ID = MAPPING_WIDGET_INST.SUBJECT_ID AND  MAPPING_WIDGET_INST.WIDGET_TYPE = 2 AND  ALL_MAPPINGS.PARENT_MAPPING_ID = MAPPING_WIDGET_INST.MAPPING_ID AND  ALL_MAPPINGS.PARENT_MAPPING_VERSION_NUMBER = MAPPING_WIDGET_INST.  VERSION_NUMBER AND  ALL_MAPPINGS.PARENT_SUBJECT_ID = MAPPING_WIDGET_INST.SUBJECT_ID AND  ALL_MAPPINGS.PARENT_MAPPING_ID <> MAPPING_REPOSIT_INFO.REPOSITORY_ID)) "query"
where "SUBJECT_AREA" in ('<Folder_Name>') and case when ("VALIDFLAG" = 1) then ('Yes') else ('No') end = 'No'
order by "REPOSITORY_NAME", "SUBJECT_AREA", "MAPPING_NAME", "TARGET_NAME", "PARENT_TARGET_BUSINESS_NAME"