Home » Applications » Oracle Fusion Apps & E-Business Suite » How to define the Report Parameters (11i)
How to define the Report Parameters [message #487621] Wed, 29 December 2010 03:35 Go to next message
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 Go to previous message
vamsi kasina
Messages: 2095
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
Previous Topic: Changing LOV based on key flexfield
Next Topic: fnd_execute
Goto Forum:
  


Current Time: Mon Jul 28 18:50:41 CDT 2014

Total time taken to generate the page: 0.10534 seconds