R12_Buyers

/* Formatted on 09-08-2011 13:23:10 (QP5 v5.115.810.9015) */
SELECT   DISTINCT                                         --ASSIGNMENT_NUMBER,
                  (SELECT   FULL_NAME
                     FROM   PER_PEOPLE_V7
                    WHERE   PERSON_ID = pp.PERSON_ID)
                     Buyer_Name, hou.name Operating_unit
  FROM   PER_PERIODS_OF_SERVICE_V2 pp, HR_OPERATING_UNITS HOU
 WHERE   --person_id = 462 AND (PERSON_ID = 462) AND
         HOU.BUSINESS_GROUP_ID = pp.BUSINESS_GROUP_ID
         AND set_of_books_id NOT IN (2046, 2049)

--ORDER BY   date_start DESC, assignment_number DESC
--Select * from hr_operating_units