VIEW: SYS.HS_INST_DD

Source

View Text - Preformatted

select bd.dd_table_name, bd.dd_table_desc, id.translation_type,
       id.translation_text, fc.fds_class_name, f.fds_inst_name,
bd.dd_table_id,
       fc.fds_class_id, f.fds_inst_id
from   hs$_base_dd bd, hs$_inst_dd id, hs$_fds_class fc, hs$_fds_inst f
where  (bd.dd_table_id = id.dd_table_id) and (id.fds_inst_id = f.fds_inst_id)
       and (f.fds_class_id = fc.fds_class_id)

View Text - HTML Formatted

SELECT BD.DD_TABLE_NAME
, BD.DD_TABLE_DESC
, ID.TRANSLATION_TYPE
, ID.TRANSLATION_TEXT
, FC.FDS_CLASS_NAME
, F.FDS_INST_NAME
, BD.DD_TABLE_ID
, FC.FDS_CLASS_ID
, F.FDS_INST_ID FROM HS$_BASE_DD BD
, HS$_INST_DD ID
, HS$_FDS_CLASS FC
, HS$_FDS_INST F WHERE (BD.DD_TABLE_ID = ID.DD_TABLE_ID)
AND (ID.FDS_INST_ID = F.FDS_INST_ID)
AND (F.FDS_CLASS_ID = FC.FDS_CLASS_ID)