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_MARKET_FACTS_PKG dependencies on AMS_METRICS_ALL_B

Line 674: ,ams_metrics_all_b g3

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
678: AND f3.act_metric_used_by_id = a.object_id

Line 768: ,ams_metrics_all_b g3

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')
772: AND f3.act_metric_used_by_id = a.child_object_id

Line 867: ,ams_metrics_all_b g3

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
871: AND f3.act_metric_used_by_id = a.object_id

Line 967: ,ams_metrics_all_b g3

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')
971: AND f3.act_metric_used_by_id = a.child_object_id

Line 1067: ,ams_metrics_all_b g3

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
1071: AND f3.act_metric_used_by_id = a.object_id

Line 1159: ,ams_metrics_all_b g3

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
1163: AND f3.ARC_ACT_METRIC_USED_BY = a.child_object_type

Line 2212: ,ams_metrics_all_b g3

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
2216: AND f3.act_metric_used_by_id = a.object_id

Line 2303: ,ams_metrics_all_b g3

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')
2307: AND f3.act_metric_used_by_id = a.child_object_id

Line 2395: ,ams_metrics_all_b g3

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
2399: AND f3.act_metric_used_by_id = a.object_id

Line 2486: ,ams_metrics_all_b g3

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')
2490: AND f3.act_metric_used_by_id = a.child_object_id

Line 3380: ,ams_metrics_all_b g3

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
3384: AND f3.act_metric_used_by_id = a.object_id

Line 3471: ,ams_metrics_all_b g3

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')
3475: AND f3.act_metric_used_by_id = a.child_object_id

Line 3563: ,ams_metrics_all_b g1

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
3567: AND a.child_object_id =0

Line 3653: ,ams_metrics_all_b g1

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
3657: AND f1.ARC_ACT_METRIC_USED_BY = a.child_object_type

Line 3743: ,ams_metrics_all_b g3

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
3747: AND f3.act_metric_used_by_id = a.object_id

Line 3833: ,ams_metrics_all_b g3

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
3837: AND f3.ARC_ACT_METRIC_USED_BY = a.child_object_type

Line 4777: ,ams_metrics_all_b g1

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
4781: AND a.object_type NOT IN ('RCAM')

Line 4868: ,ams_metrics_all_b g1

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
4872: AND a.object_type NOT IN ('RCAM')

Line 4959: ,ams_metrics_all_b g1

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')
4963: AND a.child_object_id = 0

Line 5049: ,ams_metrics_all_b g1

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
5053: AND f1.ARC_ACT_METRIC_USED_BY = a.child_object_type