APPS.BIM_EDW_TGSMT_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_BIM_TGSMT_DENORM BTD ,
17: EDW_LOCAL_INSTANCE INST
18: WHERE AMC.CELL_ID = BTD.TARGET_SEGMENT_ID AND BTD.LEVEL_FROM_ROOT >= 8
19: AND BTD.PARENT_LEVEL_FROM_ROOT = 7

Line 66: FROM AMS_CELLS_VL AMC

62: avg(nvl(vsize(AMC.MARKET_SEGMENT_FLAG), 0)),
63: avg(nvl(vsize(AMC.ENABLED_FLAG), 0)),
64: avg(nvl(vsize(AMC.ORIGINAL_SIZE), 0)),
65: avg(nvl(vsize(AMC.DESCRIPTION), 0))
66: FROM AMS_CELLS_VL AMC
67: WHERE
68: amc.last_update_date between
69: p_from_date and p_to_date;
70: