This content has been marked as final. Show 4 replies
You could use two items with different select lists and render either the one or the other depending on those conditions
when both the select lists should return values to the same db column, you can create one select statement:
select a,b from tableX where :PFIELD1 = 'X'
select d,e from tableY where :PFIELD1 = 'Y'
(and specifiy PFIELD1 as the Parent LOV field)
Try the below given code.
I am giving you a sample how to achieve this, Edit according to you requirement.
Page item to Submit : P1_ITEM_X
Hope this will helps you,
List of Value Definition : IF (:P1_ITEM_X is null) THEN RETURN 'select COLUMN1 display_value,COLUMN1 return_value from TABLE1'; ELSE RETURN 'select COLUMN2 display_value,COLUMN2 return_value from TABLE2'; END IF;