Material / Product Register Report Query Required - R12.1.1

Could You Help Me On Bellow Mentioned Topic

I Need Sql Query For The Inventory Value,

Like Opening Balance , Receipts, Issue For A Particuler Period.... With Subinventory And With Org Id

Example:

item code1 --- description ---- op.qty, op.value ---- pur.qty, pur.value ---- iss.qty. iss.value --- cls.qty, cls.value

item code2 --- description ---- op.qty, op.value ---- pur.qty, pur.value ---- iss.qty. iss.value --- cls.qty, cls.value

item code3 --- description ---- op.qty, op.value ---- pur.qty, pur.value ---- iss.qty. iss.value --- cls.qty, cls.value