how to default where condition [message #529618] |
Wed, 02 November 2011 03:31 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/9fc2c55773e60a8cef395fa8cb47a31f?s=64&d=mm&r=g) |
goparaju
Messages: 54 Registered: June 2011
|
Member |
|
|
Hi Experts,
I am working on forms 6i. I have set where condition in pre-query of a trigger, my requirement is, in post-query, i want to delete the where condition. Could somebody help me how to do this.
pre-query:
set_block_property('HEADER_S',default_where,'STATUS IN (select meaning from XXSMCQSS_LOOKUP_VALUES where lookup_type=''CONCESSION STATUS CODES'' and primary_flag=''N'' )');
post_query: I want to delete this where condition, i just want make execute query normal by removing the where condition.
Kindly help me.
|
|
|
|
|
|
|
|
|
|
|