How to join cmp_stock_details & hrc_integration_key_map

Summary:

We are trying to create a report for fetch source system ID used for loading stock but No joins are available to join cmp_stock_details & hrc_integration_key_map table.

If some one have used it please do share the sample query

select hikp.SURROGATE_ID , hikp.SOURCE_SYSTEM_OWNER , hikp.SOURCE_SYSTEM_ID

hrc_integration_key_map hikp,

cmp_stock_details csd

where 1=1

and csd.OBJECT_NAME = 'Stock'

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):