APPS.BIM_EDW_CMPGNS_M_SIZE dependencies on AMS_CAMPAIGNS_VL

Line 16: AMS_CAMPAIGNS_VL AMC ,

12: select sum(cnt)
13: from (
14: select count(*) cnt
15: FROM AMS_CAMPAIGN_SCHEDULES AMS ,
16: AMS_CAMPAIGNS_VL AMC ,
17: EDW_LOCAL_INSTANCE INST
18: WHERE AMS.CAMPAIGN_ID = AMC.CAMPAIGN_ID
19: and
20: AMS.last_update_date between

Line 86: from AMS_CAMPAIGNS_VL ;

82:
83: CURSOR c_2 IS
84: select
85: avg(nvl(vsize(campaign_id), 0))
86: from AMS_CAMPAIGNS_VL ;
87:
88:
89: CURSOR c_3 IS
90: select