APPS.BIM_EDW_OPPORTUNITIES_M_SIZE dependencies on AS_LEAD_LINES_ALL

Line 15: FROM AS_LEAD_LINES_ALL OPL ,

11: CURSOR c_cnt_rows IS
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

Line 55: FROM AS_LEAD_LINES_ALL;

51:
52: CURSOR c_1 IS
53: SELECT
54: avg(nvl(vsize( LEAD_LINE_ID ), 0))
55: FROM AS_LEAD_LINES_ALL;
56:
57:
58: CURSOR c_2 IS
59: select