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,
0      
            