We have a package that creates summary data into a custom logical unit. This custom logical unit is used utilized by the lobby list element and the aim is to navigate from this list element to a customer order lines saved search.
The saved search used the following filter:
trunc(promised_delivery_date) < trunc(sysdate) and state <> 'Cancelled'
and order_state <> 'Partially Delivered'
and customer_no <> 'CA001' and order_no not like 'Y%'
and &AO.accounting_period_api.get_accounting_year(&AO.site_api.get_company(contract),promised_delivery_date) = &AO.accounting_period_api.get_accounting_year(&AO.site_api.get_company(contract),site)
The list element navigation is passing the following column values:
It looks like the column values above are being ignored as order lines with that are in an earlier period are being displayed.
Is there a better way to achieve this.
Thank you.
