VIEW: CTXSYS.CTX_OBJECT_ATTRIBUTE_LOV

Source

View Text - Preformatted

select cla_name    oal_class,
       obj_name    oal_object,
       oat_name    oal_attribute,
       oal_label   oal_label,
       oal_value   oal_value,
       oal_desc    oal_description
  from dr$class,
       dr$object,
       dr$object_attribute,
       dr$object_attribute_lov
 where cla_id     = obj_cla_id
   and obj_cla_id = oat_cla_id
   and obj_id     = oat_obj_id
   and oat_id     = oal_oat_id
   and obj_system = 'N'
   and oat_system = 'N'
   and cla_system = 'N'

View Text - HTML Formatted

SELECT CLA_NAME OAL_CLASS
, OBJ_NAME OAL_OBJECT
, OAT_NAME OAL_ATTRIBUTE
, OAL_LABEL OAL_LABEL
, OAL_VALUE OAL_VALUE
, OAL_DESC OAL_DESCRIPTION
FROM DR$CLASS
, DR$OBJECT
, DR$OBJECT_ATTRIBUTE
, DR$OBJECT_ATTRIBUTE_LOV
WHERE CLA_ID = OBJ_CLA_ID
AND OBJ_CLA_ID = OAT_CLA_ID
AND OBJ_ID = OAT_OBJ_ID
AND OAT_ID = OAL_OAT_ID
AND OBJ_SYSTEM = 'N'
AND OAT_SYSTEM = 'N'
AND CLA_SYSTEM = 'N'