QUERY TO GET BUYER(Employees) NAME

SELECT per.full_name "Buyer Name",
       pa.START_DATE_ACTIVE "Begin Date",
       pa.END_DATE_ACTIVE "End Date",
       per.employee_number,
       per.email_address,
       per.global_name,
       per.local_name
FROM   po_agents pa,
              per_all_people_f per
WHERE 1=1
AND pa.AGENT_ID = per.person_id
AND PER.person_id='1294';

👋 Hi, I'm Suriya — QA Engineer with 4+ years of experience in manual, API & automation testing.

📬 Contact Me | LinkedIn | GitHub

📌 Follow for: Real-Time Test Cases, Bug Reports, Selenium Frameworks.