Class Association

Displays all attributes of the specified class, including its inherited attributes from parent classes.

Click on the text to copy the query report to your clipboard.


select "TO_PACKAGE_NAME",
"PACKAGE_NAME",
"FROM_PACKAGE_NAME",
"ASSOCIATION_NAME",
"FROM_CARDINALITY",
"TO_CLASS_NAME",
"FROM_CLASS_NAME",
"ORIGINATOR_NAME",
"TO_CARDINALITY",
"MODIFIED_ON"
from (SELECT  DISTINCT MMR_ASSOC_PACKAGE.ORIGINATOR_NAME,  MMR_ASSOC_PACKAGE.PACKAGE_NAME,  MMR_FROM_CLASS.CLASS_NAME AS  FROM_CLASS_NAME,  MMR_FROM_CLASS.PACKAGE_NAME FROM_PACKAGE_NAME,  MMR_IMA_ASSOCIATION.ASSOCIATION_NAME,  MMR_IMA_ASSOCIATION.FROM_CARDINALITY,  MMR_TO_CLASS.CLASS_NAME    as  TO_CLASS_NAME,  MMR_TO_CLASS.PACKAGE_NAME  AS TO_PACKAGE_NAME,  MMR_IMA_ASSOCIATION.TO_CARDINALITY,  CONVERT(VARCHAR,MMR_IMA_ASSOCIATION.MODIFIED_ON,23) AS  MODIFIED_ON FROM  IMA_ASSOCIATION MMR_IMA_ASSOCIATION,  IMA_CLASS MMR_TO_CLASS,  IMA_PACKAGE MMR_ASSOC_PACKAGE,  IMA_CLASS MMR_FROM_CLASS  WHERE  (MMR_IMA_ASSOCIATION.TO_CLASS_UID = MMR_TO_CLASS.CLASS_UID AND  MMR_IMA_ASSOCIATION.PACKAGE_UID = MMR_ASSOC_PACKAGE.PACKAGE_UID AND  MMR_IMA_ASSOCIATION.FROM_CLASS_UID = MMR_FROM_CLASS.CLASS_UID)) "query"
where "ORIGINATOR_NAME" in ('<Originator_Name>') and "PACKAGE_NAME" in ('<Package_Name>') and "FROM_CLASS_NAME" in ('<Class_Name>')
order by "ORIGINATOR_NAME", "PACKAGE_NAME", "ASSOCIATION_NAME", "FROM_PACKAGE_NAME", "FROM_CLASS_NAME"