VIEW: APPS.AMS_FUND_ALLOCATIONS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'