APPS.BIM_I_LEAD_FACTS_PKG dependencies on AS_SALES_LEADS

Line 437: as_sales_leads X

433: ,y.category_id product_category_id
434: ,'N' CUSTOMER_FLAG
435: ,x.DESCRIPTION
436: FROM
437: as_sales_leads X
438: ,as_sales_lead_lines Y
439: WHERE
440: X.creation_date between p_start_date and l_sysdate
441: AND X.sales_lead_id = Y.sales_lead_id(+) ;

Line 704: as_sales_leads_log hist

700: UPDATE bim_i_lead_facts facts
701: SET (facts.lead_closed_date, facts.lead_touched_date)
702: = (SELECT TRUNC(MIN(hist.creation_date)), TRUNC(MIN(hist.creation_date))
703: FROM
704: as_sales_leads_log hist
705: ,as_statuses_b st
706: WHERE
707: hist.last_update_date between p_start_date and l_sysdate
708: AND hist.status_code not in (l_conv_opp_status, l_dead_status)

Line 719: as_sales_leads_log hist

715: )
716: WHERE
717: EXISTS (SELECT 1
718: FROM
719: as_sales_leads_log hist
720: ,as_statuses_b st
721: WHERE
722: hist.last_update_date between p_start_date and l_sysdate
723: AND hist.status_code not in (l_conv_opp_status, l_dead_status)

Line 974: as_sales_leads X

970: -- ,nvl(x.currency_code,'USD') from_currency
971: ,'N' CUSTOMER_FLAG
972: ,x.DESCRIPTION
973: FROM
974: as_sales_leads X
975: WHERE
976: X.last_update_date between p_start_date and l_sysdate
977: AND X.creation_date >=p_global_date ;
978:

Line 1059: as_sales_leads X

1055: ,y.category_id product_category_id
1056: ,'N' CUSTOMER_FLAG
1057: ,x.DESCRIPTION
1058: FROM
1059: as_sales_leads X
1060: ,as_sales_lead_lines Y
1061: WHERE
1062: (X.last_update_date between p_start_date and l_sysdate OR Y.last_update_date between p_start_date and l_sysdate)
1063: AND X.sales_lead_id = Y.sales_lead_id

Line 1367: as_sales_leads_log hist

1363: UPDATE bim_i_lead_facts facts
1364: SET facts.lead_dead_date
1365: = (SELECT TRUNC(MIN(hist.creation_date))
1366: FROM
1367: as_sales_leads_log hist
1368: WHERE
1369: hist.last_update_date between p_start_date and l_sysdate
1370: AND hist.status_code = l_dead_status
1371: AND hist.sales_lead_id = facts.lead_id

Line 1380: as_sales_leads_log hist

1376: )
1377: WHERE
1378: EXISTS (SELECT 1
1379: FROM
1380: as_sales_leads_log hist
1381: WHERE
1382: hist.last_update_date between p_start_date and l_sysdate
1383: AND hist.status_code = l_dead_status
1384: AND hist.sales_lead_id = facts.lead_id

Line 1423: as_sales_leads_log hist

1419: UPDATE bim_i_lead_facts facts
1420: SET facts.lead_closed_date
1421: = (SELECT TRUNC(MIN(hist.creation_date))
1422: FROM
1423: as_sales_leads_log hist
1424: ,as_statuses_b st
1425: WHERE
1426: hist.last_update_date between p_start_date and l_sysdate
1427: AND hist.status_code not in (l_conv_opp_status, l_dead_status)

Line 1439: as_sales_leads_log hist

1435: )
1436: WHERE
1437: EXISTS (SELECT 1
1438: FROM
1439: as_sales_leads_log hist
1440: ,as_statuses_b st
1441: WHERE
1442: hist.last_update_date between p_start_date and l_sysdate
1443: AND hist.status_code not in (l_conv_opp_status, l_dead_status)