DBA Data[Home] [Help]

APPS.PV_OPP_MATCH_PUB dependencies on PV_SELECTED_ATTR_VALUES

Line 911: pv_selected_attr_values b,

907: b.attribute_value, b.attribute_to_value,
908: a.selection_criteria_id,
909: c.return_type
910: FROM pv_enty_select_criteria a,
911: pv_selected_attr_values b,
912: pv_attributes_vl c
913: WHERE a.attribute_id = c.attribute_id AND
914: a.selection_criteria_id = b.selection_criteria_id (+) AND
915: a.selection_type_code = 'PARTNER_SELECTION' AND

Line 2564: pv_selected_attr_values psav

2560: psav.attribute_value,
2561: psav.attribute_to_value
2562: FROM pv_process_rules_vl prr,
2563: pv_enty_select_criteria pesc,
2564: pv_selected_attr_values psav
2565: WHERE prr.process_rule_id = pesc.process_rule_id AND
2566: pesc.selection_criteria_id = psav.selection_criteria_id (+) AND
2567: prr.status_code = 'ACTIVE' AND
2568: TRUNC(SYSDATE) BETWEEN prr.start_date AND