how to know query wip hierarchy with lot number finding PO

Dear sir ,

I have urgent issue find wip  and lot in genealogy (  where condition  is  wip_entity_name='WIP0000001' and transaction_type_id in(43,35)  )

I need result with example below:

main_wip_entity_name         lot_number          po_number        wip_entity_name  

WIP0000001                           L00001                  2012000001                  -

WIP0000001                           L00001                   -                          WIP0000002

WIP0000001                           L00002                   -                          WIP0000003

WIP0000002                           L00003                 2012000002             -

WIP0000002                           L00004                 2012000003             -     

WIP0000003                           L00005                 2012000004             -

WIP0000003                           L00005                  -                            WIP0000004

WIP0000004                           L00006                 2012000005            -

Please help to provide query.

Thanks,

Sommai