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_SPACE_SCHEDULE_PVT dependencies on AHL_VISIT_DETAILS_V

Line 5339: FROM ahl_visit_details_v a , ahl_visits_vl b

5335: b.simulation_plan_id,
5336: visit_type_mean,
5337: a.start_date_time, due_by,
5338: trunc(b.close_date_time) close_date_time
5339: FROM ahl_visit_details_v a , ahl_visits_vl b
5340: WHERE a.visit_id = c_visit_id
5341: AND a.visit_id = b.visit_id
5342: AND a.simulation_plan_id = c_plan_id
5343: AND (((trunc(b.start_date_time) between trunc(c_start_period) and trunc(c_end_period))

Line 5372: FROM ahl_visit_details_v a ,

5368: b.simulation_plan_id,
5369: visit_type_mean,
5370: b.start_date_time, due_by,
5371: trunc(b.CLOSE_DATE_TIME) close_date_time
5372: FROM ahl_visit_details_v a ,
5373: ahl_visits_vl b
5374: WHERE a.visit_id = b.visit_id
5375: AND a.simulation_plan_id in (select simulation_plan_id
5376: from ahl_simulation_plans_vl where primary_plan_flag = 'Y')