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.AML_MONITOR_WF dependencies on PV_ENTY_SELECT_CRITERIA

Line 102: pv_enty_select_criteria b,

98: -- Country
99: -- ------------------------------------------------------------
100: SELECT DISTINCT a.process_rule_id, d.monitor_condition_id, d.time_lag_num
101: FROM pv_process_rules_b a,
102: pv_enty_select_criteria b,
103: pv_selected_attr_values c,
104: AML_monitor_conditions d
105: WHERE b.selection_type_code = 'MONITOR_SCOPE'
106: AND b.attribute_id = pv_check_match_pub.g_a_Country_

Line 121: pv_enty_select_criteria b,

117: -- INTERSECT
118: UNION ALL
119: SELECT DISTINCT a.process_rule_id, d.monitor_condition_id, d.time_lag_num
120: FROM pv_process_rules_b a,
121: pv_enty_select_criteria b,
122: pv_selected_attr_values c,
123: AML_monitor_conditions d
124: WHERE b.selection_type_code = 'MONITOR_SCOPE'
125: AND b.attribute_id =pv_check_match_pub.g_a_Lead_Rating

Line 138: pv_enty_select_criteria b

134: GROUP BY rule.process_rule_id, rule.monitor_condition_id,rule.time_lag_num
135: HAVING (rule.process_rule_id, COUNT(*)) IN (
136: SELECT a.process_rule_id, COUNT(*)
137: FROM pv_process_rules_b a,
138: pv_enty_select_criteria b
139: WHERE a.process_rule_id = b.process_rule_id AND
140: b.selection_type_code = 'MONITOR_SCOPE' AND
141: a.status_code = 'ACTIVE' AND
142: a.process_type = 'LEAD_MONITOR' AND

Line 2830: pv_enty_select_criteria b,

2826: -- Country
2827: -- ------------------------------------------------------------
2828: SELECT DISTINCT a.process_rule_id, d.monitor_condition_id, d.time_lag_num
2829: FROM pv_process_rules_b a,
2830: pv_enty_select_criteria b,
2831: pv_selected_attr_values c,
2832: AML_monitor_conditions d
2833: WHERE b.selection_type_code = 'MONITOR_SCOPE'
2834: AND b.attribute_id = pv_check_match_pub.g_a_Country_

Line 2848: pv_enty_select_criteria b,

2844: -- ------------------------------------------------------------
2845: INTERSECT
2846: SELECT DISTINCT a.process_rule_id, d.monitor_condition_id, d.time_lag_num
2847: FROM pv_process_rules_b a,
2848: pv_enty_select_criteria b,
2849: pv_selected_attr_values c,
2850: AML_monitor_conditions d
2851: WHERE b.selection_type_code = 'MONITOR_SCOPE'
2852: AND b.attribute_id =pv_check_match_pub.g_a_Lead_Rating

Line 2865: pv_enty_select_criteria b

2861: GROUP BY rule.process_rule_id, rule.monitor_condition_id,rule.time_lag_num
2862: HAVING (rule.process_rule_id) IN (
2863: SELECT a.process_rule_id
2864: FROM pv_process_rules_b a,
2865: pv_enty_select_criteria b
2866: WHERE a.process_rule_id = b.process_rule_id AND
2867: b.selection_type_code = 'MONITOR_SCOPE' AND
2868: a.status_code = 'ACTIVE' AND
2869: a.process_type = 'LEAD_MONITOR' AND