[Home] [Help]
223: /*CURSOR GetCalculationWindowForecast(p_fleet_header_id NUMBER)
224: IS
225: SELECT (sysdate+1) period_start_date,
226: MAX(NVL(period_end_date, AHL_UMP_ProcessUnit_PVT.Get_Rolling_Window_Date)) period_end_date
227: FROM ahl_fleet_utlzn_forecast
228: WHERE fleet_header_id = p_fleet_header_id;*/
229: /*CURSOR GetCalculationWindowForecast(p_fleet_header_id NUMBER)
230: IS
231: SELECT (sysdate+1) period_start_date,
916: decode(sign(period_start_date - sysdate), 1, period_start_date, sysdate + 1) period_start_date,
917: period_end_date,
918: forecasted_daily_usage,
919: fleet_header_id
920: FROM AHL_FLEET_UTLZN_FORECAST
921: WHERE fleet_header_id = p_fleet_header_id
922: AND uom_code = p_uom_code
923: ORDER BY period_start_date;
924:
923: ORDER BY period_start_date;
924:
925: /*SELECT FUF.uom_code, FUF.period_start_date, FUF.period_end_date,FUA.association_start ,FUA.association_end,
926: FUF.forecasted_daily_usage usage_per_day, FUA.fleet_header_id, FUA.unit_config_header_id, FUA.simulation_plan_id
927: FROM ahl_fleet_utlzn_forecast FUF ,ahl_fleet_unit_assocs FUA
928: WHERE trunc(nvl(period_end_date, sysdate)) >= trunc(sysdate)
929: AND trunc(nvl(association_end, sysdate)) >= trunc(sysdate)
930: AND trunc(nvl(period_end_date, association_start)) >= trunc(association_start)
931: AND FUA.simulation_plan_id = p_simulation_plan_id
937: CURSOR ahl_fleet_sorties_counter_val(p_fleet_header_id NUMBER, p_sorties_counter_uom_code VARCHAR, period_start DATE, period_end DATE)
938: IS
939: SELECT rownum,
940: forecasted_daily_usage
941: FROM ahl_fleet_utlzn_forecast
942: WHERE fleet_header_id = p_fleet_header_id
943: AND UOM_CODE = p_sorties_counter_uom_code
944: AND ((period_start_date BETWEEN period_start AND period_end)
945: OR (period_end_date BETWEEN period_start AND period_end)