Query to find Number of PO's created for Project.

 Hi All,

Apps- 12.1.3

I have written below query to find summary of Purchase Order .. I would like to add Project Number to this query .. after using po_distributions_all and pa_projects_all with below query am getting wrong output.I thought project info is in Line level.Please tell how i can re write a query.

SELECT   sup.vendor_id, sup.segment1 vendor_num, sup.vendor_name,

         apsa.address_line1 address_line1, apsa.phone phone, apsa.fax fax,

         (SELECT    person.person_first_name

                 || ' '

                 || person.person_last_name

            FROM ap_suppliers asp,

                 ap_supplier_sites_all ass,

                 ap_supplier_contacts apsc,