DBA Data[Home] [Help]

APPS.BIM_EDW_IH_RESLT_M_SIZE dependencies on EDW_LOCAL_INSTANCE

Line 16: EDW_LOCAL_INSTANCE INST

12: select sum(cnt)
13: from (
14: select count(*) cnt
15: FROM JTF_IH_RESULTS_VL RSLT ,
16: EDW_LOCAL_INSTANCE INST
17: where RSLT.last_update_date between
18: p_from_date and p_to_date
19: );
20:

Line 66: from EDW_LOCAL_INSTANCE ;

62:
63: CURSOR c_2 IS
64: select
65: avg(nvl(vsize(INSTANCE_CODE), 0))
66: from EDW_LOCAL_INSTANCE ;
67:
68:
69:
70: BEGIN