DBA Data[Home] [Help]

APPS.AHL_FLEET_FORECAST_PVT dependencies on AHL_SIMULATION_PLANS_B

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