APPS.AHL_AMP_WORKBENCH_PVT dependencies on AHL_FLEET_HEADERS_B

Line 1027: AHL_FLEET_HEADERS_B FHB,

1023: IS
1024: SELECT DISTINCT UCH.NAME UNIT_NAME,
1025: UCH.UNIT_CONFIG_HEADER_ID UNIT_ID
1026: FROM AHL_UNIT_CONFIG_HEADERS UCH,
1027: AHL_FLEET_HEADERS_B FHB,
1028: AHL_FLEET_UNIT_ASSOCS FUA,
1029: AHL_MC_HEADERS_B MC
1030: WHERE FUA.UNIT_CONFIG_HEADER_ID = UCH.UNIT_CONFIG_HEADER_ID
1031: AND FUA.FLEET_HEADER_ID = FHB.FLEET_HEADER_ID

Line 1307: AHL_FLEET_HEADERS_B FHB,

1303: CURSOR c_flt_unit_ass_day ( c_fleet_id IN NUMBER, c_unit_id IN NUMBER, c_loop_date IN DATE)
1304: IS
1305: SELECT 'X'
1306: FROM AHL_UNIT_CONFIG_HEADERS UCH,
1307: AHL_FLEET_HEADERS_B FHB,
1308: AHL_FLEET_UNIT_ASSOCS FUA
1309: WHERE fua.unit_config_header_id = uch.unit_config_header_id
1310: AND FUA.FLEET_HEADER_ID = FHB.FLEET_HEADER_ID
1311: AND FUA.SIMULATION_PLAN_ID =

Line 1708: AHL_FLEET_HEADERS_B FHB,

1704: IS
1705: SELECT DISTINCT FHB.NAME FLEET_NAME,
1706: FUA.association_start
1707: FROM AHL_UNIT_CONFIG_HEADERS UCH,
1708: AHL_FLEET_HEADERS_B FHB,
1709: AHL_FLEET_UNIT_ASSOCS FUA,
1710: AHL_MC_HEADERS_B MC
1711: WHERE FUA.UNIT_CONFIG_HEADER_ID = UCH.UNIT_CONFIG_HEADER_ID
1712: AND FUA.FLEET_HEADER_ID = FHB.FLEET_HEADER_ID

Line 1766: AHL_FLEET_HEADERS_B FHB,

1762: SELECT DISTINCT FHB.NAME FLEET_NAME,
1763: FUA.association_start,
1764: FHB.FLEET_HEADER_ID
1765: FROM AHL_UNIT_CONFIG_HEADERS UCH,
1766: AHL_FLEET_HEADERS_B FHB,
1767: AHL_FLEET_UNIT_ASSOCS FUA,
1768: AHL_MC_HEADERS_B MC
1769: WHERE FUA.UNIT_CONFIG_HEADER_ID = UCH.UNIT_CONFIG_HEADER_ID
1770: AND FUA.FLEET_HEADER_ID = FHB.FLEET_HEADER_ID