VIEW: SYS.HS_CLASS_CAPS

Source

View Text - Preformatted

select cc.cap_number, bc.cap_description, cc.context, cc.translation,
       cc.additional_info, fc.fds_class_name, fc.fds_class_id
from   hs$_class_caps cc,
       hs$_base_caps bc,
       hs$_fds_class fc
where  bc.cap_number = cc.cap_number
and cc.fds_class_id = fc.fds_class_id

View Text - HTML Formatted

SELECT CC.CAP_NUMBER
, BC.CAP_DESCRIPTION
, CC.CONTEXT
, CC.TRANSLATION
, CC.ADDITIONAL_INFO
, FC.FDS_CLASS_NAME
, FC.FDS_CLASS_ID FROM HS$_CLASS_CAPS CC
, HS$_BASE_CAPS BC
, HS$_FDS_CLASS FC WHERE BC.CAP_NUMBER = CC.CAP_NUMBER AND CC.FDS_CLASS_ID = FC.FDS_CLASS_ID