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_REQST_MATRL_PVT dependencies on AHL_VISIT_STAGE_TYP_ASOC

Line 3576: FROM ahl_visit_stage_typ_asoc assoc, ahl_visit_tasks_b task, ahl_vwp_stages_b stage

3572: Cursor get_stage_task (c_visit_id IN NUMBER,
3573: c_stage_type_code IN VARCHAR2)
3574: IS
3575: SELECT task.visit_task_id, stage.planned_start_date
3576: FROM ahl_visit_stage_typ_asoc assoc, ahl_visit_tasks_b task, ahl_vwp_stages_b stage
3577: WHERE (assoc.stage_id = task.stage_id
3578: OR task.stage_id IS NULL)
3579: AND task.task_type_code = 'STAGE'
3580: AND task.visit_id = c_visit_id

Line 4040: FROM ahl_visit_stage_typ_asoc assoc, ahl_visit_tasks_b task

4036: Cursor get_stage_task (c_visit_id IN NUMBER,
4037: c_stage_type_code VARCHAR2)
4038: IS
4039: SELECT task.visit_task_id, task.start_date_time
4040: FROM ahl_visit_stage_typ_asoc assoc, ahl_visit_tasks_b task
4041: WHERE (assoc.stage_id = task.stage_id
4042: OR task.stage_id IS NULL)
4043: AND task.task_type_code = 'STAGE'
4044: AND task.visit_id = c_visit_id