APPS.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on OZF_ACT_FORECASTS_ALL

Line 2359: ozf_act_forecasts_all af

2355:
2356: CURSOR c_refreshed_offers(l_date DATE) IS
2357: SELECT distinct object_id offer_id, af.forecast_uom_code, oap.currency_code curr_code
2358: from ozf_activity_products oap,
2359: ozf_act_forecasts_all af
2360: where oap.creation_date > l_date
2361: and oap.object_class = 'OFFR'
2362: and af.act_fcast_used_by_id(+) = oap.object_id
2363: and af.arc_act_fcast_used_by(+) = oap.object_class

Line 2392: ozf_act_forecasts_all af

2388: FROM ozf_offers o,
2389: qp_list_headers l,
2390: ozf_act_offers ao,
2391: ams_campaigns_vl ct,
2392: ozf_act_forecasts_all af
2393: WHERE o.qp_list_header_id = NVL(p_offer_id,o.qp_list_header_id)
2394: and o.qp_list_header_id = l.list_header_id
2395: and ao.qp_list_header_id(+) = decode(o.reusable,'N', o.qp_list_header_id)
2396: and ao.arc_act_offer_used_by(+) = 'CAMP'

Line 2455: ozf_act_forecasts_all af

2451: select distinct adj.list_header_id offer_id,
2452: af.forecast_uom_code
2453: from oe_price_adjustments adj,
2454: oe_order_lines line,
2455: ozf_act_forecasts_all af
2456: where adj.line_id = line.line_id
2457: and line.open_flag = 'N'
2458: and line.cancelled_flag = 'N'
2459: and line.actual_shipment_date > l_date

Line 2468: from ozf_act_forecasts_all

2464: CURSOR c_incremental_forecast_values(l_date DATE)
2465: IS
2466: select act_fcast_used_by_id offer_id,
2467: forecast_uom_code
2468: from ozf_act_forecasts_all
2469: where last_update_date > l_date
2470: and arc_act_fcast_used_by = 'OFFR'
2471: and freeze_flag(+) = 'Y';
2472:

Line 2557: ozf_act_forecasts_all fc,

2553: ql.operand,
2554: ao.transaction_currency_code,
2555: ao.fund_request_curr_code transaction_currency_code
2556: FROM
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,

Line 2567: from ozf_act_forecasts_all

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
2566: and fc.last_scenario_id = (select max(last_scenario_id)
2567: from ozf_act_forecasts_all
2568: where act_fcast_used_by_id = l_offer_id
2569: and freeze_flag = 'Y')
2570: and fm.act_metric_used_by_id = fc.forecast_id
2571: and fm.arc_act_metric_used_by = 'FCST'

Line 4386: ozf_act_forecasts_all fc,

4382: ql.operand,
4383: ao.transaction_currency_code,
4384: fc.forecast_id
4385: FROM
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,

Line 4396: from ozf_act_forecasts_all

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
4395: and fc.last_scenario_id = (select max(last_scenario_id)
4396: from ozf_act_forecasts_all
4397: where act_fcast_used_by_id = l_offer_id
4398: and freeze_flag = 'Y')
4399: and fm.act_metric_used_by_id = fc.forecast_id
4400: and fm.arc_act_metric_used_by = 'FCST'