How to join cmp_stock_details & hrc_integration_key_map
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
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):