Hi,
I want to Restrict List of Requestors in Purchase Requisition Form based on Ledger/OU. We have multiple company Employees in "People-> Enter and Maintain form" and we segregate their data by adding respective Ledger using "Assignment->Purchase Order Information". I am trying to achieve it using personalization and attaching Record Group Query with Requestor LOV but no success. Any idea?
Personalization:
Builtin Type: Create Record Group from Query
Argument: select hv.full_name , hv.employee_id , hv.employee_num employee_number , pb.name
from per_employees_current_x per , per_business_groups_perf pb ,
per_assignments_f a , hr_employees_current_v hv
where ( per.business_group_id = pb.business_group_id
AND per.employee_id=a.person_id
and trunc(sysdate) < nvl(per.inactive_date, trunc(sysdate+1)) )
and a.ass_attribute1=:PO_REQ_HDR.attribute2
and per.full_name = hv.full_name
and per.employee_id = hv.employee_id
and per.employee_num = hv.employee_num
And Sysdate Between a.EFFECTIVE_START_DATE And a.EFFECTIVE_END_DATE
order by upper(hv.full_name)
Restrict LOV of values for Requestor in Purchase Requisition form
Restrict LOV of values for Requestor in Purchase Requisition form
You do not have the required permissions to view the files attached to this post.
Who is online
Users browsing this forum: No registered users and 2 guests