Saturday, December 28, 2024

SQL Query to get the contexts of a DBI in Oracle Fusion

SELECT dbi.user_name
      ,base_context_name
  FROM ff_database_items_vl dbi
      ,ff_user_entities_vl userent
      ,ff_routes_vl routes
      ,ff_route_context_usages rcu
      ,ff_contexts_vl con
 WHERE dbi.user_entity_id = userent.user_entity_id
   AND userent.route_id = routes.route_id
   AND routes.route_id = rcu.route_id
   AND con.context_id = rcu.context_id
   AND dbi.base_user_name = :p_dbi_name

No comments:

Post a Comment

Query to get the Concurrent Program along with Value Set details

SELECT fcpl1.user_concurrent_program_name       ,fdfcuv.end_user_column_name       ,ffvs.flex_value_set_name value_set_name       ,ffvt.appl...