OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » value set depent on select (11i, ebs)

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

value set depent on select [message #316194]

Thu, 24 April 2008 03:49

annu-agi
Messages: 239
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

Report message to a moderator

Re: value set depent on select [message #316199 is a reply to message #316194]

Thu, 24 April 2008 04:09

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

Report message to a moderator

Re: value set depent on select [message #316220 is a reply to message #316199]

Thu, 24 April 2008 05:24

annu-agi
Messages: 239
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

Report message to a moderator

Re: value set depent on select [message #316384 is a reply to message #316194]

Thu, 24 April 2008 21:45

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

Report message to a moderator

Re: value set depent on select [message #316386 is a reply to message #316194]

Thu, 24 April 2008 21:48

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

Report message to a moderator

Previous Topic:	custom form in r12
Next Topic:	customization of kanban report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 10 00:17:28 CDT 2025