SQL Query for OINM or OIVL

Hi everybody,

I am trying to write a query that will mimic OINM (the old warehouse journal) or OIVL (the new warehouse journal) - and adapt it to my requirements.

Since OINM is a view, it should be possible to write a query to generate it.

Does anybody have such a query? or refer me to a relevant thread? or a place where I can get ideas? or even outline the strategy to develop it?

This will help me greatly as a starting point so that I can develop mine.

Any help will be much appreciated.

Thanks

Leon Lai