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 Parent and Child Accounts in Oracle APPS R12

SELECT ffv1.flex_value parent_account       ,ffvt1.description parent_account_desc   ,ffv2.flex_value child_account   ,ffvt2.description...