Mapping Mapplets

Displays mapplets used in a mapping by repository and folder.

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


select "SUBJECT_AREA",
"MAPPING_NAME",
"MAPPLET_NAME",
case when ("PARENT_MAPPLET_IS_VALID" = 1) then ('Yes') else ('No') end as "Calc_PARENT_MAPPLET_IS_VALID",
case when ("MAPPLET_VERSION_STATUS" = 0) then ('Active') else (case when ("MAPPLET_VERSION_STATUS" = 9) then ('Logically Deleted') else (case when ("MAPPLET_VERSION_STATUS" = 10) then ('Physically Deleted') else ('') end) end) end as "Calc_MAPPLET_VERSION_STATUS",
"DESCRIPTION",
"MAPPLET_VERSION_NUMBER",
"REPOSITORY_NAME",
case when ("IS_SHORTCUT" = 1) then ('Yes') else ('No') end as "Calc_IS_SHORTCUT"
from (SELECT  DISTINCT MAPPING_REPOSIT_INFO.REPOSITORY_NAME AS REPOSITORY_NAME,  ALL_MAPPINGS.SUBJECT_AREA AS SUBJECT_AREA,  ALL_MAPPINGS.MAPPING_NAME AS MAPPING_NAME,  MAPPING_ALL_MAPPLETS.MAPPLET_NAME AS MAPPLET_NAME,  MAPPING_ALL_MAPPLETS.MAPPLET_DESCRIPTION AS DESCRIPTION,  MAPPING_ALL_MAPPLETS.MAPPLET_VERSION_NUMBER AS MAPPLET_VERSION_NUMBER, MAPPING_ALL_MAPPLETS.MAPPLET_VERSION_STATUS AS MAPPLET_VERSION_STATUS, MAPPING_ALL_MAPPLETS.IS_SHORTCUT AS IS_SHORTCUT, MAPPING_ALL_MAPPLETS.PARENT_MAPPLET_IS_VALID AS PARENT_MAPPLET_IS_VALID  FROM  REP_ALL_MAPPINGS ALL_MAPPINGS,  REP_REPOSIT_INFO MAPPING_REPOSIT_INFO,  REP_WIDGET_INST MAPPING_WIDGET_INST,  REP_ALL_MAPPLETS MAPPING_ALL_MAPPLETS  WHERE  (ALL_MAPPINGS.PARENT_MAPPING_ID <> MAPPING_REPOSIT_INFO.REPOSITORY_ID 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  MAPPING_ALL_MAPPLETS.REF_WIDGET_ID = MAPPING_WIDGET_INST.WIDGET_ID AND  MAPPING_ALL_MAPPLETS.SUBJECT_ID = MAPPING_WIDGET_INST.SUBJECT_ID AND  MAPPING_WIDGET_INST.WIDGET_TYPE = 44)) "query"
where "SUBJECT_AREA" in ('<Folder_Name>') and "MAPPING_NAME" in ('<Mapping_Name>')
order by "REPOSITORY_NAME", "SUBJECT_AREA"