I am trying to connect this table cst_layer_costs unit_cost with this table INV_MATERIAL_TXNS

Summary:

I am doing transaction stock movement report I am struggle with unit_cost column which I am taking the column from this table cst_layer_costs try to connect it with this table INV_MATERIAL_TXNS. but the problem here gave me a duplicate which make the result wrong. my query is attached here.

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

SELECT distinct
IMT.TRANSACTION_DATE TRANSACTION_DATE,

	(select DISTINCT gl_flexfields_pkg.get_description_sql(chart_of_accounts_id,2,segment2)

	from GL_CODE_COMBINATIONS GCC,

	PO_DISTRIBUTIONS_ALL PDA

	where 

	GCC.code_combination_id = PDA.code_combination_id