Procurement - EBS (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center