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.BIM_I_LEAD_FACTS_PKG dependencies on AS_SALES_LEAD_OPPORTUNITY

Line 680: as_sales_lead_opportunity slo

676: UPDATE bim_i_lead_facts facts
677: SET (facts.lead_converted_date, facts.lead_touched_date)
678: = (SELECT TRUNC(MIN(slo.creation_date)), TRUNC(MIN(slo.creation_date))
679: FROM
680: as_sales_lead_opportunity slo
681: WHERE
682: slo.creation_date between p_start_date and l_sysdate
683: AND slo.sales_lead_id = facts.lead_id
684: AND facts.lead_dead_date is null

Line 689: as_sales_lead_opportunity slo

685: )
686: WHERE
687: EXISTS (SELECT 1
688: FROM
689: as_sales_lead_opportunity slo
690: WHERE
691: slo.creation_date between p_start_date and l_sysdate
692: AND slo.sales_lead_id = facts.lead_id
693: AND facts.lead_dead_date is null

Line 1397: as_sales_lead_opportunity slo

1393: UPDATE bim_i_lead_facts facts
1394: SET facts.lead_converted_date
1395: = (SELECT TRUNC(MIN(slo.creation_date))
1396: FROM
1397: as_sales_lead_opportunity slo
1398: WHERE
1399: slo.creation_date between p_start_date and l_sysdate
1400: AND slo.sales_lead_id = facts.lead_id
1401: AND facts.lead_dead_date is null

Line 1408: as_sales_lead_opportunity slo

1404: )
1405: WHERE
1406: EXISTS (SELECT 1
1407: FROM
1408: as_sales_lead_opportunity slo
1409: WHERE
1410: slo.creation_date between p_start_date and l_sysdate
1411: AND slo.sales_lead_id = facts.lead_id
1412: AND facts.lead_dead_date is null