SQL query for View Item Landed Cost page
Hi Team,
How does View Item Landed Cost Page work?
We want to create a BI report for all GRNs and view item landed cost. We have written a custom logic but this query is not giving correct output for some GRNs.
DECODE((NVL((select (sum(CTC2.QUANTITY*CTCC2.UNIT_COST))
from CST_LAYER_COSTS CTC2 ,
cst_txn_component_costs CTCC2
where CTC2.TRANSACTION_ID = ctc_TRANSACTION_ID
and ctc2.COST_TRANSACTION_TYPE = 'RECEIPT'
AND ctc2.UNIT_COST > 0.1
AND CTC2.TRANSACTION_COST_ID = CTCC2.TRANSACTION_COST_ID
-- AND CTCC2.TRANSACTION_COST_ID =( SELECT MAX(TRANSACTION_COST_ID) FROM CST_LAYER_COSTS WHERE
0