DBA Data[Home] [Help]

APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_FLEET_UTLZN_FORECAST

Line 1951: FROM ahl_fleet_utlzn_forecast FUF ,ahl_fleet_unit_assocs FUA, ahl_fleet_headers_b FLT

1947: AND trunc(nvl(association_end, sysdate)) >= trunc(sysdate);
1948:
1949: CURSOR ahl_fleet_uf_details_csr(c_uc_header_id IN NUMBER, c_simulation_plan_id In NUMBER) IS
1950: SELECT FUF.uom_code, FUF.period_start_date, FUF.period_end_date,FUA.association_start ,FUA.association_end, FUF.forecasted_daily_usage usage_per_day
1951: FROM ahl_fleet_utlzn_forecast FUF ,ahl_fleet_unit_assocs FUA, ahl_fleet_headers_b FLT
1952: WHERE FUF.fleet_header_id = FUA.fleet_header_id
1953: AND trunc(nvl(period_end_date, sysdate)) >= trunc(sysdate)
1954: AND trunc(nvl(association_end, sysdate)) >= trunc(sysdate)
1955: AND trunc(nvl(period_end_date, association_start)) >= trunc(association_start)