Oracle Forms (MOSC)

MOSC Banner

Personalization on custom form

edited Apr 4, 2012 8:52PM in Oracle Forms (MOSC) 7 commentsAnswered
Hello All,
I am using forms 10g on R12 database.

I have a custom form that I want to limit the data returned based on a responsibility and item value.   The underlying view for the form identifies the records that need to be excluded in a field called restrict.

It seems that the default_where property would work perfectly but I cannot get it to work. 

Goal:  I want to prevent only those records where the item value of RESTRICT = 'Yes' from displaying

Here is where I'm at:
Conditions
Trigger Event = When-New-block-instance
Trigger Object = xxprk_shipments_sales_v
Condition = :xxprk_shipments_sales_v.restrict = 'Yes'

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