We are running Apps 10 Update 11
In the Aurena interface is there a way to search for a date that is say 3 days in the future? An example would be in Inventory Part In Stock and we want to find any items that expire in the next 3 days.
In IEE I would use the advances/SQL query and use something like EXPIRATION_DATE <= trunc(sysdate)+3
I’m trying to figure out how to replicate what we currently do in IEE in Aurena. Not that we are migrating to the cloud version immediately, but it’s going to happen sooner or later.
Best answer by matt.watters
View original