View: EDW_SEC_ITEMSET_INFO_V

Product:	BIS - Applications BIS
Description:	EDW_SEC_ITEMSET_INFO_V
Implementation/DBA Data:	APPS.EDW_SEC_ITEMSET_INFO_V

View Text

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

Columns