SQL query to check the background SQL query for a Database Item - DBI

 SELECT 'SELECT ' || definition_text || ' FROM ' AS select_clause_text,

      to_char(TEXT) AS from_clause_text

    FROM ff_database_items fdi, ff_user_entities fue, ff_routes fr

   WHERE 1=1

     AND fue.user_entity_id = fdi.user_entity_id

     AND fr.route_id = fue.route_id

     and user_name='CMP_ASSIGNMENT_SALARY_AMOUNT'