eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: CTXSYS.CTX_USER_PREFERENCE_VALUES

Source

View Text - Preformatted


select /*+ ORDERED INDEX(dr$preference_value) */
  pre_name            prv_preference
 ,oat_name            prv_attribute
 ,decode(oat_datatype, 'B', decode(prv_value, 1, 'YES', 'NO'),
    nvl(oal_label, prv_value)) prv_value
from
  dr$preference
 ,dr$preference_value
 ,dr$object_attribute
 ,dr$object_attribute_lov
where oat_id = oal_oat_id (+)
  and prv_value = nvl(oal_value, prv_value)
  and pre_id = prv_pre_id
  and oat_id = prv_oat_id
  and pre_owner# = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT /*+ ORDERED INDEX(DR$PREFERENCE_VALUE) */ PRE_NAME PRV_PREFERENCE
, OAT_NAME PRV_ATTRIBUTE
, DECODE(OAT_DATATYPE
, 'B'
, DECODE(PRV_VALUE
, 1
, 'YES'
, 'NO')
, NVL(OAL_LABEL
, PRV_VALUE)) PRV_VALUE FROM DR$PREFERENCE
, DR$PREFERENCE_VALUE
, DR$OBJECT_ATTRIBUTE
, DR$OBJECT_ATTRIBUTE_LOV WHERE OAT_ID = OAL_OAT_ID (+)
AND PRV_VALUE = NVL(OAL_VALUE
, PRV_VALUE)
AND PRE_ID = PRV_PRE_ID
AND OAT_ID = PRV_OAT_ID
AND PRE_OWNER# = USERENV('SCHEMAID')