select /*+ ORDERED */
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,
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# = userenv('SCHEMAID')
SELECT /*+ ORDERED */
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
,
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# = USERENV('SCHEMAID')
|
|
|