EBS Customizations (MOSC)

MOSC Banner

How to add sql to Attachment Functions to restrict access based on record status

edited May 3, 2016 2:57PM in EBS Customizations (MOSC) Question

I need to restrict the ability to insert/update/delete attachments based on the status of a record. This is easily done on the Attachment Functions form if you only need to check for one value. However, in my case I need to check for multiple status values. I'm trying to use sql to do this but it is not working. The sql I am using does not error and returns the correct rows in sql*plus, however it does not properly prevent updates on the attachments form. Please advise how to use the Attachment Functions form using the sql statement to make this work.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center