APPS.AHL_VWP_VISITS_PVT dependencies on AHL_SIMULATION_PLANS_VL

Line 1007: FROM AHL_VISITS_VL AVTS, AHL_SIMULATION_PLANS_VL ASPV,

1003: AVTS.PRIORITY_CODE,
1004: FLVT3.MEANING PRIORITY_MEAN, AVTS.PROJECT_TEMPLATE_ID,
1005: PA.NAME PROJECT_TEMPLATE_NAME ,
1006: AVTS.UNIT_SCHEDULE_ID, AVTS.ASSO_PRIMARY_VISIT_ID
1007: FROM AHL_VISITS_VL AVTS, AHL_SIMULATION_PLANS_VL ASPV,
1008: CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS HROU,
1009: BOM_DEPARTMENTS BDPT, MTL_SYSTEM_ITEMS_B_KFV MTSB,
1010: FND_LOOKUP_VALUES_VL FLVT, FND_LOOKUP_VALUES_VL FLVT1,
1011: FND_LOOKUP_VALUES_VL FLVT2, FND_LOOKUP_VALUES_VL FLVT3,

Line 1197: FROM AHL_SIMULATION_PLANS_VL

1193:
1194: -- To find simulation plan name for the simulation id from LTP view
1195: IF (visit_rec.simulation_plan_id IS NOT NULL) THEN
1196: SELECT SIMULATION_PLAN_NAME INTO l_simulation_plan_name
1197: FROM AHL_SIMULATION_PLANS_VL
1198: WHERE SIMULATION_PLAN_ID = visit_rec.simulation_plan_id;
1199: ELSE
1200: l_simulation_plan_name := NULL;
1201: END IF;

Line 1779: FROM AHL_SIMULATION_PLANS_VL WHERE primary_plan_flag = 'Y';

1775: END IF;
1776:
1777: IF (l_Visit_rec.SIMULATION_PLAN_ID IS NULL) THEN
1778: SELECT SIMULATION_PLAN_ID INTO l_simulation_plan_id
1779: FROM AHL_SIMULATION_PLANS_VL WHERE primary_plan_flag = 'Y';
1780:
1781: l_Visit_rec.SIMULATION_PLAN_ID := l_simulation_plan_id;
1782:
1783: IF l_simulation_plan_id IS NULL THEN