View: EDW_FACT_DIM_RELATIONS_MD_V

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

View Text

SELECT FACT.ELEMENTID
, FACT.NAME
, FK.ELEMENTID
, FK.NAME
, FCOL.ELEMENTID
, FCOL.NAME
, UCOL.ELEMENTID
, UCOL.NAME
, UK.ELEMENTID
, UK.NAME
, UK.LONGNAME
, DIM.ELEMENTID
, DIM.NAME
, FACT.LONGNAME
FROM CMPWBCUBE_V FACT
, CMPFOREIGNKEY_V FK
, CMPWBITEMSETUSAGE_V FKEYCOL
, CMPRELATIONALDBITEM_V FCOL
, CMPWBITEMSETUSAGE_V UKEYCOL
, CMPRELATIONALDBITEM_V UCOL
, CMPUNIQUEKEY_V UK
, CMPWBDIMENSION_V DIM
WHERE FACT.ELEMENTID = FK.OWNINGRELATION
AND FK.UNIQUEKEY = UK.ELEMENTID
AND UK.OWNINGRELATION = DIM.ELEMENTID
AND FK.ELEMENTID = FKEYCOL.ITEMSET
AND FKEYCOL.ATTRIBUTE = FCOL.ELEMENTID
AND UK.ELEMENTID = UKEYCOL.ITEMSET
AND UKEYCOL.ATTRIBUTE = UCOL.ELEMENTID WITH READ ONLY

Columns