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 EDW_LOCAL_INSTANCE

Line 20: EDW_LOCAL_INSTANCE INST

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
21: WHERE AMC.CAMPAIGN_ID = AAM.ACT_METRIC_USED_BY_ID
22: AND AAM.ARC_ACT_METRIC_USED_BY = 'CAMP'
23: AND AAM.METRIC_ID = AMT.METRIC_ID
24: AND AMT.SUMMARY_METRIC_ID IS NULL AND AMT.METRIC_CATEGORY = 901

Line 39: EDW_LOCAL_INSTANCE INST

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
40: WHERE AMC.CAMPAIGN_ID = AAM.ACT_METRIC_USED_BY_ID
41: AND AAM.ARC_ACT_METRIC_USED_BY = 'CAMP'
42: AND AAM.METRIC_ID = AMT.METRIC_ID AND AMT.SUMMARY_METRIC_ID IS NULL
43: AND AMT.METRIC_CATEGORY = 902 AND AMC.STATUS_CODE NOT IN ( 'NEW',

Line 95: from EDW_LOCAL_INSTANCE ;

91:
92: CURSOR c_2 IS
93: select
94: avg(nvl(vsize(INSTANCE_CODE), 0))
95: from EDW_LOCAL_INSTANCE ;
96:
97:
98:
99: BEGIN