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 1504: SELECT visit_id FROM AHL_VISIT_TASKS_VL

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

Line 1781: SELECT * FROM AHL_VISIT_TASKS_VL

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