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_PROCESS_RULES_B

Line 753: FROM pv_process_rules_b a,

749: -- -------------------------------------------------------------------
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

Line 770: FROM pv_process_rules_b a,

766: -- Campaign
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

Line 789: FROM pv_process_rules_b a,

785: -- Campaign setup type
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 =

Line 811: FROM pv_process_rules_b a,

807: -- Lead Status
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

Line 828: FROM pv_process_rules_b a,

824: -- Product Interest
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

Line 856: FROM pv_process_rules_b a,

852: -- Date Created
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

Line 880: FROM pv_process_rules_b a,

876: -- Area Code
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

Line 903: FROM pv_process_rules_b a,

899: -- State
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

Line 920: FROM pv_process_rules_b a,

916: -- Province
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

Line 943: FROM pv_process_rules_b a,

939: -- County
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

Line 966: FROM pv_process_rules_b a,

962: -- City
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

Line 989: FROM pv_process_rules_b a,

985: -- Postal Code
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

Line 1012: FROM pv_process_rules_b a,

1008: -- Customer Category
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

Line 1029: FROM pv_process_rules_b a,

1025: -- All
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

Line 1042: FROM pv_process_rules_b a,

1038: ) rule
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

Line 1056: FROM pv_process_rules_b rule, as_sales_lead_ranks_b rank

1052: -- Retrieve rating criteria for the rule
1053: CURSOR c_get_rating_criterion_rule(c_process_rule_id NUMBER) IS
1054: SELECT rule.process_rule_id, rule.action, rule.action_value,
1055: rank.min_score
1056: FROM pv_process_rules_b rule, as_sales_lead_ranks_b rank
1057: WHERE rule.parent_rule_id = c_process_rule_id
1058: AND rank.rank_id = TO_NUMBER(rule.action_value)
1059: ORDER BY rule.rank;
1060:

Line 1065: FROM pv_process_rules_b rule, pv_channel_types channel

1061: -- Retrieve channel selection criteria for the rule
1062: CURSOR c_get_channel_criterion_rule(c_process_rule_id NUMBER) IS
1063: SELECT rule.process_rule_id, rule.action, rule.action_value,
1064: NVL(channel.rank, 0)
1065: FROM pv_process_rules_b rule, pv_channel_types channel
1066: WHERE rule.parent_rule_id = c_process_rule_id
1067: AND channel.channel_lookup_code(+) = rule.action_value
1068: ORDER BY rule.rank;
1069:

Line 1075: FROM pv_process_rules_b rule

1071:
1072: CURSOR c_get_qual_cri_rule(c_process_rule_id NUMBER) IS
1073: SELECT rule.process_rule_id, rule.action, rule.action_value ,
1074: decode(rule.action_value, 'Y', 1, 'N', 0)
1075: FROM pv_process_rules_b rule
1076: WHERE rule.parent_rule_id = c_process_rule_id
1077: ORDER BY rule.rank; -- just make sure 'Y' comes before 'N'
1078: -- end ckapoor
1079: