How Is TOTAL_COST/TOTAL_RETAIL In TRAN_DATA/TRAN_DATA_HISTORY Calculated? (Doc ID 3061646.1)

Last updated on DECEMBER 02, 2024

Applies to:

Goal

For "Intercompany Transfer Out" (tran_code = 38) total_cost and total_retail values are different for items YYY and ZZZ in tran_data_history:

select *
from rms01.tran_data_history
where item in ('YYY', 'ZZZ')
and location = LL
and tran_code = 38
and tran_date between date 'YYYY-MM-DD' and date 'YYYY-MM-DD'
order by item, location;

How is total_cost and total_retail in tran_data/tran_data_history calculated?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.