DBA Data[Home] [Help]

APPS.BIM_EDW_CMPFRCST_F_SIZE dependencies on BIM_EDW_CMPFRCST_INC

Line 19: BIM_EDW_CMPFRCST_INC INC ,

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
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

Line 38: BIM_EDW_CMPFRCST_INC INC ,

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
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