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_AVF_PRIM_VSTS_PVT dependencies on AHL_VISIT_TASKS_B

Line 144: FROM ahl_ue_relationships uer, ahl_visit_tasks_b vtk, ahl_unit_effectivities_b uet

140: CURSOR check_parent_mr(c_ue_id in NUMBER,
141: c_instance_id in NUMBER,
142: c_visit_id in NUMBER)IS
143: SELECT 'X'
144: FROM ahl_ue_relationships uer, ahl_visit_tasks_b vtk, ahl_unit_effectivities_b uet
145: WHERE uer.ue_id = c_ue_id
146: AND vtk.instance_id = c_instance_id
147: AND vtk.visit_id = c_visit_id
148: AND uer.ue_id = uet.unit_effectivity_id

Line 163: AND NOT exists (SELECT 'X' FROM ahl_visit_tasks_b task, ahl_visits_b visit

159: AND une.due_date is NOT NULL
160: AND (une.due_date between c_start_date AND c_end_date or (une.earliest_due_date between c_start_date AND c_end_date OR une.latest_due_date between c_start_date AND c_end_date))
161: AND NOT EXISTS (SELECT 'X' FROM ahl_ue_relationships uer WHERE uer.related_ue_id = une.unit_effectivity_id)
162: AND une.mr_header_id = mrh.mr_header_id
163: AND NOT exists (SELECT 'X' FROM ahl_visit_tasks_b task, ahl_visits_b visit
164: WHERE task.visit_id = visit.visit_id AND task.unit_effectivity_id = une.unit_effectivity_id
165: AND task.status_code NOT IN ('CANCELLED', 'DELETED'));
166:
167: -- Get the start and end dates of the Snapshot

Line 195: AND NOT exists (SELECT 'X' FROM ahl_visit_tasks_b task, ahl_visits_b visit

191: AND une.due_date IS NOT NULL
192: AND (une.due_date between c_start_date AND c_end_date or (une.earliest_due_date between c_start_date AND c_end_date OR une.latest_due_date between c_start_date AND c_end_date))
193: AND NOT EXISTS (SELECT 'X' FROM ahl_ue_relationships uer WHERE uer.related_ue_id = une.unit_effectivity_id)
194: AND une.mr_header_id = mrh.mr_header_id
195: AND NOT exists (SELECT 'X' FROM ahl_visit_tasks_b task, ahl_visits_b visit
196: WHERE task.visit_id = visit.visit_id AND task.unit_effectivity_id = une.unit_effectivity_id
197: AND task.status_code NOT IN ('CANCELLED', 'DELETED'));
198:
199: -- Get the correct VISIT_ID for the given UE_ID.

Line 1159: AND NOT EXISTS (SELECT 'X' from ahl_visit_tasks_b task

1155: AND mr.mr_header_id = mr_vtyp.mr_header_id
1156: AND mr_vtyp.mr_visit_type_code = vtyp.visit_type_code
1157: AND vtyp.mc_id = c_mc_id
1158: AND vtyp.status_code = 'COMPLETE'
1159: AND NOT EXISTS (SELECT 'X' from ahl_visit_tasks_b task
1160: WHERE task.unit_effectivity_id = ue.unit_effectivity_id
1161: AND task.status_code NOT IN ('CANCELLED', 'DELETED') )
1162: AND ue.due_date BETWEEN c_start_date AND c_end_date
1163: AND NVL(ue.earliest_due_date, c_end_date) BETWEEN c_start_date AND c_end_date