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 BIM_I_SOURCE_CODES

Line 675: ,bim_i_source_codes a

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

Line 769: ,bim_i_source_codes a

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

Line 868: ,bim_i_source_codes a

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

Line 968: ,bim_i_source_codes a

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

Line 1068: ,bim_i_source_codes a

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

Line 1160: ,bim_i_source_codes a

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

Line 1250: ,bim_i_source_codes a

1246: ,0 metric1
1247: ,0 metric2
1248: FROM ams_list_entries p
1249: ,ams_act_lists q
1250: ,bim_i_source_codes a
1251: WHERE p.creation_date between p_start_date and p_end_date
1252: AND p.list_header_id = q.list_header_id
1253: AND q.list_used_by = a.child_object_type
1254: AND q.list_used_by_id = a.child_object_id

Line 1339: ,bim_i_source_codes a

1335: ,0 metric1
1336: ,0 metric2
1337: FROM ams_list_entries p
1338: ,ams_act_lists q
1339: ,bim_i_source_codes a
1340: ,ams_campaign_schedules_b sch
1341: WHERE p.creation_date between p_start_date and p_end_date
1342: AND p.list_header_id = q.list_header_id
1343: AND q.list_used_by = 'EONE'

Line 1435: ,bim_i_source_codes A

1431: ,0 conversion_rate_s
1432: ,0 metric1
1433: ,0 metric2
1434: FROM ozf_act_budgets S
1435: ,bim_i_source_codes A
1436: ,ams_source_codes B
1437: WHERE s.act_budget_used_by_id = b.source_code_for_id
1438: AND s.arc_act_budget_used_by = b.arc_source_code_for
1439: AND b.source_code_id = a.source_code_id

Line 1538: ,bim_i_source_codes A

1534: ,0 conversion_rate_s
1535: ,0 metric1
1536: ,0 metric2
1537: FROM ozf_act_budgets S
1538: ,bim_i_source_codes A
1539: ,ams_source_codes B
1540: WHERE s.arc_act_budget_used_by = 'FUND'
1541: AND s.parent_act_budget_id IS NULL
1542: AND s.budget_source_type = b.arc_source_code_for

Line 1636: ,bim_i_source_codes A

1632: ,0 conversion_rate_s
1633: ,sum(nvl(s.approved_amount,0)) metric1
1634: ,0 metric2
1635: FROM ozf_act_budgets S
1636: ,bim_i_source_codes A
1637: ,ams_source_codes B
1638: WHERE s.act_budget_used_by_id = b.source_code_for_id
1639: AND s.arc_act_budget_used_by = b.arc_source_code_for
1640: AND b.source_code_id = a.source_code_id

Line 1733: ,bim_i_source_codes A

1729: ,0 conversion_rate_s
1730: ,0-sum(nvl(s.approved_amount,0)) metric1
1731: ,0 metric2
1732: FROM ozf_act_budgets S
1733: ,bim_i_source_codes A
1734: ,ams_source_codes B
1735: WHERE s.arc_act_budget_used_by = 'FUND'
1736: AND s.budget_source_type = b.arc_source_code_for
1737: AND s.budget_source_id = b.source_code_for_id

Line 1827: ,bim_i_source_codes A

1823: ,0 conversion_rate_S
1824: ,0 metric1
1825: ,0 metric2
1826: FROM ams_event_registrations X
1827: ,bim_i_source_codes A
1828: WHERE trunc(X.last_reg_status_date) between p_start_date and p_end_date+0.99999
1829: AND X.event_offer_id = A.child_object_id
1830: AND A.child_object_type ='EVEO'
1831: AND a.object_type NOT IN ('RCAM')

Line 1915: ,bim_i_source_codes A

1911: ,0 conversion_rate_S
1912: ,0 metric1
1913: ,0 metric2
1914: FROM ams_event_registrations X
1915: ,bim_i_source_codes A
1916: WHERE trunc(X.last_reg_status_date) between p_start_date and p_end_date+0.99999
1917: AND X.event_offer_id = A.object_id
1918: AND A.object_type ='EONE'
1919: AND a.object_type NOT IN ('RCAM')

Line 2213: ,bim_i_source_codes a

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

Line 2304: ,bim_i_source_codes a

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

Line 2396: ,bim_i_source_codes a

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

Line 2487: ,bim_i_source_codes a

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

Line 2668: FROM bim_i_source_codes s,

2664: ,0
2665: ,0
2666: ,0
2667: ,0
2668: FROM bim_i_source_codes s,
2669: bim_i_marketing_facts f
2670: where s.child_object_id = 0
2671: and f.child_object_id(+) = 0
2672: and s.object_id = f.object_id (+)

Line 2804: FROM bim_i_source_codes s,

2800: ,0
2801: ,null
2802: ,0
2803: ,0
2804: FROM bim_i_source_codes s,
2805: bim_i_marketing_facts f
2806: where s.child_object_id > 0
2807: and f.child_object_id(+) > 0
2808: and s.child_object_id = f.child_object_id (+)

Line 3381: ,bim_i_source_codes a

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

Line 3472: ,bim_i_source_codes a

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

Line 3561: FROM bim_i_source_codes a

