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.PV_RULE_EVALUATION_PUB dependencies on PV_PROCESS_RULES_VL

Line 137: -- FROM pv_process_rules_vl a, pv_enty_select_criteria b,

133:
134: -- Inline View Z :
135:
136: -- "SELECT a.process_rule_id, b.attribute_id, x.rank, x.process_rule_id rule_id
137: -- FROM pv_process_rules_vl a, pv_enty_select_criteria b,
138: -- (SELECT rownum rank, column_value process_rule_id
139: -- FROM (SELECT column_value FROM TABLE (CAST(p_rule_id_tbl AS JTF_NUMBER_TABLE))) ) x
140: -- WHERE a.process_rule_id = x.process_rule_id
141: -- AND a.process_rule_id = b.process_rule_id "

Line 188: FROM pv_process_rules_vl Rule,

184: criterion.operator Operator,
185: criterion.selection_criteria_id Criteria_ID,
186: AttVal.attribute_value Attr_Value,
187: AttVal.attribute_to_value Attr_To_Value
188: FROM pv_process_rules_vl Rule,
189: pv_enty_select_criteria Criterion,
190: pv_selected_attr_values AttVal,
191: ( SELECT attribute_id,TO_NUMBER(LTRIM(substr(rule_rank, 1, 10), 0)) rank,TO_NUMBER(LTRIM(substr(rule_rank, 11, LENGTH(rule_rank)), 0)) rule_id
192: FROM (

Line 196: FROM pv_process_rules_vl a,

192: FROM (
193: SELECT z.attribute_id, MAX(LPAD(z.rank, 10, 0) || LPAD(z.process_rule_id, 100, 0)) rule_rank
194: FROM (
195: SELECT a.process_rule_id, b.attribute_id, x.rank, x.process_rule_id rule_id
196: FROM pv_process_rules_vl a,
197: pv_enty_select_criteria b,
198: (SELECT rownum rank, column_value process_rule_id
199: FROM (SELECT column_value
200: FROM TABLE (CAST(p_rule_id_tbl AS JTF_NUMBER_TABLE))) ) x

Line 943: -- FROM pv_process_rules_vl a, pv_enty_select_criteria b,

939:
940: -- Inline View Z :
941:
942: -- "SELECT a.process_rule_id, b.attribute_id, x.rank, x.process_rule_id rule_id
943: -- FROM pv_process_rules_vl a, pv_enty_select_criteria b,
944: -- (SELECT rownum rank, column_value process_rule_id
945: -- FROM (SELECT column_value FROM TABLE (CAST(p_rule_id_tbl AS JTF_NUMBER_TABLE))) ) x
946: -- WHERE a.process_rule_id = x.process_rule_id
947: -- AND a.process_rule_id = b.process_rule_id "

Line 994: FROM pv_process_rules_vl Rule,

990: criterion.operator Operator,
991: criterion.selection_criteria_id Criteria_ID,
992: AttVal.attribute_value Attr_Value,
993: AttVal.attribute_to_value Attr_To_Value
994: FROM pv_process_rules_vl Rule,
995: pv_enty_select_criteria Criterion,
996: pv_selected_attr_values AttVal,
997: ( SELECT attribute_id,TO_NUMBER(LTRIM(substr(rule_rank, 1, 10), 0)) rank,TO_NUMBER(LTRIM(substr(rule_rank, 11, LENGTH(rule_rank)), 0)) rule_id
998: FROM (

Line 1002: FROM pv_process_rules_vl a,

998: FROM (
999: SELECT z.attribute_id, MAX(LPAD(z.rank, 10, 0) || LPAD(z.process_rule_id, 100, 0)) rule_rank
1000: FROM (
1001: SELECT a.process_rule_id, b.attribute_id, x.rank, x.process_rule_id rule_id
1002: FROM pv_process_rules_vl a,
1003: pv_enty_select_criteria b,
1004: (SELECT rownum rank, column_value process_rule_id
1005: FROM (SELECT column_value
1006: FROM TABLE (CAST(p_rule_id_tbl AS JTF_NUMBER_TABLE))) ) x