APPS.BIM_EDW_OPPORTUNITIES_M_SIZE dependencies on EDW_LOCAL_INSTANCE

Line 17: EDW_LOCAL_INSTANCE INST

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',
21: 'YYYY/MM/DD')) OR (OPL.LAST_UPDATE_DATE > TO_DATE('1000/01/01',

Line 61: from EDW_LOCAL_INSTANCE ;

57:
58: CURSOR c_2 IS
59: select
60: avg(nvl(vsize(INSTANCE_CODE), 0))
61: from EDW_LOCAL_INSTANCE ;
62:
63: CURSOR c_3 IS
64: SELECT
65: avg(nvl(vsize( LEAD_ID ), 0))