Hi - Here is the my example.
I've created two pages like Page 5 is my search page and added one button to rendered the new page 6 as POP UP.
For Page 5 , there is one item (P5_ITEM_NUMBER) has type as Text Field with autocomplete and Detail Button within redirectd to page 6 and pass the name P5_ITEM_NUMBER and value is &P5_ITEM_NUMBER.
For Page 6 is query --
SELECT it.brand_parent
,i.item_code
,it.pallet_type
,DECODE(it.secondary_uom_code, NULL, 'N', 'Y') random_weight
,it.sc_per_layer || '-' || it.sc_layers_high tihi
,it.sc_net_weight
,it.sc_gross_weight
,it.sc_height
FROM data.item i
,data.item_translation it
WHERE i.item_id = it.item_id
AND i.item_code = :P5_ITEM_NUMBER;
When I select Item Number from P5_ITEM_NUMBER list and hiting to Detail button , my page 6 is showing no data found. Can you please help me .