eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_FUND_RECONCILE_PVT dependencies on OZF_ACT_FORECASTS_ALL

Line 1154: FROM ozf_act_forecasts_all fore, ozf_act_metric_facts_all metr

1150: CURSOR l_forecast_csr (p_offer_id IN NUMBER) IS
1151: SELECT DISTINCT metr.from_date -- need distince for multiple dimension forecast
1152: ,metr.TO_DATE
1153: ,metr.fact_percent
1154: FROM ozf_act_forecasts_all fore, ozf_act_metric_facts_all metr
1155: WHERE fore.arc_act_fcast_used_by = 'OFFR'
1156: AND fore.act_fcast_used_by_id = p_offer_id
1157: AND fore.base_quantity_type <>'BASELINE'
1158: AND metr.arc_act_metric_used_by = 'FCST'