VIEW: CTXSYS.CTX_USER_EXTRACT_POLICY_VALUES

Source

View Text - Preformatted

select /*+ ORDERED */
  idx_name epv_policy_name,
  cla_name epv_class,
  obj_name epv_object,
  oat_name epv_attribute,
  decode(oat_datatype, 'B', decode(ixv_value, 1, 'YES', 'NO'),
    nvl(oal_label, ixv_value)) epv_value
from dr$index,
     dr$index_value,
     dr$object_attribute,
     dr$object,
     dr$class,
     dr$object_attribute_lov
where ixv_sub_group = 0
  and ixv_value = nvl(oal_value, 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 (cla_name = 'STORAGE' or cla_name = 'LEXER')
  and cla_system = 'N'
  and oat_cla_id = cla_id
  and ixv_oat_id = oat_id
  and idx_id     = ixv_idx_id
  and idx_owner# = userenv('SCHEMAID')
  and  INSTR(idx_option, 'E') > 0

View Text - HTML Formatted

SELECT /*+ ORDERED */ IDX_NAME EPV_POLICY_NAME
, CLA_NAME EPV_CLASS
, OBJ_NAME EPV_OBJECT
, OAT_NAME EPV_ATTRIBUTE
, DECODE(OAT_DATATYPE
, 'B'
, DECODE(IXV_VALUE
, 1
, 'YES'
, 'NO')
, NVL(OAL_LABEL
, IXV_VALUE)) EPV_VALUE FROM DR$INDEX
, DR$INDEX_VALUE
, DR$OBJECT_ATTRIBUTE
, DR$OBJECT
, DR$CLASS
, DR$OBJECT_ATTRIBUTE_LOV WHERE IXV_SUB_GROUP = 0
AND IXV_VALUE = NVL(OAL_VALUE
, 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 (CLA_NAME = 'STORAGE' OR CLA_NAME = 'LEXER')
AND CLA_SYSTEM = 'N'
AND OAT_CLA_ID = CLA_ID
AND IXV_OAT_ID = OAT_ID
AND IDX_ID = IXV_IDX_ID
AND IDX_OWNER# = USERENV('SCHEMAID')
AND INSTR(IDX_OPTION
, 'E') > 0