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_COST_PVT dependencies on AHL_VISIT_TASKS_VL

Line 1507: SELECT visit_id FROM AHL_VISIT_TASKS_VL

1503: visit_rec c_visit_details%ROWTYPE;
1504:
1505: -- To find visit id for a given task
1506: CURSOR c_task (x_T_id IN NUMBER) IS
1507: SELECT visit_id FROM AHL_VISIT_TASKS_VL
1508: WHERE VISIT_TASK_ID = x_T_id;
1509:
1510: -- To find if job exists for the visit at shop floor
1511: -- in 'Draft' status

Line 1784: SELECT * FROM AHL_VISIT_TASKS_VL

1780:
1781: -- Define Local Cursors
1782: -- To find task related information when its for a visit
1783: CURSOR c_task (x_T_id IN NUMBER) IS
1784: SELECT * FROM AHL_VISIT_TASKS_VL
1785: WHERE VISIT_TASK_ID = x_T_id;
1786: task_rec c_task%ROWTYPE;
1787:
1788: BEGIN