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

Line 754: pv_enty_select_criteria b,

750: -- Country
751: -- -------------------------------------------------------------------
752: SELECT DISTINCT a.process_rule_id, a.rank, a.currency_code
753: FROM pv_process_rules_b a,
754: pv_enty_select_criteria b,
755: pv_selected_attr_values c
756: WHERE b.selection_type_code = 'INPUT_FILTER' AND
757: b.attribute_id = pv_check_match_pub.g_a_Country_ AND
758: a.process_type = c_process_type AND

Line 771: pv_enty_select_criteria b,

767: -- -------------------------------------------------------------------
768: UNION ALL
769: SELECT DISTINCT a.process_rule_id, a.rank, a.currency_code
770: FROM pv_process_rules_b a,
771: pv_enty_select_criteria b,
772: pv_selected_attr_values c
773: WHERE b.selection_type_code = 'INPUT_FILTER' AND
774: b.attribute_id = pv_check_match_pub.g_a_Campaign_ AND
775: a.process_type = c_process_type AND

Line 790: pv_enty_select_criteria b,

786: -- -------------------------------------------------------------------
787: UNION ALL
788: SELECT DISTINCT a.process_rule_id, a.rank, a.currency_code
789: FROM pv_process_rules_b a,
790: pv_enty_select_criteria b,
791: pv_selected_attr_values c
792: WHERE b.selection_type_code = 'INPUT_FILTER' AND
793: b.attribute_id =
794: --575

Line 812: pv_enty_select_criteria b,

808: -- -------------------------------------------------------------------
809: UNION ALL
810: SELECT DISTINCT a.process_rule_id, a.rank, a.currency_code
811: FROM pv_process_rules_b a,
812: pv_enty_select_criteria b,
813: pv_selected_attr_values c
814: WHERE b.selection_type_code = 'INPUT_FILTER' AND
815: b.attribute_id = pv_check_match_pub.g_a_Lead_Status AND
816: a.process_type = c_process_type AND

Line 829: pv_enty_select_criteria b,

825: -- -------------------------------------------------------------------
826: UNION ALL
827: SELECT DISTINCT a.process_rule_id, a.rank, a.currency_code
828: FROM pv_process_rules_b a,
829: pv_enty_select_criteria b,
830: pv_selected_attr_values c,
831: as_sales_lead_lines asll
832: WHERE a.process_rule_id = b.process_rule_id AND
833: b.selection_criteria_id = c.selection_criteria_id(+) AND

Line 857: pv_enty_select_criteria b,

853: -- -------------------------------------------------------------------
854: UNION ALL
855: SELECT DISTINCT a.process_rule_id, a.rank, a.currency_code
856: FROM pv_process_rules_b a,
857: pv_enty_select_criteria b,
858: pv_selected_attr_values c
859: WHERE a.process_rule_id = b.process_rule_id AND
860: b.selection_type_code = 'INPUT_FILTER' AND
861: b.selection_criteria_id = c.selection_criteria_id(+) AND

Line 881: pv_enty_select_criteria b,

877: -- -------------------------------------------------------------------
878: UNION ALL
879: SELECT DISTINCT a.process_rule_id, a.rank, a.currency_code
880: FROM pv_process_rules_b a,
881: pv_enty_select_criteria b,
882: pv_selected_attr_values c
883: WHERE b.selection_type_code = 'INPUT_FILTER' AND
884: b.attribute_id = pv_check_match_pub.g_a_Area_Code AND
885: a.process_type = c_process_type AND

Line 904: pv_enty_select_criteria b,

900: -- -------------------------------------------------------------------
901: UNION ALL
902: SELECT DISTINCT a.process_rule_id, a.rank, a.currency_code
903: FROM pv_process_rules_b a,
904: pv_enty_select_criteria b,
905: pv_selected_attr_values c
906: WHERE b.selection_type_code = 'INPUT_FILTER' AND
907: b.attribute_id = pv_check_match_pub.g_a_State_ AND
908: a.process_type = c_process_type AND

Line 921: pv_enty_select_criteria b,

917: -- -------------------------------------------------------------------
918: UNION ALL
919: SELECT DISTINCT a.process_rule_id, a.rank, a.currency_code
920: FROM pv_process_rules_b a,
921: pv_enty_select_criteria b,
922: pv_selected_attr_values c
923: WHERE b.selection_type_code = 'INPUT_FILTER' AND
924: b.attribute_id = pv_check_match_pub.g_a_Province AND
925: a.process_type = c_process_type AND

