My team is trying to create a Data Lineage SQL query using the metadata tables from the ODI-12c work repository. The idea is to input a specific column into our query and return all the stages/transformations that column has undergone until the final output, or vice versa. At the moment, we have managed to build a basic query that considers every mapping within an ODI package, but this query fails when a ‘ReusableMapping’ component is present in our mappings. We have not been able to find a workaround for extracting the transformations performed in that reusable mapping.