VIEW: APPS.EDW_SEC_ITEMSET_INFO_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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