I don't understand how to join SNP_MAPPING and SNP_TRT tables in order to obtain the current IKM used for each Physical Model defined into a Mapping...
many thanks in advance,
Try to use this. It will return all KMs used in a mapping (including the component KMs):
SELECT B.NAME,A.QUALIFIED_NAME FROM DEV_ODI_REPO.SNP_MAP_REF A
JOIN DEV_ODI_REPO.SNP_MAPPING B
ON B.I_MAPPING = A.I_OWNER_MAPPING
WHERE B.NAME = '<YOUR_MAPPING_NAME>'
AND ADAPTER_INTF_TYPE = 'IKnowledgeModule'
ORDER BY 2;