Home » Applications » Oracle Fusion Apps & E-Business Suite » value sets
value sets [message #305776] Wed, 12 March 2008 00:11 Go to next message
sailaja.alle
Messages: 2
Registered: March 2008
Junior Member
I have 2 parameters, say, p1 and p2.
p1 takes 2 values either "week" or "month"

depending on the p1 value p2 displays list of values.
Now in apps, i created 2 value sets, separatly for both.

p1 as "independent" and p2 as "table" type.
For p2 , in the table name field. i wrote a query like

(SELECT DECODE(:p1,'week',"some stmt",
'month',"some stmt") week_month FROM dual
CONNECT BY LEVEL< DECODE(:p1,'week',261,61))

and in where ckause of p2 i wrote :p1=:$FLEX$.valueset_name_p1

But it is throwing an error, while creating concurrent program. Is there any other way to do that???
Re: value sets [message #306939 is a reply to message #305776] Mon, 17 March 2008 06:00 Go to previous messageGo to next message
Dhruva
Messages: 9
Registered: August 2007
Junior Member
In Table field you need to use alias

like

(select "abc" from table_name) A
and use filedname as
A.fieldname
and use like
A.field in where clause
Re: value sets [message #306943 is a reply to message #306939] Mon, 17 March 2008 06:06 Go to previous messageGo to next message
sailaja.alle
Messages: 2
Registered: March 2008
Junior Member
Hi druva,

Can u please explain it a bit briefly..
Re: value sets [message #307927 is a reply to message #306943] Thu, 20 March 2008 06:44 Go to previous message
Dhruva
Messages: 9
Registered: August 2007
Junior Member
while putting your query in table field use like this
(SELECT DECODE(:p1,'week',"some stmt",
'month',"some stmt") week_month FROM dual
CONNECT BY LEVEL< DECODE(:p1,'week',261,61)) XX


Hence you have created alias for your table name that is your query as XX.
You need to use week_month as XX.week_month in your value set field selection. if at all you are using "WHERE" clause in your value set window then also use it with XX.week_month.

for other value set of p2 no change required.
Previous Topic: api to register the concurrent program
Next Topic: SQL Script to get see the dates of a scheduled concurrent request
Goto Forum:
  


Current Time: Mon Dec 05 06:53:34 CST 2016

Total time taken to generate the page: 0.08876 seconds