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_LTP_SIMUL_PLAN_PVT dependencies on AHL_VWP_STAGES_VL

Line 1573: FROM ahl_vwp_stages_vl s

1569: ATTRIBUTE12,
1570: ATTRIBUTE13,
1571: ATTRIBUTE14,
1572: ATTRIBUTE15
1573: FROM ahl_vwp_stages_vl s
1574: WHERE visit_id = c_visit_id
1575: ORDER BY stage_num;
1576:
1577: -- Added by mpothuku on 01/20/05 To find if this Unit has been planned in other visits already

Line 3418: FROM ahl_vwp_stages_vl s

3414: ATTRIBUTE12,
3415: ATTRIBUTE13,
3416: ATTRIBUTE14,
3417: ATTRIBUTE15
3418: FROM ahl_vwp_stages_vl s
3419: WHERE visit_id = c_visit_id
3420: ORDER BY stage_num;
3421:
3422: -- To find the coresponding Stage id in the new visit

Line 3425: FROM ahl_vwp_stages_vl OldStage, ahl_vwp_stages_vl NewStage

3421:
3422: -- To find the coresponding Stage id in the new visit
3423: CURSOR c_new_stage(c_old_stage_id IN NUMBER, c_new_visit_id IN NUMBER) IS
3424: SELECT NewStage.Stage_Id, NewStage.Stage_Name
3425: FROM ahl_vwp_stages_vl OldStage, ahl_vwp_stages_vl NewStage
3426: WHERE OldStage.Stage_Id = c_old_stage_id
3427: AND NewStage.visit_id = c_new_visit_id
3428: AND NewStage.Stage_Num = OldStage.Stage_Num;
3429: