Friday, May 20, 2016

Environment Variables from database table - EBS

To find out the Product "TOP" directories e.g the full directory path values from fnd_appl_tops under APPL_TOP?

select distinct  variable_name, value
from fnd_env_context
where variable_name in (select distinct basepath from FND_APPLICATION_VL  where application_name='INV Custom Application'
)

No comments:

Post a Comment

Oracle Standard Package for Order Totals

  Purpose: Sometimes we need to show line-wise or complete order totals (Basic / Tax / Tax+Basic) in reports. Oracle provides a standard...