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

Table Lock - Query in Oracle APPS

 SELECT client_identifier,        module,        action,        s.*   FROM v$session s  WHERE sid IN (SELECT session_id                  FRO...