Lookup Tables

SELECT lookup_type, description
  FROM apps.fnd_lookup_types_vl
 WHERE lookup_type LIKE '%ICSO%'

SELECT *
  FROM apps.fnd_lookup_values
 WHERE lookup_type = 'RSOL_PREVENTION_HOLDS'