I need to extract from the Oracle Data Integrator Repository the Reusable Mappings used by Mappings. We know there's the SNP_MAPPING table, which contains all Reusable Mappings and Mappings. For example, in SNP_MAPPING, we might have these two rows:
I_MAPPING: 1
NAME: This_is_a_Mapping
[other columns]
I_MAPPING: 2
NAME: This_is_a_ReusableMapping
[other columns]
Where do I find the relationship between the two rows, knowning that "This_is_a_ReusableMapping" is used within "This_is_a_Mapping"?