Hidden dependencies on CatalogInventory

[ishakhsuvarov]

Description

Multiple Inventory modules have a hidden dependency on CatalogInventory by using catalog_inventory_stock_status database table in certain cases. All of these dependencies should be made clear, ideally by moving the knowledge about the CatalogInventory and it's database structure to the separate service responsible for that.

See #2350 (comment) for reference. More cases exist.

[engcom-November]

Hello @ishakhsuvarov ,

Thank you for the report and collaboration.

As the associated pull request has been successfully reviewed and merged, we will proceed with closing this issue.

If you encounter any further concerns or if the issue persists, please feel free to reopen this ticket or raise a new one.

Thanks again!