APPS.AHL_FLEET_FORECAST_PVT dependencies on AHL_FLEET_HEADERS_B

Line 43: FROM AHL_FLEET_HEADERS_B fhb

39: -- Cursor to pick fleets which are draft, has null completion date and has no mr associations
40: CURSOR applicable_draft_fleets(p_fleet_id NUMBER)
41: IS
42: SELECT object_version_number
43: FROM AHL_FLEET_HEADERS_B fhb
44: WHERE fhb.fleet_header_id = p_fleet_id
45: AND fhb.status_code = 'DRAFT'
46: AND fhb.completion_date IS NULL
47: AND NOT EXISTS

Line 58: FROM AHL_FLEET_HEADERS_B fhb

54:
55: CURSOR applicable_fleets_complete_mr(p_fleet_id NUMBER)
56: IS
57: SELECT object_version_number
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

Line 147: FROM AHL_FLEET_HEADERS_B

143: SELECT status_code,
144: object_version_number
145: INTO l_status,
146: l_ovn
147: FROM AHL_FLEET_HEADERS_B
148: WHERE fleet_header_id = p_fleet_id;
149: EXCEPTION
150: WHEN NO_DATA_FOUND THEN
151: FND_MESSAGE.Set_Name('AHL','AHL_FLEET_NULL_FLT_ID');

Line 178: FROM AHL_FLEET_HEADERS_B

174: fnd_log.string ( l_log_statement, 'ahl.plsql.Remove_Fleet', 'Fleet to be hard deleted');
175: END IF;
176: -- MR association not there for the fleet. Can be hard deleted
177: DELETE
178: FROM AHL_FLEET_HEADERS_B
179: WHERE fleet_header_id = p_fleet_id;
180: -- Delete from TL table
181: DELETE
182: FROM AHL_FLEET_HEADERS_TL

Line 276: UPDATE AHL_FLEET_HEADERS_B

272: END IF;
273: END LOOP;
274:
275: -- fleet headers
276: UPDATE AHL_FLEET_HEADERS_B
277: SET object_version_number = object_version_number + 1,
278: status_code = 'DELETED',
279: last_update_date = SYSDATE,
280: last_updated_by = FND_GLOBAL.user_id,

Line 411: FROM ahl_fleet_headers_b

407:
408: CURSOR is_fleet_valid(c_fleet_header_id NUMBER)
409: IS
410: SELECT 'X'
411: FROM ahl_fleet_headers_b
412: WHERE fleet_header_id = c_fleet_header_id;
413:
414: CURSOR is_unit_valid(c_unit_config_header_id NUMBER)
415: IS

Line 425: FROM ahl_fleet_unit_assocs fus, ahl_simulation_plans_b sim, ahl_fleet_headers_b flt

421: IS
422: SELECT flt.fleet_header_id, flt.name, flt.operations_type_code, fus.unit_config_header_id,
423: fus.fleet_unit_assoc_id, fus.object_version_number, fus.reconfig_sr_id,
424: fus.association_start, fus.association_end
425: FROM ahl_fleet_unit_assocs fus, ahl_simulation_plans_b sim, ahl_fleet_headers_b flt
426: WHERE sim.primary_plan_flag = 'Y'
427: AND sim.simulation_type = 'UMP'
428: AND flt.fleet_header_id = fus.fleet_header_id
429: AND flt.status_code = 'COMPLETE'

Line 467: FROM ahl_fleet_unit_assocs fus, ahl_simulation_plans_b sim, ahl_fleet_headers_b flt

463:
464: CURSOR get_prev_opstype(c_unit_config_header_id NUMBER,c_association_start DATE )
465: IS
466: SELECT flt.operations_type_code
467: FROM ahl_fleet_unit_assocs fus, ahl_simulation_plans_b sim, ahl_fleet_headers_b flt
468: WHERE sim.primary_plan_flag = 'Y'
469: AND sim.simulation_type = 'UMP'
470: AND fus.simulation_plan_id = sim.simulation_plan_id
471: AND flt.fleet_header_id = fus.fleet_header_id