Home » Applications » Oracle Fusion Apps & E-Business Suite » value set depent on select (11i, ebs)
value set depent on select [message #316194] Thu, 24 April 2008 03:49 Go to next message
annu-agi
Messages: 199
Registered: July 2005
Location: Karachi
Senior Member

hi experts


I want to make value set ( single value column) dependent upon select statement. How can i do that . i know how to make table dependent value set but i dont know how to make value set dependent upon select statement. lets suppose if i want to make value set based on sql statement like ( select disinct segment1 from mtl_item_category) so how can i make it .. any suggustion and idea

Please help me out of this problem ..


regards


Anwer
Re: value set depent on select [message #316199 is a reply to message #316194] Thu, 24 April 2008 04:09 Go to previous messageGo to next message
raju_kamarapu
Messages: 19
Registered: February 2008
Location: KAULAMPUR
Junior Member
hi Anwar, when u select table name, in that screen u can select one check box item that is Allow parent values.

just select that. hopes that will help u.


Raju.k
Re: value set depent on select [message #316220 is a reply to message #316199] Thu, 24 April 2008 05:24 Go to previous messageGo to next message
annu-agi
Messages: 199
Registered: July 2005
Location: Karachi
Senior Member

thanks alot raju ..


i got results in distinct form .. and my problem is solved but if i would like to make value set results populated against select statment .. what i hae to do ?? i mean how can i get this result .. any idea???



regards


anwer
Re: value set depent on select [message #316384 is a reply to message #316194] Thu, 24 April 2008 21:45 Go to previous messageGo to next message
raju_kamarapu
Messages: 19
Registered: February 2008
Location: KAULAMPUR
Junior Member
Hi, In the same window, u can find a where column
in that column give the conditions


like where item_id in (select distinct item_id from mtl_item_categories where xxxxx= xxxxx) .







Bye

Raju.K
Re: value set depent on select [message #316386 is a reply to message #316194] Thu, 24 April 2008 21:48 Go to previous message
raju_kamarapu
Messages: 19
Registered: February 2008
Location: KAULAMPUR
Junior Member
or in the concurrent program parameter window, there is a field
default type , in that select type as SQL STATEMNT , and give the statement in default value.




Raju.K
Previous Topic: custom form in r12
Next Topic: customization of kanban report
Goto Forum:
  


Current Time: Sun Dec 04 06:36:48 CST 2016

Total time taken to generate the page: 0.11536 seconds