APEX

Hi,

Under Oracle APEX 24.2.10, I try to pass an item value from p.6 to page p.17 on application 108. When I click on the button “CRER UN PROJET POUR CETTE MISSION” it goes to the p. 17 “Projet”. The p. 17 has an itemP17_MISSION type LOV. It is populated with the P6_ID of the mission on page 6.

The LOV p. 17 is based on this select :

select ap.id as "R",  p.titre_mission as "D"
from ad_gestion_projet ap
join ad_projet         p
  on ap.id = p.id;

But instead of displaying the display value “D”, it display the return value “R” of the request.

Best regards.