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_VWP_VISITS_PVT dependencies on AHL_SIMULATION_PLANS_VL

Line 1190: FROM AHL_VISITS_VL AVTS, AHL_SIMULATION_PLANS_VL ASPV,

1186: AVTS.PRIORITY_CODE,
1187: FLVT3.MEANING PRIORITY_MEAN, AVTS.PROJECT_TEMPLATE_ID,
1188: PA.NAME PROJECT_TEMPLATE_NAME ,
1189: AVTS.UNIT_SCHEDULE_ID, AVTS.ASSO_PRIMARY_VISIT_ID
1190: FROM AHL_VISITS_VL AVTS, AHL_SIMULATION_PLANS_VL ASPV,
1191: CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS HROU,
1192: BOM_DEPARTMENTS BDPT, MTL_SYSTEM_ITEMS_B_KFV MTSB,
1193: FND_LOOKUP_VALUES_VL FLVT, FND_LOOKUP_VALUES_VL FLVT1,
1194: FND_LOOKUP_VALUES_VL FLVT2, FND_LOOKUP_VALUES_VL FLVT3,

Line 1408: FROM AHL_SIMULATION_PLANS_VL

1404:
1405: -- To find simulation plan name for the simulation id from LTP view
1406: IF (visit_rec.simulation_plan_id IS NOT NULL) THEN
1407: SELECT SIMULATION_PLAN_NAME INTO l_simulation_plan_name
1408: FROM AHL_SIMULATION_PLANS_VL
1409: WHERE SIMULATION_PLAN_ID = visit_rec.simulation_plan_id;
1410: ELSE
1411: l_simulation_plan_name := NULL;
1412: END IF;

Line 2072: FROM AHL_SIMULATION_PLANS_VL WHERE primary_plan_flag = 'Y' AND simulation_type IS NULL;

2068: IF (l_Visit_rec.SIMULATION_PLAN_ID IS NULL) THEN
2069: -- SKPATHAK :: Bug #12856492 :: 10-Aug-2012 :: Since new simulation type (UMP) has been added recently,
2070: -- need to check for primary plans only in existing LTP siulation plans for which simulation_type is null
2071: SELECT SIMULATION_PLAN_ID INTO l_simulation_plan_id
2072: FROM AHL_SIMULATION_PLANS_VL WHERE primary_plan_flag = 'Y' AND simulation_type IS NULL;
2073:
2074: l_Visit_rec.SIMULATION_PLAN_ID := l_simulation_plan_id;
2075:
2076: IF l_simulation_plan_id IS NULL THEN