| How to define the Report Parameters [message #487621] |
Wed, 29 December 2010 03:35  |
madhuarepalli
Messages: 53
Registered: June 2010
Location: Hyderabad
|
Member |
|
|
Hi,
How to defie the greater than amount and less than amount in below query:-
select * from emp
where date between :P_from_date and :P_to_date
or (sal between :p_from_amount adn :P_to_amount);
While defining Parameters in oracle applications is working fine.
Here i want to know, how to query the greater than amount and less than amount in :P_from_amount and :P_to_amount paramters.
Regards,
Madhu
|
|
|
|
| Re: How to define the Report Parameters [message #487957 is a reply to message #487621] |
Mon, 03 January 2011 17:06  |
 |
vamsi kasina
Messages: 2081
Registered: October 2003
Location: Riyadh, Saudi Arabia
|
Senior Member |
|
|
Madhu,
I didn't understand your question. Please elaborate.
Do you want an LOV for From / To amounts while submitting the concurrent program?
In that case, you need to create a value set.
By
Vamsi
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
