SELECT OPB_SUBJECT.SUBJ_NAME AS PROJ,
OPB_MAPPING.MAPPING_NAME AS MAPPING,
OPB_WIDGET_INST.INSTANCE_NAME AS TRANSFORMATION,
OPB_WIDGET.LAST_SAVED AS LAST_SAVED
FROM OPB_WIDGET_INST
INNER JOIN OPB_MAPPING ON OPB_WIDGET_INST.MAPPING_ID = OPB_MAPPING.MAPPING_ID
INNER JOIN OPB_SUBJECT ON OPB_MAPPING.SUBJECT_ID = OPB_SUBJECT.SUBJ_ID
INNER JOIN OPB_WIDGET ON OPB_WIDGET_INST.WIDGET_ID = OPB_WIDGET.WIDGET_ID
WHERE OPB_WIDGET.TEMPLATE_ID IN (SELECT PLG_ID FROM OPB_MMD_CATALOG WHERE PLG_DESC LIKE '%Data Quality%');
No comments:
Post a Comment