Cost Collection Flexfields to Restrict Project Number LOV

Summary:

Restrict Project Number LOV at PR line level to the Projects belongs to the Requester's Organization.

Content (required):

Using Cost Collection Flexfields, we want to restrict the list of values of Projects/Tasks in the PR Line level, to the Project defined under Requester's Organization. This is to make sure, purchasing requester selects the correct project while entering the PR.

Similarly, we also want to restrict the Task List.

The Values Set "PJC_PROJECTS_CCW_V" has the below where clause as

"expenditure_org_id = :{PARAMETER.BusinessUnit}", can someone please help us, what additional condition is required to achieve the desired requirement.