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_TYPES_B

Line 1144: FROM ahl_unit_effectivities_b ue, ahl_mr_headers_b mr, ahl_mr_visit_types_app_v mr_vtyp, ahl_visit_types_b vtyp,

1140: c_start_date IN DATE,
1141: c_end_date IN DATE) is
1142: SELECT ue.unit_effectivity_id, ue.due_date, ue.csi_item_instance_id, mr.mr_header_id,
1143: mr_vtyp.mr_visit_type_code, vtyp.estimated_duration
1144: FROM ahl_unit_effectivities_b ue, ahl_mr_headers_b mr, ahl_mr_visit_types_app_v mr_vtyp, ahl_visit_types_b vtyp,
1145: AHL_UNIT_CONFIG_HEADERS unit, ahl_mc_headers_b mc
1146: WHERE ue.csi_item_instance_id = unit.csi_item_instance_id
1147: AND unit.master_config_id = mc.mc_header_id
1148: AND unit.unit_config_status_code NOT IN ('QUARANTINE', 'EXPIRED')