Adding buyer information to the query
Hello,
Adding buyer information to the below query?
SELECT --ROW_ID,
REQUISITION_NUM,
REQUISITION_HEADER_ID,
DOCUMENT_TYPE_DSP,
TYPE_LOOKUP_CODE,
DESCRIPTION,
(select sum(unit_price*quantity) Amt FROM po.po_requisition_lines_all prla where NVL(CANCEL_FLAG,'X') !='Y' and prla.REQUISITION_HEADER_ID=po_requisition_headers_inq_v.REQUISITION_HEADER_ID ) amt,
ACTION_CODE,
ACTION_DATE
,(select name from hr_operating_units ou where ou.ORGANIZATION_ID= ORG_ID) OU
,full_name
,approved_date
, alog.L_ACTION_CODE Log_action,alog.L_ACTION_DATE Log_action_date
, alog.ename Log_EMP_NAME--,object_id l_object_id