APPS.BIM_EDW_OPPORTUNITIES_M_SIZE dependencies on AS_LEADS_ALL
Line 16: AS_LEADS_ALL OPH ,
12: select sum(cnt)
13: from (
14: select count(*) cnt
15: FROM AS_LEAD_LINES_ALL OPL , 16: AS_LEADS_ALL OPH , 17: EDW_LOCAL_INSTANCE INST
18: WHERE
19: OPH.LEAD_ID = OPL.LEAD_ID AND ( (OPH.LAST_UPDATE_DATE > TO_DATE
20: ('1000/01/01',
Line 66: FROM AS_LEADS_ALL
62:
63: CURSOR c_3 IS
64: SELECT
65: avg(nvl(vsize( LEAD_ID ), 0)) 66: FROM AS_LEADS_ALL 67: where last_update_date between
68: p_from_date and p_to_date;
69:
70: