Repository tables Expression query
Repository tables Expression query In a mapping with multiple expression transformations and multiple unconnected lookups, it is difficult for you to identify the expressions calling these unconnected lookups. This SQL will give you what you are looking for. select w.instance_name, g.expression from opb_widget_expr f, opb_expression g, opb_widget_inst w, opb_mapping m where f.expr_id = g.expr_id and f.widget_id = w.widget_id and w.widget_type = 5 and w.mapping_id = m.mapping_id and m.mapping_name = <mapping_name>