SELECT PRH.REQUISITION_HEADER_ID,PRH.SEGMENT1,PRH.TYPE_LOOKUP_CODE,PRH.CREATION_DATE,HE.FULL_NAME FROM PO_REQUISITION_HEADERS_ALL PRH,HR_EMPLOYEES HE WHERE PRH.PREPARER_ID = HE.EMPLOYEE_ID
View Text - HTML Formatted
SELECT PRH.REQUISITION_HEADER_ID , PRH.SEGMENT1 , PRH.TYPE_LOOKUP_CODE , PRH.CREATION_DATE , HE.FULL_NAME FROM PO_REQUISITION_HEADERS_ALL PRH , HR_EMPLOYEES HE WHERE PRH.PREPARER_ID = HE.EMPLOYEE_ID