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

Report message to a moderator

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: 2112
Registered: October 2003
Location: Cincinnati, OH
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

Report message to a moderator

Previous Topic: Changing LOV based on key flexfield
Next Topic: fnd_execute
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 06:21:26 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.