Translate

Wednesday, May 21, 2014

Restrict planner in ASCP

The condition query should look something like: 
Trigger Event: WHEN-NEW-RECORD-INSTANCE 
Trigger Object: MRP_ORDERS 
Condition: 
FND_GLOBAL.USER_ID != (SELECT FU.USER_ID FROM MSC_PLANNERS MP, FND_USER FU WHERE MP.EMPLOYEE_ID = FU.EMPLOYEE_ID AND MP.PLANNER_CODE = :MRP_ORDERS.PLANNER_CODE AND ORGANIZATION_ID = :MRP_ORDERS.ORGANIZATION_ID) 
Processing Mode: Not in Enter-Query Mode 
On the Actions Tab: 
Set the Type to Property (Description to something like "Disable Release") 
Object Type: Item 
Target Object: MRP_ORDERS.RELEASE_STATUS 
Property Name: UPDATE_ALLOWED 
Value: FALSE 

No comments:

Post a Comment