APPS.BIM_CAMPAIGN_FACTS dependencies on AMS_METRICS_ALL_B

Line 963: ,ams_metrics_all_b g3

959: ,0 positive_responses
960: ,0 targeted_customers
961: FROM
962: ams_act_metric_hst f3
963: ,ams_metrics_all_b g3
964: WHERE
965: f3.arc_act_metric_used_by = 'CAMP'
966: AND g3.metric_calculation_type IN ('MANUAL','FUNCTION')
967: AND g3.metric_category = 902

Line 1004: ,ams_metrics_all_b g1

1000: ,0 positive_responses
1001: ,0 targeted_customers
1002: FROM
1003: ams_act_metric_hst f1
1004: ,ams_metrics_all_b g1
1005: WHERE
1006: f1.arc_act_metric_used_by = 'CAMP'
1007: AND g1.metric_category = 901
1008: AND g1.metric_id = f1.metric_id

Line 1043: ,ams_metrics_all_b g3

1039: ,0 positive_responses
1040: ,0 targeted_customers
1041: FROM
1042: ams_act_metric_hst f3
1043: ,ams_metrics_all_b g3
1044: WHERE
1045: f3.arc_act_metric_used_by = 'CAMP'
1046: AND g3.metric_calculation_type IN ('MANUAL','FUNCTION')
1047: AND g3.metric_category = 903

Line 1470: ,ams_metrics_all_b g3

1466: ,0 positive_responses
1467: ,0 targeted_customers
1468: FROM
1469: ams_act_metric_hst f3
1470: ,ams_metrics_all_b g3
1471: WHERE
1472: f3.arc_act_metric_used_by = 'CSCH'
1473: AND g3.metric_calculation_type IN ('MANUAL','FUNCTION')
1474: AND g3.metric_category = 902

Line 1511: ,ams_metrics_all_b g1

1507: ,0 positive_responses
1508: ,0 targeted_customers
1509: FROM
1510: ams_act_metric_hst f1
1511: ,ams_metrics_all_b g1
1512: WHERE
1513: f1.arc_act_metric_used_by = 'CSCH'
1514: AND g1.metric_category = 901
1515: AND g1.metric_id = f1.metric_id

Line 1550: ,ams_metrics_all_b g3

1546: ,0 positive_responses
1547: ,0 targeted_customers
1548: FROM
1549: ams_act_metric_hst f3
1550: ,ams_metrics_all_b g3
1551: WHERE
1552: f3.arc_act_metric_used_by = 'CSCH'
1553: AND g3.metric_calculation_type IN ('MANUAL','FUNCTION')
1554: AND g3.metric_category = 903

Line 3174: ,ams_metrics_all_b g3

3170: ,0 positive_responses
3171: ,0 targeted_customers
3172: FROM
3173: ams_act_metric_hst f3
3174: ,ams_metrics_all_b g3
3175: WHERE
3176: f3.arc_act_metric_used_by = 'CAMP'
3177: AND g3.metric_calculation_type IN ('MANUAL','FUNCTION')
3178: AND g3.metric_category = 902

Line 3215: ,ams_metrics_all_b g1

3211: ,0 positive_responses
3212: ,0 targeted_customers
3213: FROM
3214: ams_act_metric_hst f1
3215: ,ams_metrics_all_b g1
3216: WHERE
3217: f1.arc_act_metric_used_by = 'CAMP'
3218: AND g1.metric_category = 901
3219: AND g1.metric_id = f1.metric_id

Line 3254: ,ams_metrics_all_b g3

3250: ,0 positive_responses
3251: ,0 targeted_customers
3252: FROM
3253: ams_act_metric_hst f3
3254: ,ams_metrics_all_b g3
3255: WHERE
3256: f3.arc_act_metric_used_by = 'CAMP'
3257: AND g3.metric_calculation_type IN ('MANUAL','FUNCTION')
3258: AND g3.metric_category = 903

Line 3682: ,ams_metrics_all_b g3

3678: ,0 positive_responses
3679: ,0 targeted_customers
3680: FROM
3681: ams_act_metric_hst f3
3682: ,ams_metrics_all_b g3
3683: WHERE
3684: f3.arc_act_metric_used_by = 'CSCH'
3685: AND g3.metric_calculation_type IN ('MANUAL','FUNCTION')
3686: AND g3.metric_category = 902

Line 3723: ,ams_metrics_all_b g1

3719: ,0 positive_responses
3720: ,0 targeted_customers
3721: FROM
3722: ams_act_metric_hst f1
3723: ,ams_metrics_all_b g1
3724: WHERE
3725: f1.arc_act_metric_used_by = 'CSCH'
3726: AND g1.metric_category = 901
3727: AND g1.metric_id = f1.metric_id

Line 3762: ,ams_metrics_all_b g3

3758: ,0 positive_responses
3759: ,0 targeted_customers
3760: FROM
3761: ams_act_metric_hst f3
3762: ,ams_metrics_all_b g3
3763: WHERE
3764: f3.arc_act_metric_used_by = 'CSCH'
3765: AND g3.metric_calculation_type IN ('MANUAL','FUNCTION')
3766: AND g3.metric_category = 903