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 1589: FROM ahl_vwp_stages_vl s

1585: ATTRIBUTE12,
1586: ATTRIBUTE13,
1587: ATTRIBUTE14,
1588: ATTRIBUTE15
1589: FROM ahl_vwp_stages_vl s
1590: WHERE visit_id = c_visit_id
1591: ORDER BY stage_num;
1592:
1593: -- Added by mpothuku on 01/20/05 To find if this Unit has been planned in other visits already

Line 3464: FROM ahl_vwp_stages_vl s

3460: ATTRIBUTE12,
3461: ATTRIBUTE13,
3462: ATTRIBUTE14,
3463: ATTRIBUTE15
3464: FROM ahl_vwp_stages_vl s
3465: WHERE visit_id = c_visit_id
3466: ORDER BY stage_num;
3467:
3468: -- To find the coresponding Stage id in the new visit

Line 3471: FROM ahl_vwp_stages_vl OldStage, ahl_vwp_stages_vl NewStage

3467:
3468: -- To find the coresponding Stage id in the new visit
3469: CURSOR c_new_stage(c_old_stage_id IN NUMBER, c_new_visit_id IN NUMBER) IS
3470: SELECT NewStage.Stage_Id, NewStage.Stage_Name
3471: FROM ahl_vwp_stages_vl OldStage, ahl_vwp_stages_vl NewStage
3472: WHERE OldStage.Stage_Id = c_old_stage_id
3473: AND NewStage.visit_id = c_new_visit_id
3474: AND NewStage.Stage_Num = OldStage.Stage_Num;
3475: