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.HZ_DQM_DUP_ID_PKG dependencies on HZ_TRANS_FUNCTIONS_VL

Line 2119: FROM hz_match_rule_primary p, hz_primary_trans pt, hz_trans_functions_vl f

2115: AND p.match_rule_id = p_match_rule_id;
2116:
2117: CURSOR check_inactive IS
2118: SELECT 1
2119: FROM hz_match_rule_primary p, hz_primary_trans pt, hz_trans_functions_vl f
2120: WHERE p.match_rule_id = p_match_rule_id
2121: AND pt.PRIMARY_ATTRIBUTE_ID = p.PRIMARY_ATTRIBUTE_ID
2122: AND f.function_id = pt.function_id
2123: AND nvl(f.ACTIVE_FLAG,'Y') = 'N'

Line 2126: FROM hz_match_rule_secondary s, hz_secondary_trans pt, hz_trans_functions_vl f

2122: AND f.function_id = pt.function_id
2123: AND nvl(f.ACTIVE_FLAG,'Y') = 'N'
2124: UNION
2125: SELECT 1
2126: FROM hz_match_rule_secondary s, hz_secondary_trans pt, hz_trans_functions_vl f
2127: WHERE s.match_rule_id = p_match_rule_id
2128: AND pt.SECONDARY_ATTRIBUTE_ID = s.SECONDARY_ATTRIBUTE_ID
2129: AND f.function_id = pt.function_id
2130: AND nvl(f.ACTIVE_FLAG,'Y') = 'N';