[Home] [Help]
APPS.BIM_EDW_MKTSGMTS_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 AMS_CELLS_VL AMC ,
16: EDW_LOCAL_INSTANCE INST
17: WHERE AMC.MARKET_SEGMENT_FLAG = 'Y'
18: and amc.last_update_date between
19: p_from_date and p_to_date
20: );
Line 68: from EDW_LOCAL_INSTANCE ;
64:
65: CURSOR c_2 IS
66: select
67: avg(nvl(vsize(INSTANCE_CODE), 0))
68: from EDW_LOCAL_INSTANCE ;
69:
70:
71:
72: BEGIN