How To Calculate The Intransit Inventory Value Under Average Costing Method In OPM

Select * from gmf_xla_extract_lines where header_id in (Select header_id from gmf_xla_extract_headers where Transaction_date >'31-Mar-11' and Transaction_date<'01-May-11')
and Journal_line_type ='ITR'
Change the date range accordingly.