3557: ,0 BUDGET_APPROVED_S
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

Line 3651: FROM bim_i_source_codes a

3647: ,0 BUDGET_APPROVED_S
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')

Line 3744: ,bim_i_source_codes a

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

Line 3834: ,bim_i_source_codes a

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

Line 3922: ,bim_i_source_codes a

3918: ,0 metric1
3919: ,0 metric2
3920: FROM ams_list_entries p
3921: ,ams_act_lists q
3922: ,bim_i_source_codes a
3923: WHERE p.creation_date between p_start_date and p_end_date
3924: AND p.list_header_id = q.list_header_id
3925: AND q.list_used_by = a.child_object_type
3926: AND q.list_used_by_id = a.child_object_id

Line 4009: ,bim_i_source_codes a

4005: ,0 metric1
4006: ,0 metric2
4007: FROM ams_list_entries p
4008: ,ams_act_lists q
4009: ,bim_i_source_codes a
4010: ,ams_campaign_schedules_b sch
4011: WHERE p.creation_date between p_start_date and p_end_date
4012: AND p.list_header_id = q.list_header_id
4013: AND q.list_used_by = 'EONE'

Line 4099: ,bim_i_source_codes A

4095: ,0 conversion_rate_s
4096: ,0 metric1
4097: ,0 metric2
4098: FROM ozf_act_budgets S
4099: ,bim_i_source_codes A
4100: ,ams_source_codes B
4101: WHERE s.act_budget_used_by_id = b.source_code_for_id
4102: AND s.arc_act_budget_used_by = b.arc_source_code_for
4103: AND b.source_code_id = a.source_code_id

Line 4190: ,bim_i_source_codes A

4186: ,0 conversion_rate_s
4187: ,0 metric1
4188: ,0 metric2
4189: FROM ozf_act_budgets S
4190: ,bim_i_source_codes A
4191: ,ams_source_codes B
4192: WHERE s.arc_act_budget_used_by = 'FUND'
4193: AND s.parent_act_budget_id IS NULL
4194: AND s.budget_source_type = b.arc_source_code_for

Line 4279: ,bim_i_source_codes A

4275: ,0 conversion_rate_s
4276: ,sum(nvl(s.approved_amount,0)) metric1
4277: ,0 metric2
4278: FROM ozf_act_budgets S
4279: ,bim_i_source_codes A
4280: ,ams_source_codes B
4281: WHERE s.act_budget_used_by_id = b.source_code_for_id
4282: AND s.arc_act_budget_used_by = b.arc_source_code_for
4283: AND b.source_code_id = a.source_code_id

Line 4369: ,bim_i_source_codes A

4365: ,0 conversion_rate_s
4366: ,0-sum(nvl(s.approved_amount,0)) metric1
4367: ,0 metric2
4368: FROM ozf_act_budgets S
4369: ,bim_i_source_codes A
4370: ,ams_source_codes B
4371: WHERE s.arc_act_budget_used_by = 'FUND'
4372: AND s.budget_source_type = b.arc_source_code_for
4373: AND s.budget_source_id = b.source_code_for_id

Line 4457: ,bim_i_source_codes A

4453: ,0 conversion_rate_S
4454: ,0 metric1
4455: ,0 metric2
4456: FROM ams_event_registrations X
4457: ,bim_i_source_codes A
4458: WHERE trunc(X.last_reg_status_date) between p_start_date and p_end_date+0.99999
4459: AND X.event_offer_id = A.child_object_id
4460: AND A.child_object_type ='EVEO'
4461: AND a.object_type NOT IN ('RCAM')

Line 4541: ,bim_i_source_codes A

4537: ,0 conversion_rate_S
4538: ,0 metric1
4539: ,0 metric2
4540: FROM ams_event_registrations X
4541: ,bim_i_source_codes A
4542: WHERE trunc(X.last_reg_status_date) between p_start_date and p_end_date+0.99999
4543: AND X.event_offer_id = A.object_id
4544: AND A.object_type ='EONE'
4545: AND a.object_type NOT IN ('RCAM')

Line 4775: FROM bim_i_source_codes a

4771: ,0 BUDGET_APPROVED_S
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

Line 4866: FROM bim_i_source_codes a

4862: ,0 BUDGET_APPROVED_S
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')

Line 4957: FROM bim_i_source_codes a

4953: ,0 BUDGET_APPROVED_S
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

Line 5047: FROM bim_i_source_codes a

5043: ,0 BUDGET_APPROVED_S
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')

Line 5336: FROM bim_i_source_codes a

5332: ,0
5333: ,0
5334: ,0
5335: ,0
5336: FROM bim_i_source_codes a
5337: where a.child_object_id =0
5338: and a.obj_last_update_date >l_sc_s_date
5339: and not exists (
5340: select b.object_id,b.object_type from

Line 5614: FROM bim_i_source_codes a

5610: ,0
5611: ,null
5612: ,0
5613: ,0
5614: FROM bim_i_source_codes a
5615: where a.child_object_id >0
5616: and a.obj_last_update_date >l_sc_s_date
5617: and not exists (
5618: select b.child_object_id,b.child_object_type from