APPS.AML_INTERACTION_ENGINE dependencies on AS_SALES_LEADS

Line 341: FROM as_sales_leads sl

337:
338: CURSOR C_Match_Lead1(c_lead_interaction_lookback NUMBER, c_customer_id NUMBER,
339: c_cnt_person_party_id NUMBER) IS
340: SELECT sl.sales_lead_id--, NVL(sl.interaction_score, 0)
341: FROM as_sales_leads sl
342: WHERE sl.creation_date > (SYSDATE - c_lead_interaction_lookback)
343: AND sl.customer_id = c_customer_id
344: AND sl.primary_cnt_person_party_id = c_cnt_person_party_id
345: AND sl.status_open_flag = 'Y'

Line 350: FROM as_sales_leads sl

346: ORDER BY sl.lead_rank_score DESC, sl.creation_date DESC;
347:
348: CURSOR C_Match_Lead2(c_lead_interaction_lookback NUMBER, c_customer_id NUMBER) IS
349: SELECT sl.sales_lead_id--, NVL(sl.interaction_score, 0)
350: FROM as_sales_leads sl
351: WHERE sl.creation_date > (SYSDATE - c_lead_interaction_lookback)
352: AND sl.customer_id = c_customer_id
353: AND sl.status_open_flag = 'Y'
354: ORDER BY sl.lead_rank_score DESC, sl.creation_date DESC;

Line 687: UPDATE as_sales_leads

683: -- qualification, rating, channel selection rules, lead
684: -- doesn't need to be reprocessed.
685: IF l_check_rerun IS NOT NULL
686: THEN
687: UPDATE as_sales_leads
688: SET last_update_date = SYSDATE,
689: last_updated_by = fnd_global.user_id,
690: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,
691: qualified_flag = 'N',

Line 752: UPDATE as_sales_leads

748: END LOOP;
749: ELSE
750: -- Lead doesn't need to be reprocessed, update
751: -- interaction_score
752: UPDATE as_sales_leads
753: SET last_update_date = SYSDATE,
754: last_updated_by = fnd_global.user_id,
755: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,
756: interaction_score = NVL(interaction_score, 0)

Line 975: FROM as_sales_leads sl, as_sales_lead_opportunity slo, as_leads_all opp, as_statuses_b status

971: -- Find open opportunity, if no open lead matched
972: IF l_sales_lead_id IS NULL THEN
973: SELECT sl.sales_lead_id, sl.status_code, sl.status_open_flag
974: INTO l_sales_lead_id, l_status_code, l_status_open_flag
975: FROM as_sales_leads sl, as_sales_lead_opportunity slo, as_leads_all opp, as_statuses_b status
976: WHERE sl.creation_date > l_lead_interaction_lookback
977: AND sl.customer_id = l_customer_id
978: AND sl.status_code = 'CONVERTED_TO_OPPORTUNITY'
979: AND sl.sales_lead_id = slo.sales_lead_id

Line 988: UPDATE as_sales_leads

984: END IF;
985: IF l_status_code = 'NEW' THEN
986: Create_Sales_Lead_Lines for interest_type_id from l_source_code_id(both interaction and activities);
987: L_lead_interaction_score := l_lead_interaction_score + l_interaction_score;
988: UPDATE as_sales_leads
989: SET lead_rank_id = NULL, channel_code = NULL, interaction_score = l_lead_interaction_score
990: WHERE sales_lead_id = l_sales_lead_id;
991: Call Lead_Process_After_Update;
992: END IF;