VIEW: SYS.HS_INST_CAPS

Source

View Text - Preformatted

select bc.cap_number, bc.cap_description, ic.context, ic.translation,
       ic.additional_info, fc.fds_class_name, f.fds_inst_name,
       fc.fds_class_id, f.fds_inst_id
from   hs$_inst_caps ic,
       hs$_base_caps bc,
       hs$_fds_class fc,
       hs$_fds_inst f
where  bc.cap_number = ic.cap_number
and    ic.fds_inst_id = f.fds_inst_id
and    f.fds_class_id = fc.fds_class_id

View Text - HTML Formatted

SELECT BC.CAP_NUMBER
, BC.CAP_DESCRIPTION
, IC.CONTEXT
, IC.TRANSLATION
, IC.ADDITIONAL_INFO
, FC.FDS_CLASS_NAME
, F.FDS_INST_NAME
, FC.FDS_CLASS_ID
, F.FDS_INST_ID FROM HS$_INST_CAPS IC
, HS$_BASE_CAPS BC
, HS$_FDS_CLASS FC
, HS$_FDS_INST F WHERE BC.CAP_NUMBER = IC.CAP_NUMBER AND IC.FDS_INST_ID = F.FDS_INST_ID AND F.FDS_CLASS_ID = FC.FDS_CLASS_ID