APPS.AHL_AMP_WORKBENCH_PVT dependencies on AHL_FLEET_UNIT_ASSOCS

Line 1028: AHL_FLEET_UNIT_ASSOCS FUA,

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
1032: AND UCH.MASTER_CONFIG_ID = MC.MC_HEADER_ID

Line 1308: AHL_FLEET_UNIT_ASSOCS FUA

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 =
1312: (SELECT ASP.SIMULATION_PLAN_ID

Line 1709: AHL_FLEET_UNIT_ASSOCS FUA,

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
1713: AND UCH.MASTER_CONFIG_ID = MC.MC_HEADER_ID

Line 1767: AHL_FLEET_UNIT_ASSOCS FUA,

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
1771: AND UCH.MASTER_CONFIG_ID = MC.MC_HEADER_ID