select DISTINCT opb_subject.subj_name "Folder Name"
,opb_mapping.mapping_name "Mapping Name"
from
opb_widget_inst,
opb_widget_attr,
opb_mapping,
opb_subject
where opb_widget_inst.widget_type=11
and opb_widget_attr.attr_id=2
and opb_widget_inst.widget_id=opb_widget_attr.widget_id
and opb_mapping.mapping_id=opb_widget_inst.mapping_id
and opb_mapping.subject_id=opb_subject.subj_id
and UPPER(attr_value) like '%<<Source Name>>%';
,opb_mapping.mapping_name "Mapping Name"
from
opb_widget_inst,
opb_widget_attr,
opb_mapping,
opb_subject
where opb_widget_inst.widget_type=11
and opb_widget_attr.attr_id=2
and opb_widget_inst.widget_id=opb_widget_attr.widget_id
and opb_mapping.mapping_id=opb_widget_inst.mapping_id
and opb_mapping.subject_id=opb_subject.subj_id
and UPPER(attr_value) like '%<<Source Name>>%';
No comments:
Post a Comment