eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIM_EDW_CMPFRCST_F_SIZE dependencies on AMS_CAMPAIGNS_ALL_B

Line 16: FROM AMS_CAMPAIGNS_ALL_B AMC ,

12: CURSOR c_cnt_rows IS
13: select sum(cnt)
14: from (
15: select count(*) cnt
16: FROM AMS_CAMPAIGNS_ALL_B AMC ,
17: AMS_ACT_METRICS_ALL AAM ,
18: AMS_METRICS_ALL_B AMT ,
19: BIM_EDW_CMPFRCST_INC INC ,
20: EDW_LOCAL_INSTANCE INST

Line 35: FROM AMS_CAMPAIGNS_ALL_B AMC ,

31: AMC.last_update_date between
32: p_from_date and p_to_date
33: UNION ALL
34: select count(*) cnt
35: FROM AMS_CAMPAIGNS_ALL_B AMC ,
36: AMS_ACT_METRICS_ALL AAM ,
37: AMS_METRICS_ALL_B AMT ,
38: BIM_EDW_CMPFRCST_INC INC ,
39: EDW_LOCAL_INSTANCE INST

Line 85: FROM AMS_CAMPAIGNS_ALL_B

81: avg(nvl(vsize( CAMPAIGN_ID), 0)),
82: avg(nvl(vsize( CHANNEL_ID), 0)),
83: avg(nvl(vsize( TRANSACTION_CURRENCY_CODE), 0)),
84: avg(nvl(vsize( ORG_ID), 0))
85: FROM AMS_CAMPAIGNS_ALL_B
86: where last_update_date between
87: p_from_date and p_to_date;
88:
89: