View: AMS_FUND_ALLOCATIONS_V

Product:	AMS - Marketing
Description:
Implementation/DBA Data:	APPS.AMS_FUND_ALLOCATIONS_V

View Text

SELECT AMF.ACTIVITY_METRIC_FACT_ID
, AMF.LAST_UPDATE_DATE
, AMF.LAST_UPDATED_BY
, AMF.CREATION_DATE
, AMF.CREATED_BY
, AMF.LAST_UPDATE_LOGIN
, AMF.OBJECT_VERSION_NUMBER
, AMF.ACT_METRIC_USED_BY_ID
, AMF.ARC_ACT_METRIC_USED_BY
, AMF.VALUE_TYPE
, AMF.ACTIVITY_METRIC_ID
, AMF.ACTIVITY_GEO_AREA_ID
, AMF.ACTIVITY_PRODUCT_ID
, AMF.TRANSACTION_CURRENCY_CODE
, AMF.TRANS_FORECASTED_VALUE
, AMF.FUNCTIONAL_CURRENCY_CODE
, AMF.FUNC_FORECASTED_VALUE
, AMF.ORG_ID
, AMF.DE_METRIC_ID
, AMF.DE_GEOGRAPHIC_AREA_ID
, AMF.DE_GEOGRAPHIC_AREA_TYPE
, AMF.DE_INVENTORY_ITEM_ID
, AMF.DE_INVENTORY_ITEM_ORG_ID
, AMF.NODE_ID
, AMF.LEVEL_DEPTH
, AMF.FORMULA_ID
, AMF.FROM_DATE
, AMF.TO_DATE
, AMF.FACT_VALUE
, AMF.FACT_PERCENT
, AMF.HIERARCHY_ID
FROM AMS_ACT_METRIC_FACTS_ALL AMF
, AMS_ACT_METRICS_ALL AMC
, AMS_METRICS_ALL_B MAL
WHERE AMF.ACTIVITY_METRIC_ID = AMC.ACTIVITY_METRIC_ID
AND AMC.ARC_ACT_METRIC_USED_BY = 'FUND'
AND MAL.METRIC_ID = AMC.METRIC_ID
AND MAL.METRIC_CALCULATION_TYPE = 'ALLOCATION'

Columns