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 EBS: Query to Link OM Order Source with AR Grouping Rules and Attributes

SELECT      hou.name,     rtsa.name "Order Source/Transaction Source",     rtsa.description "Description",     gr1.name ...