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

Customer Tax Registration - EBS Query

              SELECT DISTINCT  hp.party_type, hp.party_name, hca.account_name, hp.party_number, hps.party_site_number, ...