You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Restrict PR Expenditure Organization based Inventory Organization

in Project Management 1 comment

Summary:

We are trying to restrict the Purchase Requisition Expenditure Organization to be related inventory organization which means the expenditure organization LOV should be on the assigned the Inventory organization for the selected project.

Content (please ensure you mask any confidential information):

We are using the Project cost collection flex field POR: Requisition the value set as follows.

org_id = :{PARAMETER.BusinessUnit} and nvl(:{SEGMENT.EXPENDITURE_ITEM_DATE}, trunc(sysdate)) between nvl(EFFECTIVE_START_DATE, nvl(:{SEGMENT.EXPENDITURE_ITEM_DATE}, trunc(sysdate))) and nvl(EFFECTIVE_END_DATE, nvl(:{SEGMENT.EXPENDITURE_ITEM_DATE}, trunc(sysdate)))
and organization_id = (select iod.ORGANIZATION_ID from INV_ORGANIZATION_DEFINITIONS_V iod , pjf_projects_all_b pjf where pjf.segment1= iod.ORGANIZATION_CODE and pjf.project_id = :{SEGMENT.PROJECT_ID})

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!