To capture Cost info for item throughout the O2C lifecycle

Hi All,

We have a requirement to develop a New Oracle Report to capture Item COST info throughout the O2C lifecycle

PFB the scenario :

 

		Item #	Item Cost
Jan 2016	Sales Order # SO1000 created	I1	100
		I2	200
		I3	300
Feb 2016	Work Order # WO1000 created to manufacture items/goods on the above SO # SO1000	I1	110
		I2	210
		I3	310
Mar 2016	Original SO # SO1000 shipped out	I1	120
		I2	220
		I3	320
Client wants to capture this change of Item's COST information during the O2C life-cycle

So client wants a report like below (when the User will run the report for the above SO # SO1000):

		SO #	Item	Cost
	When SO created/booked