From which table I can get cost of material transactions with "Outgoing" or "Issue" transaction type

Hello,

I developed an SQL report to show cost per material txns. For relationship between txn and cost, I used CST_ITEM_COST_HISTORY_V view, but with this way, I could bring only the transactıons wıth Issue type, -transactions with negative quantity-. From which table and with what relationship I can match cost and incoming material txns?

SQL file of the report is in the archive attached, but for convenience, I'm writing it down here.

Thank you in advance

SELECT
catt.category_name ITEM_COST_CATEGORY,
item.item_number ITEM_NUMBER,
REPLACE(item.description, '
', '') ITEM_DESCRIPTION,