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_COMPLEX_MX_RWSC_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 663: FROM AHL_VISIT_INST_ROUTINGS VIR, FND_LOOKUP_VALUES_VL IRC

659: AND TRUNC(NVL(active_end_date, SYSDATE+1)) > TRUNC(SYSDATE);
660:
661: CURSOR get_inst_routings_info(c_instance_id IN NUMBER, c_visit_id IN NUMBER) IS
662: SELECT VIR.inst_routing_id, VIR.object_version_number, VIR.inst_routing_code, IRC.meaning
663: FROM AHL_VISIT_INST_ROUTINGS VIR, FND_LOOKUP_VALUES_VL IRC
664: WHERE VIR.instance_id = c_instance_id
665: AND VIR.visit_id = c_visit_id
666: AND IRC.lookup_code (+) = VIR.inst_routing_code
667: AND IRC.lookup_type (+) = 'AHL_INSTANCE_ROUTING';

Line 1025: FROM AHL_VISIT_INST_ROUTINGS VIR, FND_LOOKUP_VALUES_VL IRC

1021: AND CSI.inv_master_organization_id = MTL.organization_id;
1022:
1023: CURSOR get_inst_routings_info(c_instance_id IN NUMBER, c_visit_id IN NUMBER) IS
1024: SELECT VIR.inst_routing_id, VIR.object_version_number, VIR.inst_routing_code, IRC.meaning
1025: FROM AHL_VISIT_INST_ROUTINGS VIR, FND_LOOKUP_VALUES_VL IRC
1026: WHERE VIR.instance_id = c_instance_id
1027: AND VIR.visit_id = c_visit_id
1028: AND IRC.lookup_code (+) = VIR.inst_routing_code
1029: AND IRC.lookup_type (+) = 'AHL_INSTANCE_ROUTING';