OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Lov's in Apps

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Lov's in Apps [message #581695]

Wed, 10 April 2013 00:30

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,

Report message to a moderator

Re: Lov's in Apps [message #581710 is a reply to message #581695]

Wed, 10 April 2013 01:33

Littlefoot
Messages: 21823
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 ...

Report message to a moderator

Re: Lov's in Apps [message #581750 is a reply to message #581710]

Wed, 10 April 2013 05:44

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,

Report message to a moderator

Re: Lov's in Apps [message #581751 is a reply to message #581750]

Wed, 10 April 2013 05:49

Littlefoot
Messages: 21823
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).

Report message to a moderator

Previous Topic:	iby_ext_party_pmt_mthds record is not being created from supplier open interface
Next Topic:	Planning specific items

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 00:57:11 CST 2024