2557: ozf_act_forecasts_all fc,
2558: ozf_act_metric_facts_all fm,
2559: ozf_forecast_dimentions fp,
2560: qp_pricing_attributes qa,
2561: qp_list_lines ql,
2562: ozf_offers ao
2563: WHERE fp.obj_id = l_offer_id
2564: and fp.obj_type = 'OFFR'
2565: and fc.act_fcast_used_by_id = fp.obj_id
4386: ozf_act_forecasts_all fc,
4387: ozf_act_metric_facts_all fm,
4388: ozf_forecast_dimentions fp,
4389: qp_pricing_attributes qa,
4390: qp_list_lines ql,
4391: ozf_offers ao
4392: WHERE fp.obj_id = l_offer_id
4393: and fp.obj_type = 'OFFR'
4394: and fc.act_fcast_used_by_id = fp.obj_id