Line 944: pv_enty_select_criteria b,

940: -- -------------------------------------------------------------------
941: UNION ALL
942: SELECT DISTINCT a.process_rule_id, a.rank, a.currency_code
943: FROM pv_process_rules_b a,
944: pv_enty_select_criteria b,
945: pv_selected_attr_values c
946: WHERE b.selection_type_code = 'INPUT_FILTER' AND
947: b.attribute_id = pv_check_match_pub.g_a_County AND
948: a.process_type = c_process_type AND

Line 967: pv_enty_select_criteria b,

963: -- -------------------------------------------------------------------
964: UNION ALL
965: SELECT DISTINCT a.process_rule_id, a.rank, a.currency_code
966: FROM pv_process_rules_b a,
967: pv_enty_select_criteria b,
968: pv_selected_attr_values c
969: WHERE b.selection_type_code = 'INPUT_FILTER' AND
970: b.attribute_id = pv_check_match_pub.g_a_City AND
971: a.process_type = c_process_type AND

Line 990: pv_enty_select_criteria b,

986: -- -------------------------------------------------------------------
987: UNION ALL
988: SELECT DISTINCT a.process_rule_id, a.rank, a.currency_code
989: FROM pv_process_rules_b a,
990: pv_enty_select_criteria b,
991: pv_selected_attr_values c
992: WHERE b.selection_type_code = 'INPUT_FILTER' AND
993: b.attribute_id = pv_check_match_pub.g_a_Postal_Code AND
994: a.process_type = c_process_type AND

Line 1013: pv_enty_select_criteria b,

1009: -- -------------------------------------------------------------------
1010: UNION ALL
1011: SELECT DISTINCT a.process_rule_id, a.rank, a.currency_code
1012: FROM pv_process_rules_b a,
1013: pv_enty_select_criteria b,
1014: pv_selected_attr_values c
1015: WHERE b.selection_type_code = 'INPUT_FILTER' AND
1016: b.attribute_id = pv_check_match_pub.g_a_Customer_Category AND
1017: a.process_type = c_process_type AND

Line 1030: pv_enty_select_criteria b,

1026: -------------------------------------------------------------------
1027: UNION ALL
1028: SELECT DISTINCT a.process_rule_id, a.rank, a.currency_code
1029: FROM pv_process_rules_b a,
1030: pv_enty_select_criteria b,
1031: pv_selected_attr_values c
1032: WHERE b.selection_type_code = 'INPUT_FILTER' AND
1033: b.attribute_id = pv_check_match_pub.g_a_all AND
1034: a.process_type = c_process_type AND

Line 1043: pv_enty_select_criteria b

1039: GROUP BY rule.process_rule_id, rule.rank, rule.currency_code
1040: HAVING (rule.process_rule_id, COUNT(*)) IN (
1041: SELECT a.process_rule_id, COUNT(*)
1042: FROM pv_process_rules_b a,
1043: pv_enty_select_criteria b
1044: WHERE a.process_rule_id = b.process_rule_id AND
1045: b.selection_type_code = 'INPUT_FILTER' AND
1046: a.status_code = 'ACTIVE' AND
1047: a.process_type = c_process_type AND

Line 1085: FROM pv_enty_select_criteria cra, pv_selected_attr_values val

1081: -- IS_NOT_NULL operator.
1082: CURSOR C_Get_Criterion_Attributes(c_process_rule_id NUMBER) IS
1083: SELECT cra.selection_criteria_id, cra.attribute_id, cra.operator,
1084: val.attribute_value, val.attribute_to_value
1085: FROM pv_enty_select_criteria cra, pv_selected_attr_values val
1086: WHERE cra.process_rule_id = c_process_rule_id
1087: AND cra.selection_type_code = 'CRITERION'
1088: AND cra.selection_criteria_id = val.selection_criteria_id(+)
1089: ORDER BY cra.selection_criteria_id;

Line 1103: FROM pv_enty_select_criteria c, pv_attributes_b b

1099:
1100: CURSOR c_get_enty_select_criteria(c_winning_rule_id NUMBER) IS
1101: SELECT c.selection_criteria_id, c.attribute_id, c.selection_type_code, c.operator,
1102: b.return_type
1103: FROM pv_enty_select_criteria c, pv_attributes_b b
1104: WHERE c.process_rule_id = c_winning_rule_id
1105: and b.attribute_id = c.attribute_id;
1106:
1107: -- Cursor to get the attribute value information for all attributes selected