SELECT S.ENTITY_ID FACT_ID , S.ENTITY_NAME FACT_NAME , F.FACT_LONGNAME FACT_LONG_NAME , S.ATTRIBUTE_GROUP_NAME ITEMSET_NAME , S.COLUMN_NAME FK_COL_NAME FROM EDW_ATTRIBUTE_SET_COLUMNS_MD_V S , EDW_FACTS_MD_V F WHERE S.ATTRIBUTE_GROUP_NAME LIKE 'EDW_DEF_SEC%' AND F.FACT_ID = S.ENTITY_ID AND F.FACT_NAME = S.ENTITY_NAME