Product: | OZF - Trade Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OZF_FUND_ALLOCATIONS_V |
SELECT FND.FUND_ID
, FND.SHORT_NAME
, FND.START_DATE_ACTIVE
, FND.END_DATE_ACTIVE
, FND.CATEGORY_ID
, FND.CATEGORY
, FND.FUND_TYPE
, MTR.ACTIVITY_METRIC_ID
, MTR.HIERARCHY_ID
, MTR.FROM_LEVEL
, MTR.TO_LEVEL
, MTR.START_NODE
, MTR.FROM_DATE
, MTR.TO_DATE
, MTR.FUNC_ACTUAL_VALUE
, MTR.METRIC_UOM_CODE
, MTR.ACT_METRIC_USED_BY_ID
, MTR.ARC_ACT_METRIC_USED_BY
, MTR.METRIC_ID
FROM AMS_ACT_METRICS_ALL MTR
, OZF_FUND_DETAILS_V FND
WHERE MTR.ARC_ACT_METRIC_USED_BY = 'FUND'
AND MTR.ACT_METRIC_USED_BY_ID = FND.FUND_ID