View: EDW_ATTRIBUTE_SET_COLUMNS_MD_V

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

View Text

SELECT REL.ELEMENTID
, REL.NAME
, SIS.NAME
, SIS.ELEMENTID
, ITEM.ELEMENTID
, ITEM.NAME
FROM CMPITEMSET_V SIS
, CMPWBITEMSETUSAGE_V ISU
, CMPITEM_V ITEM
, CMPRELATION_V REL
WHERE SIS.OWNINGRELATION=REL.ELEMENTID
AND ISU.ITEMSET=SIS.ELEMENTID
AND ITEM.ELEMENTID=ISU.ATTRIBUTE
AND SIS.CLASSNAME='CMPWBNAMEDITEMSET' WITH READ ONLY

Columns