APPS.AHL_FLEET_UTIL_HISTORY_PVT dependencies on AHL_FLEET_UNIT_ASSOCS

Line 123: (SELECT Fleet_header_id FROM ahl_fleet_unit_assocs

119: name,
120: operating_org_id
121: FROM ahl_fleet_headers_b
122: WHERE fleet_header_id IN
123: (SELECT Fleet_header_id FROM ahl_fleet_unit_assocs
124: where simulation_plan_id = p_sim_plan_id
125: )
126: AND status_code = 'COMPLETE';
127:

Line 167: ahl_fleet_unit_assocs fleet

163: (p_start_date + rownum - 1) ddate
164: FROM fnd_new_messages
165: WHERE rownum <= (p_end_date - p_start_date + 1)
166: ) dtab,
167: ahl_fleet_unit_assocs fleet
168: WHERE fleet.fleet_header_id = p_fleet_header_id
169: and fleet.simulation_plan_id = p_sim_plan_id
170: AND dtab.ddate BETWEEN association_start AND NVL(association_end, dtab.ddate)
171: GROUP BY ddate

Line 178: FROM ahl_fleet_unit_assocs

174: -- Cursor to get associated units to the fleet for the sim plan id.
175: CURSOR GetAssocUnits(p_fleet_header_id NUMBER, p_sim_plan_id NUMBER, p_start_date DATE, p_end_date DATE)
176: IS
177: SELECT unit_config_header_id
178: FROM ahl_fleet_unit_assocs
179: WHERE fleet_header_id = p_fleet_header_id
180: AND simulation_plan_id = p_sim_plan_id
181: AND (association_start BETWEEN p_start_date AND p_end_date
182: OR association_end BETWEEN p_start_date AND p_end_date

Line 195: ahl_fleet_unit_assocs afua,

191: (SELECT ccr.net_reading
192: FROM CSI_COUNTER_ASSOCIATIONS csa,
193: ahl_unit_config_headers auch,
194: csi_counter_readings ccr,
195: ahl_fleet_unit_assocs afua,
196: csi_item_instances cii,
197: csi_counters_vl ccv
198: WHERE afua.unit_config_header_id = auch.unit_config_header_id
199: AND auch.csi_item_instance_id = cii.instance_id

Line 218: FROM ahl_fleet_unit_assocs

214: CURSOR GetCalculationWindowActual(p_fleet_header_id NUMBER, p_sim_plan_id NUMBER)
215: IS
216: SELECT MIN(association_start) window_start,
217: MAX(NVL(association_end,sysdate)) window_end
218: FROM ahl_fleet_unit_assocs
219: WHERE fleet_header_id = p_fleet_header_id;
220: --and simulation_plan_id = p_sim_plan_id;
221:
222: -- Cursor to get the calculation window for historical utilization

Line 233: FROM ahl_fleet_unit_assocs

229: /*CURSOR GetCalculationWindowForecast(p_fleet_header_id NUMBER)
230: IS
231: SELECT (sysdate+1) period_start_date,
232: MAX(NVL(association_end, Get_Rolling_Window_Date)) period_end_date
233: FROM ahl_fleet_unit_assocs
234: WHERE fleet_header_id = p_fleet_header_id;*/
235: -- Variables to be used
236:
237: l_api_name CONSTANT VARCHAR2(30) := 'populate_utilization_history';

Line 889: ahl_fleet_unit_assocs fleet

885: (p_start_date + rownum - 1) ddate
886: FROM fnd_new_messages
887: WHERE rownum <= (p_end_date - p_start_date + 1)
888: ) dtab,
889: ahl_fleet_unit_assocs fleet
890: WHERE fleet.fleet_header_id = p_fleet_header_id
891: and fleet.simulation_plan_id = p_sim_plan_id
892: AND dtab.ddate BETWEEN association_start AND NVL(association_end, dtab.ddate)
893: GROUP BY ddate

Line 902: FROM ahl_fleet_unit_assocs

898: IS
899: SELECT association_start,
900: association_end,
901: (association_end - association_start + 1) assoc_days
902: FROM ahl_fleet_unit_assocs
903: WHERE fleet_header_id = p_fleet_header_id
904: AND simulation_plan_id = p_simulation_plan_id
905: AND ((association_start BETWEEN p_period_start AND p_period_end)
906: OR (association_end BETWEEN p_period_start AND p_period_end)

Line 927: FROM ahl_fleet_utlzn_forecast FUF ,ahl_fleet_unit_assocs FUA

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