DBA Data[Home] [Help]

VIEW: APPS.PO_REQ_TRANSACTION_V

Source

View Text - Preformatted

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