Query to find all standard invoices applied against pre-payment invoices

Dear All,

Please help me with the query which would list all the standard invoices applied against pre-payment invoices.

Additionally they query show display the pre-payment invoices which are not yet applied.

Example : 

Rec #     Pre-payment inv #      Inv-amount   Standard Inv No.  Amount Applied

-------------------------------------------------------------------------------------------------------------------

1            P001                        100.00          S001                  100.00

2.           P002                         200.00          NULL                 NULL

In the above example in record no. 1 for the pre payment invoice number P001 a standard invoice S001 is applied with same amount of 100.

In the second record the pre payment invoice P002 is not yet applied and hence standard invoice number and amount applied are NULL.

I need the output of the query in the above format.