View: OZF_FUND_ALLOCTREE_V

Product:	OZF - Trade Management
Description:
Implementation/DBA Data:	APPS.OZF_FUND_ALLOCTREE_V

View Text

SELECT F.ACTIVITY_METRIC_FACT_ID
, F1.ACTIVITY_METRIC_FACT_ID
, F.ACT_METRIC_USED_BY_ID
, F.ACTIVITY_METRIC_ID
, F.FORMULA_ID
, F1.FORMULA_ID
, F.FACT_VALUE
, F1.FACT_VALUE
, F.OBJECT_VERSION_NUMBER
, F1.OBJECT_VERSION_NUMBER
, F.HIERARCHY_ID
, F.LEVEL_DEPTH
, F.NODE_ID
, N.NODE_VALUE
, DECODE(N.NODE_ID
, MTR.START_NODE
, NULL
, N.PARENT_ID)
FROM AMS_ACT_METRICS_ALL MTR
, AMS_TERR_V N
, AMS_ACT_METRIC_FACTS_ALL F
, AMS_ACT_METRIC_FORMULAS FO
, AMS_ACT_METRIC_FACTS_ALL F1
, AMS_ACT_METRIC_FORMULAS FO1
WHERE MTR.ACT_METRIC_USED_BY_ID = F.ACT_METRIC_USED_BY_ID
AND MTR.ACTIVITY_METRIC_ID = F.ACTIVITY_METRIC_ID
AND MTR.ARC_ACT_METRIC_USED_BY = F.ARC_ACT_METRIC_USED_BY
AND F.HIERARCHY_ID = N.HIERARCHY_ID
AND F.LEVEL_DEPTH = N.LEVEL_DEPTH
AND F.NODE_ID = N.NODE_ID
AND F.ACT_METRIC_USED_BY_ID = F1.ACT_METRIC_USED_BY_ID
AND F.ACTIVITY_METRIC_ID = F1.ACTIVITY_METRIC_ID
AND F.ARC_ACT_METRIC_USED_BY = 'FUND'
AND F1.ARC_ACT_METRIC_USED_BY = 'FUND'
AND F.HIERARCHY_ID = F1.HIERARCHY_ID
AND F.LEVEL_DEPTH = F1.LEVEL_DEPTH
AND F.NODE_ID = F1.NODE_ID
AND FO.FORMULA_ID = F.FORMULA_ID
AND FO.FORMULA_TYPE = 'ALLOCATION'
AND FO1.FORMULA_ID = F1.FORMULA_ID
AND FO1.FORMULA_TYPE= 'HOLDBACK'

Columns