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_RM_ROUTE_UTIL dependencies on AHL_MC_RULES_B

Line 4375: from AHL_MC_PATH_POSITION_NODES ampp, AHL_MC_RULE_STATEMENTS amrs, ahl_mc_headers_b amh2,ahl_mc_rules_b mcrule,ahl_mc_relationships rel

4371: flv.lookup_code = amr.position_ref_code AND
4372: flv.meaning = c_mc_position and
4373: nvl(amr.parent_relationship_id, -1) not in (
4374: select rel.relationship_id
4375: from AHL_MC_PATH_POSITION_NODES ampp, AHL_MC_RULE_STATEMENTS amrs, ahl_mc_headers_b amh2,ahl_mc_rules_b mcrule,ahl_mc_relationships rel
4376: where ampp.mc_id = c_mc_id and
4377: ampp.path_position_node_id = amrs.subject_id and
4378: amrs.subject_type = 'POSITION' and
4379: amrs.operator = 'MUST_HAVE' and

Line 4403: from AHL_MC_PATH_POSITION_NODES ampp, AHL_MC_RULE_STATEMENTS amrs, ahl_mc_headers_b amh2,ahl_mc_rules_b mcrule,ahl_mc_relationships rel

4399: nvl(amr.active_end_date, SYSDATE + 1) > SYSDATE AND
4400: amr.position_key = c_mc_position_key and
4401: nvl(amr.parent_relationship_id, -1) not in (
4402: select rel.relationship_id
4403: from AHL_MC_PATH_POSITION_NODES ampp, AHL_MC_RULE_STATEMENTS amrs, ahl_mc_headers_b amh2,ahl_mc_rules_b mcrule,ahl_mc_relationships rel
4404: where ampp.mc_id = c_mc_id and
4405: ampp.path_position_node_id = amrs.subject_id and
4406: amrs.subject_type = 'POSITION' and
4407: amrs.operator = 'MUST_HAVE' and