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_SELECTED_ATTR_VALUES

Line 755: pv_selected_attr_values c

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
759: a.process_rule_id = b.process_rule_id AND

Line 772: pv_selected_attr_values c

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
776: a.process_rule_id = b.process_rule_id AND

Line 791: pv_selected_attr_values c

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
795: pv_check_match_pub.g_a_Campaign_Setup_Type

Line 813: pv_selected_attr_values c

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
817: a.process_rule_id = b.process_rule_id AND

Line 830: pv_selected_attr_values c,

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
834: b.attribute_id = pv_check_match_pub.g_a_Product_Interest AND

Line 858: pv_selected_attr_values c

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
862: b.attribute_id = pv_check_match_pub.g_a_Creation_Date AND

Line 882: pv_selected_attr_values c

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
886: a.process_rule_id = b.process_rule_id AND

Line 905: pv_selected_attr_values c

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
909: a.process_rule_id = b.process_rule_id AND

Line 922: pv_selected_attr_values c

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
926: a.process_rule_id = b.process_rule_id AND

Line 945: pv_selected_attr_values c

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
949: a.process_rule_id = b.process_rule_id AND

Line 968: pv_selected_attr_values c

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
972: a.process_rule_id = b.process_rule_id AND

Line 991: pv_selected_attr_values c

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
995: a.process_rule_id = b.process_rule_id AND

Line 1014: pv_selected_attr_values c

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
1018: a.process_rule_id = b.process_rule_id AND

Line 1031: pv_selected_attr_values c

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
1035: a.process_rule_id = b.process_rule_id AND

Line 1080: -- pv_selected_attr_values is outer joined because of IS_NULL and

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:
1080: -- pv_selected_attr_values is outer joined because of IS_NULL and
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

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 1112: FROM pv_selected_attr_values

1108: -- via the above cursor i.e c_get_enty_select_criteria(..)
1109:
1110: CURSOR c_get_selected_attr_values(c_sel_cri_id NUMBER) IS
1111: SELECT attr_value_id, attribute_value, attribute_to_value
1112: FROM pv_selected_attr_values
1113: WHERE selection_criteria_id = c_sel_cri_id;
1114:
1115:
1116: -- end ckapoor 11.5.10 Winning rule logging project

Line 2079: -- for every attribute, goto pv_selected_attr_values and construct

2075:
2076:
2077:
2078:
2079: -- for every attribute, goto pv_selected_attr_values and construct
2080: --concatenated string.
2081:
2082: -- for every attribute , goto pv_entity)attrs using attribute_id, and entity combo
2083: --and get sql_text. Unique row