Home » Applications » Oracle Fusion Apps & E-Business Suite » Lov's in Apps
Lov's in Apps [message #581695] Wed, 10 April 2013 00:30 Go to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Hello everybody,

I want to display like that
From To
Purchase order no: 5904 5904

Here when i select From number and i want display automatically in To 5904 value also,
For this i created Lov's also..

So,please help me..

Thanks,
Re: Lov's in Apps [message #581710 is a reply to message #581695] Wed, 10 April 2013 01:33 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Select the same value twice; for example
select purchase_order_no from,
       purchase_order_no to
from your_table
where ...
Re: Lov's in Apps [message #581750 is a reply to message #581710] Wed, 10 April 2013 05:44 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Thanks for reply,
Where can i write this code , can you suggests me?
when i select Lov FROM number and automatically select in (or)presented in TO LOV..

Thanks,
Re: Lov's in Apps [message #581751 is a reply to message #581750] Wed, 10 April 2013 05:49 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As I don't use Oracle Apps. (but know something about Forms), I supposed that you might use that piece of code in LoV's Record Group query.
Or, you might utilize WHEN-VALIDATE-ITEM trigger on the "From" item to automatically populate the "To" item.
Or, you could even use item's Property Palette and set "Copy value from item" or "Synchronize with item" properties.

If none of these works in Apps., then sorry - I'm unable to help you (but someone else might).
Previous Topic: iby_ext_party_pmt_mthds record is not being created from supplier open interface
Next Topic: Planning specific items
Goto Forum:
  


Current Time: Fri Mar 29 03:07:34 CDT 2024