APPS.AHL_FLEET_FORECAST_PVT dependencies on AHL_MR_EFFECTIVITIES

Line 49: FROM AHL_MR_EFFECTIVITIES mef, AHL_MR_HEADERS_B mhb

45: AND fhb.status_code = 'DRAFT'
46: AND fhb.completion_date IS NULL
47: AND NOT EXISTS
48: (SELECT 1
49: FROM AHL_MR_EFFECTIVITIES mef, AHL_MR_HEADERS_B mhb
50: WHERE fhb.fleet_header_id = mef.fleet_header_id
51: AND mhb.mr_header_id = mef.mr_header_id
52: AND mhb.mr_status_code NOT IN ('DRAFT')
53: );

Line 62: FROM AHL_MR_EFFECTIVITIES mef, AHL_MR_HEADERS_B mhb

58: FROM AHL_FLEET_HEADERS_B fhb
59: WHERE fhb.fleet_header_id = p_fleet_id
60: AND EXISTS
61: (SELECT 1
62: FROM AHL_MR_EFFECTIVITIES mef, AHL_MR_HEADERS_B mhb
63: WHERE fhb.fleet_header_id = mef.fleet_header_id
64: AND mhb.mr_header_id = mef.mr_header_id
65: AND mhb.mr_status_code = 'COMPLETE'
66: );

Line 194: /* UPDATE AHL_MR_EFFECTIVITIES

190: FROM AHL_UE_SIMULATIONS
191: WHERE fleet_header_id = p_fleet_id;
192: -- Update fleet data in MR table
193: -- Note that we are not using OVN in where clause for this update
194: /* UPDATE AHL_MR_EFFECTIVITIES
195: SET fleet_header_id = NULL,
196: object_version_number = object_version_number + 1,
197: last_update_date = SYSDATE,
198: last_updated_by = FND_GLOBAL.user_id,

Line 203: FROM AHL_MR_EFFECTIVITIES

199: last_update_login = FND_GLOBAL.login_id
200: WHERE fleet_header_id = p_fleet_id;*/
201: -- Delete MR effectivities
202: DELETE
203: FROM AHL_MR_EFFECTIVITIES
204: WHERE fleet_header_id = p_fleet_id;
205: -- Unit Downtime
206: DELETE
207: FROM AHL_FLEET_DOWNTIMES

Line 304: FROM AHL_MR_EFFECTIVITIES

300: WHERE fleet_header_id = p_fleet_id;
301: -- Update fleet data in MRtable
302: -- Delete the effectivity
303: DELETE
304: FROM AHL_MR_EFFECTIVITIES
305: WHERE fleet_header_id = p_fleet_id;
306: -- Note that we are not using OVN in where clause for this update
307: /*UPDATE AHL_MR_EFFECTIVITIES
308: SET fleet_header_id = NULL,

Line 307: /*UPDATE AHL_MR_EFFECTIVITIES

303: DELETE
304: FROM AHL_MR_EFFECTIVITIES
305: WHERE fleet_header_id = p_fleet_id;
306: -- Note that we are not using OVN in where clause for this update
307: /*UPDATE AHL_MR_EFFECTIVITIES
308: SET fleet_header_id = NULL,
309: object_version_number = object_version_number + 1,
310: last_update_date = SYSDATE,
311: last_updated_by = FND_GLOBAL.user_id,