View: EDW_FACT_HIER_MD_V

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

View Text

SELECT FACT.ELEMENTID
, FACT.NAME
, DIM.ELEMENTID
, DIM.NAME
, HIER.ELEMENTID
, HIER.NAME
FROM CMPWBCUBE_V FACT
, CMPFOREIGNKEY_V FK
, CMPUNIQUEKEY_V UK
, CMPWBDIMENSION_V DIM
, CMPITEMHIERARCHY_V HIER
WHERE FACT.ELEMENTID = FK.OWNINGRELATION
AND FK.UNIQUEKEY = UK.ELEMENTID
AND UK.OWNINGRELATION = DIM.ELEMENTID
AND HIER.OWNDIMENSION = DIM.ELEMENTID WITH READ ONLY

Columns