VIEW: CTXSYS.CTX_INDEX_SUB_LEXER_VALUES

Source

View Text - Preformatted

select /*+ ORDERED */
       u.name    isv_index_owner,
       idx_name  isv_index_name,
       substr(dri_sublxv_lang(iv2.ixv_value),1,30) isv_language,
       obj_name  isv_object,
       oat_name  isv_attribute,
       decode(oat_datatype, 'B', decode(iv1.ixv_value, 1, 'YES', 'NO'),
         nvl(oal_label, iv1.ixv_value)) isv_value
from dr$index,
     sys.user$ u,
     dr$index_value iv1,
     dr$index_value iv2,
     dr$object_attribute,
     dr$object,
     dr$object_attribute_lov
where iv1.ixv_value = nvl(oal_value, iv1.ixv_value)
  and oat_id = oal_oat_id (+)
  and oat_system = 'N'
  and oat_cla_id = obj_cla_id
  and oat_obj_id = obj_id
  and iv1.ixv_sub_oat_id = oat_id
  and iv2.ixv_oat_id = 60601
  and iv1.ixv_sub_group = iv2.ixv_sub_group
  and iv1.ixv_idx_id = iv2.ixv_idx_id
  and iv1.ixv_oat_id = 60602
  and idx_id     = iv1.ixv_idx_id
  and idx_owner# = u.user#

View Text - HTML Formatted

SELECT /*+ ORDERED */ U.NAME ISV_INDEX_OWNER
, IDX_NAME ISV_INDEX_NAME
, SUBSTR(DRI_SUBLXV_LANG(IV2.IXV_VALUE)
, 1
, 30) ISV_LANGUAGE
, OBJ_NAME ISV_OBJECT
, OAT_NAME ISV_ATTRIBUTE
, DECODE(OAT_DATATYPE
, 'B'
, DECODE(IV1.IXV_VALUE
, 1
, 'YES'
, 'NO')
, NVL(OAL_LABEL
, IV1.IXV_VALUE)) ISV_VALUE FROM DR$INDEX
, SYS.USER$ U
, DR$INDEX_VALUE IV1
, DR$INDEX_VALUE IV2
, DR$OBJECT_ATTRIBUTE
, DR$OBJECT
, DR$OBJECT_ATTRIBUTE_LOV WHERE IV1.IXV_VALUE = NVL(OAL_VALUE
, IV1.IXV_VALUE)
AND OAT_ID = OAL_OAT_ID (+)
AND OAT_SYSTEM = 'N'
AND OAT_CLA_ID = OBJ_CLA_ID
AND OAT_OBJ_ID = OBJ_ID
AND IV1.IXV_SUB_OAT_ID = OAT_ID
AND IV2.IXV_OAT_ID = 60601
AND IV1.IXV_SUB_GROUP = IV2.IXV_SUB_GROUP
AND IV1.IXV_IDX_ID = IV2.IXV_IDX_ID
AND IV1.IXV_OAT_ID = 60602
AND IDX_ID = IV1.IXV_IDX_ID
AND IDX_OWNER# = U.USER#