Supplier SQL Queries

--Employee Details

SELECT  full_name Employee_Name, employee_number Employee_Number
   FROM  HR.PER_ALL_PEOPLE_F
WHERE  person_id= <<person_id>>;


-Vendor Details

SELECT segment1 Vendor_Number FROM AP.AP_SUPPLIERS

SELECT vendor_name Vendor_Name FROM AP.AP_SUPPLIERS