Hey Louis, This is great. I have another requirement where in i want to restrict the query in the shared component LOV at run time. For example there is an item :p100_Customer
my shared component LOV is SELECT order_number, shipment_date, shipped_qty FROM table;
When my LOV is parsed i want to restrict it like below SELECT order_number, shipment_date, shipped_qty FROM table WHERE customer = :p100_customer;