DBA Data[Home] [Help]

APPS.PV_RULE_EVALUATION_PUB dependencies on PV_SELECTED_ATTR_VALUES

Line 190: pv_selected_attr_values AttVal,

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 (
193: SELECT z.attribute_id, MAX(LPAD(z.rank, 10, 0) || LPAD(z.process_rule_id, 100, 0)) rule_rank
194: FROM (

Line 996: pv_selected_attr_values AttVal,

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 (
999: SELECT z.attribute_id, MAX(LPAD(z.rank, 10, 0) || LPAD(z.process_rule_id, 100, 0)) rule_rank
1000: FROM (