APPS.BIM_EDW_MKTSGMTS_M_SIZE dependencies on AMS_CELLS_VL

Line 15: FROM AMS_CELLS_VL AMC ,

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

Line 59: FROM AMS_CELLS_VL AMC

55: avg(nvl(vsize( CELL_ID), 0)),
56: avg(nvl(vsize( CELL_CODE), 0)),
57: avg(nvl(vsize( ENABLED_FLAG), 0)),
58: avg(nvl(vsize( DESCRIPTION), 0))
59: FROM AMS_CELLS_VL AMC
60: WHERE AMC.MARKET_SEGMENT_FLAG = 'Y'
61: and last_update_date between
62: p_from_date and p_to_date;
63: