APPS.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on OZF_ACT_FORECASTS_ALL

Line 2302: ozf_act_forecasts_all af

2298:
2299: CURSOR c_refreshed_offers(l_date DATE) IS
2300: SELECT distinct object_id offer_id, af.forecast_uom_code, oap.currency_code curr_code
2301: from ozf_activity_products oap,
2302: ozf_act_forecasts_all af
2303: where oap.creation_date > l_date
2304: and oap.object_class = 'OFFR'
2305: and af.act_fcast_used_by_id(+) = oap.object_id
2306: and af.arc_act_fcast_used_by(+) = oap.object_class

Line 2335: ozf_act_forecasts_all af

2331: FROM ozf_offers o,
2332: qp_list_headers l,
2333: ozf_act_offers ao,
2334: ams_campaigns_vl ct,
2335: ozf_act_forecasts_all af
2336: WHERE o.qp_list_header_id = NVL(p_offer_id,o.qp_list_header_id)
2337: and o.qp_list_header_id = l.list_header_id
2338: and ao.qp_list_header_id(+) = decode(o.reusable,'N', o.qp_list_header_id)
2339: and ao.arc_act_offer_used_by(+) = 'CAMP'

Line 2398: ozf_act_forecasts_all af

2394: select distinct adj.list_header_id offer_id,
2395: af.forecast_uom_code
2396: from oe_price_adjustments adj,
2397: oe_order_lines line,
2398: ozf_act_forecasts_all af
2399: where adj.line_id = line.line_id
2400: and line.open_flag = 'N'
2401: and line.cancelled_flag = 'N'
2402: and line.actual_shipment_date > l_date

Line 2411: from ozf_act_forecasts_all

2407: CURSOR c_incremental_forecast_values(l_date DATE)
2408: IS
2409: select act_fcast_used_by_id offer_id,
2410: forecast_uom_code
2411: from ozf_act_forecasts_all
2412: where last_update_date > l_date
2413: and arc_act_fcast_used_by = 'OFFR'
2414: and freeze_flag(+) = 'Y';
2415:

Line 2500: ozf_act_forecasts_all fc,

2496: ql.operand,
2497: ao.transaction_currency_code,
2498: ao.fund_request_curr_code transaction_currency_code
2499: FROM
2500: ozf_act_forecasts_all fc,
2501: ozf_act_metric_facts_all fm,
2502: ozf_forecast_dimentions fp,
2503: qp_pricing_attributes qa,
2504: qp_list_lines ql,

Line 2510: from ozf_act_forecasts_all

2506: WHERE fp.obj_id = l_offer_id
2507: and fp.obj_type = 'OFFR'
2508: and fc.act_fcast_used_by_id = fp.obj_id
2509: and fc.last_scenario_id = (select max(last_scenario_id)
2510: from ozf_act_forecasts_all
2511: where act_fcast_used_by_id = l_offer_id
2512: and freeze_flag = 'Y')
2513: and fm.act_metric_used_by_id = fc.forecast_id
2514: and fm.arc_act_metric_used_by = 'FCST'

Line 4323: ozf_act_forecasts_all fc,

4319: ql.operand,
4320: ao.transaction_currency_code,
4321: fc.forecast_id
4322: FROM
4323: ozf_act_forecasts_all fc,
4324: ozf_act_metric_facts_all fm,
4325: ozf_forecast_dimentions fp,
4326: qp_pricing_attributes qa,
4327: qp_list_lines ql,

Line 4333: from ozf_act_forecasts_all

4329: WHERE fp.obj_id = l_offer_id
4330: and fp.obj_type = 'OFFR'
4331: and fc.act_fcast_used_by_id = fp.obj_id
4332: and fc.last_scenario_id = (select max(last_scenario_id)
4333: from ozf_act_forecasts_all
4334: where act_fcast_used_by_id = l_offer_id
4335: and freeze_flag = 'Y')
4336: and fm.act_metric_used_by_id = fc.forecast_id
4337: and fm.arc_act_metric_used_by = 'FCST'