[Home] [Help]
2516: a.INCREMENT_QUOTA,
2517: a.forecast_uom_code,
2518: a.LAST_SCENARIO_ID
2519: FROM ozf_act_forecasts_all a,
2520: ozf_worksheet_headers_b b
2521: WHERE a.FORECAST_ID = p_forecast_id
2522: AND b.worksheet_header_id = NVL(p_obj_id, b.worksheet_header_id)
2523: AND a.arc_act_fcast_used_by = NVL(p_obj_type, 'WKST')
2524: AND a.act_fcast_used_by_id = b.worksheet_header_id
3047: a.INCREMENT_QUOTA,
3048: a.forecast_uom_code,
3049: a.LAST_SCENARIO_ID
3050: FROM ozf_act_forecasts_all a,
3051: ozf_worksheet_headers_b b
3052: WHERE a.FORECAST_ID = p_forecast_id
3053: AND b.worksheet_header_id = NVL(p_obj_id, b.worksheet_header_id)
3054: AND a.arc_act_fcast_used_by = NVL(p_obj_type, 'WKST')
3055: AND a.act_fcast_used_by_id = b.worksheet_header_id
3550: a.forecast_uom_code,
3551: a.LAST_SCENARIO_ID,
3552: b.currency_code
3553: FROM ozf_act_forecasts_all a,
3554: ozf_worksheet_headers_b b
3555: WHERE a.FORECAST_ID = p_forecast_id
3556: AND b.worksheet_header_id = NVL(p_obj_id, b.worksheet_header_id)
3557: AND a.arc_act_fcast_used_by = NVL(p_obj_type, 'WKST')
3558: AND a.act_fcast_used_by_id = b.worksheet_header_id
4178: a.base_quantity_start_date,
4179: a.base_quantity_end_date,
4180: a.base_quantity_ref /* OFFER_CODE or BASELINE SOURCE */
4181: FROM ozf_act_forecasts_all a,
4182: ozf_worksheet_headers_b b
4183: WHERE b.worksheet_header_id = NVL(p_worksheet_header_id, b.worksheet_header_id)
4184: AND a.arc_act_fcast_used_by = 'WKST'
4185: AND a.act_fcast_used_by_id = b.worksheet_header_id
4186: AND b.forecast_generated = DECODE(p_worksheet_header_id, NULL, 'N',b.forecast_generated);
4518: END IF; --IF (l_base_quantity_type = 'BASELINE')
4519:
4520:
4521: --IF p_worksheet_header_id is null THEN
4522: UPDATE ozf_worksheet_headers_b
4523: SET forecast_generated = 'Y'
4524: WHERE worksheet_header_id = l_worksheet_header_id;
4525:
4526:
8038: l_product_attribute_context ozf_forecast_dimentions.product_attribute_context%TYPE;
8039: l_product_attribute ozf_forecast_dimentions.product_attribute%TYPE;
8040: l_product_attr_value ozf_forecast_dimentions.product_attr_value%TYPE;
8041: l_fcst_uom OZF_ACT_FORECASTS_ALL.forecast_uom_code%TYPE;
8042: l_currency_code ozf_worksheet_headers_b.currency_code%TYPE;
8043: l_price_list_id NUMBER;
8044: l_forecast_id NUMBER;
8045:
8046:
8069: FROM
8070: ozf_act_metric_facts_all fact,
8071: OZF_ACT_FORECASTS_ALL fcst,
8072: ozf_forecast_dimentions dim,
8073: ozf_worksheet_headers_b wkst
8074: WHERE
8075: fact.activity_metric_fact_id = p_activity_metric_fact_id
8076: AND fcst.FORECAST_ID = fact.act_metric_used_by_id
8077: AND fact.arc_act_metric_used_by = 'FCST'
8340: l_product_attribute_context ozf_forecast_dimentions.product_attribute_context%TYPE;
8341: l_product_attribute ozf_forecast_dimentions.product_attribute%TYPE;
8342: l_product_attr_value ozf_forecast_dimentions.product_attr_value%TYPE;
8343: l_fcst_uom OZF_ACT_FORECASTS_ALL.forecast_uom_code%TYPE;
8344: l_currency_code ozf_worksheet_headers_b.currency_code%TYPE;
8345: l_price_list_id NUMBER;
8346:
8347:
8348: BEGIN
8368: FROM
8369: ozf_act_metric_facts_all fact,
8370: OZF_ACT_FORECASTS_ALL fcst,
8371: ozf_forecast_dimentions dim,
8372: ozf_worksheet_headers_b wkst
8373: WHERE
8374: fact.activity_metric_fact_id = p_activity_metric_fact_id
8375: AND fcst.FORECAST_ID = fact.act_metric_used_by_id
8376: AND fact.arc_act_metric_used_by = 'FCST'
8522: CURSOR c_wkst_discounts IS
8523: SELECT prd.operand,
8524: prd.arithmetic_operator
8525: from ozf_worksheet_lines prd,
8526: ozf_worksheet_headers_b hdr
8527: where 'WKST' = p_obj_type
8528: and hdr.worksheet_header_id = p_obj_id
8529: and hdr.worksheet_header_id = prd.worksheet_header_id
8530: AND prd.exclude_flag = 'N'