APPS.AHL_AMP_WORKBENCH_PVT dependencies on AHL_SIMULATION_PLANS_B

Line 1035: FROM AHL_SIMULATION_PLANS_B ASP

1031: AND FUA.FLEET_HEADER_ID = FHB.FLEET_HEADER_ID
1032: AND UCH.MASTER_CONFIG_ID = MC.MC_HEADER_ID
1033: AND FUA.SIMULATION_PLAN_ID =
1034: (SELECT ASP.SIMULATION_PLAN_ID
1035: FROM AHL_SIMULATION_PLANS_B ASP
1036: WHERE ASP.PRIMARY_PLAN_FLAG = 'Y'
1037: AND ASP.status_code = 'ACTIVE'
1038: AND ASP.simulation_type = 'UMP' -- Sthilak added this extra filter condition AMP-AutoVisit Changes
1039: )

Line 1313: FROM AHL_SIMULATION_PLANS_B ASP

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
1313: FROM AHL_SIMULATION_PLANS_B ASP
1314: WHERE ASP.PRIMARY_PLAN_FLAG = 'Y'
1315: AND ASP.status_code = 'ACTIVE'
1316: AND ASP.simulation_type = 'UMP' -- Sthilak added this extra filter condition AMP-AutoVisit Changes
1317: )

Line 1716: FROM AHL_SIMULATION_PLANS_B ASP

1712: AND FUA.FLEET_HEADER_ID = FHB.FLEET_HEADER_ID
1713: AND UCH.MASTER_CONFIG_ID = MC.MC_HEADER_ID
1714: AND FUA.SIMULATION_PLAN_ID =
1715: (SELECT ASP.SIMULATION_PLAN_ID
1716: FROM AHL_SIMULATION_PLANS_B ASP
1717: WHERE ASP.PRIMARY_PLAN_FLAG = 'Y'
1718: AND ASP.status_code = 'ACTIVE'
1719: AND ASP.simulation_type = 'UMP' -- Sthilak added this extra filter condition AMP-AutoVisit Changes
1720: )

Line 1774: FROM AHL_SIMULATION_PLANS_B ASP

1770: AND FUA.FLEET_HEADER_ID = FHB.FLEET_HEADER_ID
1771: AND UCH.MASTER_CONFIG_ID = MC.MC_HEADER_ID
1772: AND FUA.SIMULATION_PLAN_ID =
1773: (SELECT ASP.SIMULATION_PLAN_ID
1774: FROM AHL_SIMULATION_PLANS_B ASP
1775: WHERE ASP.PRIMARY_PLAN_FLAG = 'Y'
1776: AND ASP.status_code = 'ACTIVE'
1777: AND ASP.simulation_type = 'UMP' -- Sthilak added this extra filter condition AMP-AutoVisit Changes
1778: )