eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_FLEET_UNIT_ASSOCS

Line 1548: FROM AHL_FLEET_UNIT_ASSOCS FU,

1544: DELETE FROM AHL_UE_SIMULATIONS
1545: WHERE SIMULATION_PLAN_ID = p_simulation_plan_id
1546: AND UNIT_CONFIG_HEADER_ID NOT IN
1547: (SELECT DISTINCT FU.UNIT_CONFIG_HEADER_ID
1548: FROM AHL_FLEET_UNIT_ASSOCS FU,
1549: AHL_UNIT_CONFIG_HEADERS UC
1550: WHERE SIMULATION_PLAN_ID = p_simulation_plan_id
1551: AND UC.UNIT_CONFIG_HEADER_ID = FU.UNIT_CONFIG_HEADER_ID
1552: AND ahl_util_uc_pkg.get_uc_status_code(UC.UNIT_CONFIG_HEADER_ID) NOT IN ('DRAFT', 'EXPIRED')

Line 1944: FROM ahl_fleet_unit_assocs

1940: -- JKJain, NR Analysis and Forecasting
1941:
1942: CURSOR ahl_fleet_uf_header_csr(c_uc_header_id IN NUMBER) IS
1943: SELECT simulation_plan_id
1944: FROM ahl_fleet_unit_assocs
1945: WHERE unit_config_header_id = c_uc_header_id
1946: AND simulation_plan_id = nvl(G_SIMULATION_PLAN_ID, get_primary_plan_id)
1947: AND trunc(nvl(association_end, sysdate)) >= trunc(sysdate);
1948:

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)

Line 3686: FROM ahl_fleet_unit_assocs FUA, ahl_fleet_headers_b FLT

3682: CURSOR get_next_fleet_asso_date(l_date DATE)
3683: IS
3684: SELECT * FROM(
3685: SELECT FUA.association_start
3686: FROM ahl_fleet_unit_assocs FUA, ahl_fleet_headers_b FLT
3687: WHERE FUA.unit_config_header_id = G_UC_HEADER_ID
3688: AND FUA.simulation_plan_id = nvl(G_SIMULATION_PLAN_ID, get_primary_plan_id)
3689: AND FLT.fleet_header_id = FUA.fleet_header_id
3690: AND FLT.status_code = 'COMPLETE'

Line 13035: from AHL_UNIT_CONFIG_HEADERS UC, AHL_FLEET_UNIT_ASSOCS FU

13031: -- JKJain, NR Analysis and Forecasting
13032: -- get all valid uc headers in a simulation plan
13033: CURSOR get_sim_plan_uc_root_csr (c_simulation_plan_id IN NUMBER)IS
13034: SELECT distinct UC.csi_item_instance_id
13035: from AHL_UNIT_CONFIG_HEADERS UC, AHL_FLEET_UNIT_ASSOCS FU
13036: WHERE FU.simulation_plan_id = c_simulation_plan_id
13037: and UC.UNIT_CONFIG_HEADER_ID = FU.UNIT_CONFIG_HEADER_ID
13038: and nvl(FU.association_end,sysdate) >= sysdate ;
13039:

Line 16096: FROM ahl_fleet_unit_assocs FUA, ahl_fleet_headers_b FLT

16092: CURSOR date_withing_flt_asso(c_unit_config_header_id NUMBER,
16093: c_due_date DATE,
16094: c_plan_id NUMBER) IS
16095: SELECT FUA.fleet_header_id
16096: FROM ahl_fleet_unit_assocs FUA, ahl_fleet_headers_b FLT
16097: WHERE unit_config_header_id = c_unit_config_header_id
16098: AND c_due_date between ASSOCIATION_START and nvl(ASSOCIATION_END,c_due_date)
16099: AND FLT.fleet_header_id = FUA.fleet_header_id
16100: AND FLT.status_code = 'COMPLETE'