VIEW: APPS.OZF_FUND_ALLOCTREE_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'