[Home] [Help]
669: ,0 BUDGET_APPROVED_S
670: ,0 conversion_rate_s
671: ,0 metric1
672: ,0 metric2
673: FROM ams_act_metric_hst f3
674: ,ams_metrics_all_b g3
675: ,bim_i_source_codes a
676: WHERE f3.last_update_date between p_start_date and p_end_date
677: AND f3.arc_act_metric_used_by = a.object_type
763: ,0 BUDGET_APPROVED_S
764: ,0 conversion_rate_s
765: ,0 metric1
766: ,0 metric2
767: FROM ams_act_metric_hst f3
768: ,ams_metrics_all_b g3
769: ,bim_i_source_codes a
770: WHERE f3.last_update_date between p_start_date and p_end_date
771: AND f3.arc_act_metric_used_by IN ('CSCH','EVEO')
862: ,0 BUDGET_APPROVED_S
863: ,0 conversion_rate_s
864: ,0 metric1
865: ,0 metric2
866: FROM ams_act_metric_hst f3
867: ,ams_metrics_all_b g3
868: ,bim_i_source_codes a
869: WHERE f3.last_update_date <= p_end_date
870: AND f3.arc_act_metric_used_by = a.object_type
962: ,0 BUDGET_APPROVED_S
963: ,0 conversion_rate_s
964: ,0 metric1
965: ,0 metric2
966: FROM ams_act_metric_hst f3
967: ,ams_metrics_all_b g3
968: ,bim_i_source_codes a
969: WHERE f3.last_update_date <= p_end_date
970: AND f3.arc_act_metric_used_by IN ('CSCH','EVEO')
1062: ,0 BUDGET_APPROVED_S
1063: ,0 conversion_rate_S
1064: ,0 metric1
1065: ,0 metric2
1066: FROM ams_act_metric_hst f3
1067: ,ams_metrics_all_b g3
1068: ,bim_i_source_codes a
1069: WHERE f3.last_update_date between p_start_date and p_end_date
1070: AND f3.arc_act_metric_used_by = a.object_type
1154: ,0 BUDGET_APPROVED_S
1155: ,0 conversion_rate_S
1156: ,0 metric1
1157: ,0 metric2
1158: FROM ams_act_metric_hst f3
1159: ,ams_metrics_all_b g3
1160: ,bim_i_source_codes a
1161: WHERE f3.last_update_date between p_start_date and p_end_date
1162: AND f3.act_metric_used_by_id = a.child_object_id
2207: ,0 BUDGET_APPROVED_S
2208: ,0 conversion_rate_s
2209: ,0 metric1
2210: ,0 metric2
2211: FROM ams_act_metric_hst f3
2212: ,ams_metrics_all_b g3
2213: ,bim_i_source_codes a
2214: WHERE f3.last_update_date between p_start_date and p_end_date
2215: AND f3.arc_act_metric_used_by = a.object_type
2298: ,0 BUDGET_APPROVED_S
2299: ,0 conversion_rate_s
2300: ,0 metric1
2301: ,0 metric2
2302: FROM ams_act_metric_hst f3
2303: ,ams_metrics_all_b g3
2304: ,bim_i_source_codes a
2305: WHERE f3.last_update_date between p_start_date and p_end_date
2306: AND f3.arc_act_metric_used_by IN ('CSCH','EVEO')
2390: ,0 BUDGET_APPROVED_S
2391: ,0 conversion_rate_s
2392: ,0 metric1
2393: ,0 metric2
2394: FROM ams_act_metric_hst f3
2395: ,ams_metrics_all_b g3
2396: ,bim_i_source_codes a
2397: WHERE f3.last_update_date between p_start_date and p_end_date
2398: AND f3.arc_act_metric_used_by = a.object_type
2481: ,0 BUDGET_APPROVED_S
2482: ,0 conversion_rate_s
2483: ,0 metric1
2484: ,0 metric2
2485: FROM ams_act_metric_hst f3
2486: ,ams_metrics_all_b g3
2487: ,bim_i_source_codes a
2488: WHERE f3.last_update_date between p_start_date and p_end_date
2489: AND f3.arc_act_metric_used_by In ('CSCH','EVEO')
3375: ,0 conversion_rate_s
3376: ,0 metric1
3377: ,0 metric2
3378: FROM
3379: ams_act_metric_hst f3
3380: ,ams_metrics_all_b g3
3381: ,bim_i_source_codes a
3382: WHERE f3.last_update_date between p_start_date and p_end_date
3383: AND f3.arc_act_metric_used_by = a.object_type
3466: ,0 conversion_rate_s
3467: ,0 metric1
3468: ,0 metric2
3469: FROM
3470: ams_act_metric_hst f3
3471: ,ams_metrics_all_b g3
3472: ,bim_i_source_codes a
3473: WHERE f3.last_update_date between p_start_date and p_end_date
3474: AND f3.arc_act_metric_used_by in ('CSCH','EVEO')
3558: ,0 CONVERSION_RATE_S
3559: ,0 metric1
3560: ,0 metric2
3561: FROM bim_i_source_codes a
3562: ,ams_act_metric_hst f1
3563: ,ams_metrics_all_b g1
3564: WHERE f1.last_update_date between p_start_date and p_end_date
3565: AND f1.arc_act_metric_used_by = a.object_type
3566: AND f1.act_metric_used_by_id =a.object_id
3648: ,0 CONVERSION_RATE_S
3649: ,0 metric1
3650: ,0 metric2
3651: FROM bim_i_source_codes a
3652: ,ams_act_metric_hst f1
3653: ,ams_metrics_all_b g1
3654: WHERE f1.last_update_date between p_start_date and p_end_date
3655: AND f1.arc_act_metric_used_by in ('CSCH','EVEO')
3656: AND f1.act_metric_used_by_id =a.child_object_id
3738: ,0 BUDGET_APPROVED_S
3739: ,0 conversion_rate_S
3740: ,0 metric1
3741: ,0 metric2
3742: FROM ams_act_metric_hst f3
3743: ,ams_metrics_all_b g3
3744: ,bim_i_source_codes a
3745: WHERE f3.last_update_date between p_start_date and p_end_date
3746: AND f3.arc_act_metric_used_by = a.object_type
3828: ,0 BUDGET_APPROVED_S
3829: ,0 conversion_rate_S
3830: ,0 metric1
3831: ,0 metric2
3832: FROM ams_act_metric_hst f3
3833: ,ams_metrics_all_b g3
3834: ,bim_i_source_codes a
3835: WHERE f3.last_update_date between p_start_date and p_end_date
3836: AND f3.act_metric_used_by_id = a.child_object_id
4772: ,0 conversion_rate_s
4773: ,0 metric1
4774: ,0 metric2
4775: FROM bim_i_source_codes a
4776: ,ams_act_metric_hst f1
4777: ,ams_metrics_all_b g1
4778: WHERE
4779: f1.arc_act_metric_used_by = a.object_type
4780: AND f1.act_metric_used_by_id = a.object_id
4863: ,0 conversion_rate_s
4864: ,0 metric1
4865: ,0 metric2
4866: FROM bim_i_source_codes a
4867: ,ams_act_metric_hst f1
4868: ,ams_metrics_all_b g1
4869: WHERE
4870: f1.arc_act_metric_used_by in ('CSCH','EVEO')
4871: AND f1.act_metric_used_by_id = a.child_object_id
4954: ,0 conversion_rate_s
4955: ,0 metric1
4956: ,0 metric2
4957: FROM bim_i_source_codes a
4958: ,ams_act_metric_hst f1
4959: ,ams_metrics_all_b g1
4960: WHERE f1.arc_act_metric_used_by = a.object_type
4961: AND f1.act_metric_used_by_id = a.object_id
4962: AND a.object_type NOT IN ('RCAM')
5044: ,0 conversion_rate_s
5045: ,0 metric1
5046: ,0 metric2
5047: FROM bim_i_source_codes a
5048: ,ams_act_metric_hst f1
5049: ,ams_metrics_all_b g1
5050: WHERE
5051: f1.arc_act_metric_used_by in ('CSCH','EVEO')
5052: AND f1.act_metric_used_by_id = a.child_object_id