I just pulled that diagram from gmpartdirect. You can go there or any of the online parts sites to get the parts list.

 

Thanks, that really helps a bunch now I know what to look for. I'm curious what the right and left rear hoses are for?
I'm assuming they would have to be for the rear windshield washer.

 

Those are water drains for any water that gets below the sun roof glass.

Will the vent option of the sun roof work? (Tilting the rear of the sun roof up)

 

There are actually 4 drain tubes. The pictures only show them on 1 side, so you just have to imagine the other side.

 

By George, those pictures sure help with the sunroof, I have a friend who complained last night she misses her sun roof it would not open, the motor just clicked, I managed to drop the head liner and disassembled the gear box the was grit and dirt in there, it is working now , but she has ordered a motor for it as it is very slow moving.