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_SB_RULES_PVT dependencies on AHL_MC_RELATIONSHIPS

Line 636: FROM AHL_MC_RELATIONSHIPS

632: -- cursor to get relationship id for the given MC and position
633: CURSOR get_mc_rel_id_csr (c_mc_header_id NUMBER,
634: c_pos_key NUMBER) IS
635: SELECT relationship_id
636: FROM AHL_MC_RELATIONSHIPS
637: WHERE mc_header_id = c_mc_header_id
638: AND position_key = c_pos_key
639: AND TRUNC(NVL(active_start_date, SYSDATE)) <= TRUNC(SYSDATE)
640: AND TRUNC(NVL(active_end_date, SYSDATE+1)) > TRUNC(SYSDATE);

Line 1428: FROM AHL_MC_RELATIONSHIPS MCR

1424: AHL_SB_RULE_ITEMS SBI
1425: WHERE SBR.rule_id = SBI.rule_id
1426: AND SBI.item_group_id = c_src_item_group_id
1427: AND EXISTS (SELECT 'X'
1428: FROM AHL_MC_RELATIONSHIPS MCR
1429: WHERE MCR.relationship_id = SBR.relationship_id
1430: AND MCR.item_group_id = c_src_item_group_id
1431: AND MCR.temp_item_group_id IS NOT NULL);
1432: