Refresh other parameters on change problems

Question

Summary

Content

Hi all,

I have 2 parameters:

1. Buyer:

select buyer_name,buyer buyer

from buyer

order by buyer

2. Order_no

select  order_no

from ordhead

WHERE

(buyer = nvl(:PM_BUYER,buyer))

I'm facing the problem that Order_no doesn't refresh default value

step 1:

When buyer selects all values, I select Order_no = 36314.

step 2: I select buyer = 92..., but Order_no doesn't refresh default value, it's still 36314.

Expect Order No have to return 'All'.

Please help me on this!

Thanks,

Misstram94 · Answer

the type of parameters are Menu Type.

Since list of values is fixed data TYPE , they didn't refresh.

My solution: changing from fixed data to SQL.

Brajesh Shukla-95078 · Answer

From where you are getting value for :PM_BUYER bind variable. I believe this should be one of the column name from parent sql.

so where clause should be (buyer = nvl(:buyer,buyer))

Brajesh Shukla-95078 · Answer

What is the type of parameters ? Can you try Parameter type Menu