Query to find Note Source

SELECT

    jnv.source_object_code,

    jnv.source_object_meaning,

    jov.from_table,

    COUNT(*) count

FROM

    jtf_notes_vl    jnv,

    jtf_objects_vl  jov

WHERE

    jnv.source_object_code = jov.object_code (+)

GROUP BY

    jnv.source_object_code,

    jnv.source_object_meaning,

    jov.from_table

ORDER BY

    COUNT(*) DESC;