Friends,
I have done quite a bit of research but unable to figure out how to achieve this.
looking to create a dynamic links list similar to the example in the sample application. In the sample app located here https://apex.oracle.com/pls/apex/f?p=42:1303 .
The application uses a static list, But in my case I want to be able to use a dynamic list to achieve this.

When I look at the dynamic list syntax (Creating Lists ) i don't see a way for me to pass parent entry as a parameter ?
SELECT level, labelValue label,
[targetValue] target,
[is_current] is_current_list_entry,
[imageValue] image,
[imageAttributeValue] image_attribute,
[imageAltValue] image_alt_attribute,
[attribute1] attribute1,
[attribute2] attribute2,
[attribute3] attribute3,
[attribute4] attribute4,
[attribute5] attribute5,
[attribute6] attribute6,
[attribute7] attribute7,
[attribute8] attribute8,
[attribute9] attribute9,
[attribute10] attribute10
FROM ...
Please let me know how this can be achieved. Thanks in advance.