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

currentAppUi built in variable in VBCS

$global.currentAppUi.id :- The id of the App UI $global.currentAppUi.urlId :-The id of the App UI as shown in the URL $global.currentAppUi.d...