Saturday, December 28, 2024

SQL Query to find all DBI's based on ANC Tables in Oracle Fusion

SELECT d.base_user_name dbi_name
      ,d.data_type dbi_data_type
      ,(SELECT listagg ('<' || rcu.sequence_no || ',' || c.base_context_name || '>', ',')
   within GROUP (ORDER BY rcu.sequence_no)
          FROM ff_route_context_usages rcu
              ,ff_contexts_b c
         WHERE rcu.route_id = r.route_id
           AND rcu.context_id = c.context_id
   ) route_context_usages
  FROM ff_database_items_b d
      ,ff_user_entities_b u
      ,ff_routes_b r
 WHERE UPPER(d.base_user_name) LIKE 'ANC%'
   AND d.user_entity_id = u.user_entity_id
   AND r.route_id = u.route_id

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...