DBA Data[Home] [Help]

APPS.BIM_EDW_CMPFRCST_F_SIZE dependencies on AMS_METRICS_ALL_B

Line 18: AMS_METRICS_ALL_B AMT ,

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
21: WHERE AMC.CAMPAIGN_ID = AAM.ACT_METRIC_USED_BY_ID
22: AND AAM.ARC_ACT_METRIC_USED_BY = 'CAMP'

Line 37: AMS_METRICS_ALL_B AMT ,

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
40: WHERE AMC.CAMPAIGN_ID = AAM.ACT_METRIC_USED_BY_ID
41: AND AAM.ARC_ACT_METRIC_USED_BY = 'CAMP'