Restrict LOV of values for Requestor in Purchase Requisition form

Purchasing & Inventory forum can be used to discuss all features/issues related to Oracle Purchasing & Inventory.
Post Reply
danishce
Posts: 1
Joined: Mon Aug 24, 2009 8:11 am
Location: Pakistan

Restrict LOV of values for Requestor in Purchase Requisition form

Post by danishce »

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)
You do not have the required permissions to view the files attached to this post.
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest