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
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