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_CAMPAIGN_FACTS dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 1336: ams_campaign_schedules_b A

1332: ,0 forecasted_responses
1333: ,0 positive_responses
1334: ,0 targeted_customers
1335: FROM
1336: ams_campaign_schedules_b A
1337: ,ams_source_codes C
1338: ,as_sales_leads X
1339: ,as_statuses_b Y
1340: WHERE

Line 1378: ams_campaign_schedules_b A

1374: ,0 forecasted_responses
1375: ,0 positive_responses
1376: ,0 targeted_customers
1377: FROM
1378: ams_campaign_schedules_b A
1379: ,ams_source_codes C
1380: ,as_leads_all X
1381: WHERE
1382: A.schedule_id = C.source_code_for_id

Line 1415: ams_campaign_schedules_b A

1411: ,0 forecasted_responses
1412: ,0 positive_responses
1413: ,0 targeted_customers
1414: FROM
1415: ams_campaign_schedules_b A
1416: ,ams_source_codes C
1417: ,as_sales_leads D
1418: ,as_sales_lead_opportunity D1
1419: ,as_leads_all E

Line 1585: FROM ams_campaign_schedules_b A

1581: ,0 actual_cost
1582: ,0 forecasted_responses
1583: ,sum(decode(A.use_parent_code_flag,'Y',0,1)) positive_responses
1584: ,0 targeted_customers
1585: FROM ams_campaign_schedules_b A
1586: ,jtf_ih_interactions X
1587: ,jtf_ih_results_b Y
1588: WHERE
1589: A.source_code = X.source_code

Line 1622: ,ams_campaign_schedules_b A

1618: ,count(p.list_entry_id) targeted_customers
1619: FROM
1620: ams_list_entries p
1621: ,ams_act_lists q
1622: ,ams_campaign_schedules_b A
1623: WHERE
1624: p.list_header_id = q.list_header_id
1625: AND q.list_used_by = 'CSCH'
1626: AND q.list_act_type = 'TARGET'

Line 1659: ,ams_campaign_schedules_b A

1655: ,count(p.list_entry_id) targeted_customers
1656: FROM
1657: ams_list_entries p
1658: ,ams_act_lists q
1659: ,ams_campaign_schedules_b A
1660: WHERE
1661: trunc(p.creation_date) between p_start_date and p_end_date+0.99999
1662: AND p.list_header_id = q.list_header_id
1663: AND q.list_used_by = 'EONE'

Line 1675: ,ams_campaign_schedules_b E

1671: GROUP BY
1672: metric.schedule_id
1673: ,metric.creation_date
1674: ) inner
1675: ,ams_campaign_schedules_b E
1676: ,ams_campaigns_all_b A
1677: ,ams_source_codes B1
1678: ,ams_source_codes B2
1679: ,jtf_loc_hierarchies_b D1

Line 1881: from ams_campaign_schedules_b x

1877: AND a.actual_exec_start_date >= p_start_date
1878: AND a.actual_exec_start_date <= p_end_date
1879: AND decode(s.status_code,'PENDING',trunc(nvl(s.request_date,s.creation_date)),'APPROVED',trunc(nvl(s.approval_date,s.last_update_date)) ) <= p_end_date
1880: AND exists (select distinct campaign_id
1881: from ams_campaign_schedules_b x
1882: where x.campaign_id = a.campaign_id)
1883: GROUP BY s.act_budget_used_by_id
1884: ,decode(s.status_code,'PENDING',trunc(nvl(s.request_date,s.creation_date)),'APPROVED',trunc(nvl(s.approval_date,s.last_update_date)) )
1885: ,b2.source_code_id

Line 1942: from ams_campaign_schedules_b x

1938: AND a.actual_exec_start_date >= trunc(p_start_date)
1939: AND a.actual_exec_start_date <= trunc(p_end_date)
1940: AND s.approval_date <= trunc(p_end_date)
1941: AND exists (select distinct campaign_id
1942: from ams_campaign_schedules_b x
1943: where x.campaign_id = a.campaign_id)
1944: GROUP BY s.budget_source_id
1945: ,trunc(nvl(s.approval_date,s.last_update_date))
1946: ,b2.source_code_id

Line 2154: ,ams_campaign_schedules_b E

2150: ,ams_source_codes B1
2151: ,ams_source_codes B2
2152: ,jtf_loc_hierarchies_b D1
2153: ,jtf_loc_hierarchies_b D2
2154: ,ams_campaign_schedules_b E
2155: WHERE s.arc_act_budget_used_by = 'CSCH'
2156: AND s.budget_source_type = 'FUND'
2157: --AND s.transfer_type = 'REQUEST'
2158: AND s.act_budget_used_by_id = e.schedule_id

Line 2242: ,ams_campaign_schedules_b E

2238: ,ams_source_codes B1
2239: ,ams_source_codes B2
2240: ,jtf_loc_hierarchies_b D1
2241: ,jtf_loc_hierarchies_b D2
2242: ,ams_campaign_schedules_b E
2243: WHERE s.arc_act_budget_used_by = 'FUND'
2244: AND s.budget_source_type = 'CSCH'
2245: --AND s.transfer_type = 'REQUEST'
2246: AND s.budget_source_id = e.schedule_id

Line 3548: ams_campaign_schedules_b A

3544: ,0 forecasted_responses
3545: ,0 positive_responses
3546: ,0 targeted_customers
3547: FROM
3548: ams_campaign_schedules_b A
3549: ,ams_source_codes C
3550: ,as_sales_leads X
3551: ,as_statuses_b Y
3552: WHERE

Line 3590: ams_campaign_schedules_b A

3586: ,0 forecasted_responses
3587: ,0 positive_responses
3588: ,0 targeted_customers
3589: FROM
3590: ams_campaign_schedules_b A
3591: ,ams_source_codes C
3592: ,as_leads_all X
3593: WHERE
3594: A.schedule_id = C.source_code_for_id

Line 3627: ams_campaign_schedules_b A

3623: ,0 forecasted_responses
3624: ,0 positive_responses
3625: ,0 targeted_customers
3626: FROM
3627: ams_campaign_schedules_b A
3628: ,ams_source_codes C
3629: ,as_sales_leads D
3630: ,as_sales_lead_opportunity D1
3631: ,as_leads_all E

Line 3797: FROM ams_campaign_schedules_b A

3793: ,0 actual_cost
3794: ,0 forecasted_responses
3795: ,sum(decode(A.use_parent_code_flag,'Y',0,1)) positive_responses
3796: ,0 targeted_customers
3797: FROM ams_campaign_schedules_b A
3798: ,jtf_ih_interactions X
3799: ,jtf_ih_results_b Y
3800: WHERE
3801: A.source_code = X.source_code

Line 3834: ,ams_campaign_schedules_b A

3830: ,count(p.list_entry_id) targeted_customers
3831: FROM
3832: ams_list_entries p
3833: ,ams_act_lists q
3834: ,ams_campaign_schedules_b A
3835: WHERE
3836: p.list_header_id = q.list_header_id
3837: AND q.list_used_by = 'CSCH'
3838: AND q.list_act_type = 'TARGET'

Line 3871: ,ams_campaign_schedules_b A

3867: ,count(p.list_entry_id) targeted_customers
3868: FROM
3869: ams_list_entries p
3870: ,ams_act_lists q
3871: ,ams_campaign_schedules_b A
3872: WHERE
3873: trunc(p.creation_date) between p_start_date and p_end_date+0.99999
3874: AND p.list_header_id = q.list_header_id
3875: AND q.list_used_by = 'EONE'

Line 3887: ,ams_campaign_schedules_b E

3883: GROUP BY
3884: metric.schedule_id
3885: ,metric.creation_date
3886: ) inner
3887: ,ams_campaign_schedules_b E
3888: ,ams_campaigns_all_b A
3889: ,ams_source_codes B1
3890: ,ams_source_codes B2
3891: ,jtf_loc_hierarchies_b D1

Line 4096: from ams_campaign_schedules_b x

4092: AND trunc(a.actual_exec_start_date) >= trunc(l_min_start_date)
4093: AND a.actual_exec_start_date <= p_end_date
4094: AND decode(s.status_code,'PENDING',trunc(nvl(s.request_date,s.creation_date)),'APPROVED',trunc(nvl(s.approval_date,s.last_update_date)) ) between p_start_date and p_end_date+0.99999
4095: AND exists (select distinct campaign_id
4096: from ams_campaign_schedules_b x
4097: where x.campaign_id = a.campaign_id)
4098: GROUP BY s.act_budget_used_by_id
4099: ,decode(s.status_code,'PENDING',trunc(nvl(s.request_date,s.creation_date)),'APPROVED',trunc(nvl(s.approval_date,s.last_update_date)) )
4100: ,b2.source_code_id

Line 4159: from ams_campaign_schedules_b x

4155: AND a.actual_exec_start_date <= trunc(p_end_date)
4156: --AND s.approval_date <= trunc(p_end_date)
4157: AND s.approval_date between p_start_date and p_end_date+0.99999
4158: AND exists (select distinct campaign_id
4159: from ams_campaign_schedules_b x
4160: where x.campaign_id = a.campaign_id)
4161: GROUP BY s.budget_source_id
4162: ,trunc(nvl(s.approval_date,s.last_update_date))
4163: ,b2.source_code_id

Line 4369: ,ams_campaign_schedules_b E

4365: ,ams_source_codes B1
4366: ,ams_source_codes B2
4367: ,jtf_loc_hierarchies_b D1
4368: ,jtf_loc_hierarchies_b D2
4369: ,ams_campaign_schedules_b E
4370: WHERE s.arc_act_budget_used_by = 'CSCH'
4371: AND s.budget_source_type = 'FUND'
4372: --AND s.transfer_type = 'REQUEST'
4373: AND s.act_budget_used_by_id = e.schedule_id

Line 4459: ,ams_campaign_schedules_b E

4455: ,ams_source_codes B1
4456: ,ams_source_codes B2
4457: ,jtf_loc_hierarchies_b D1
4458: ,jtf_loc_hierarchies_b D2
4459: ,ams_campaign_schedules_b E
4460: WHERE s.arc_act_budget_used_by = 'FUND'
4461: AND s.budget_source_type = 'CSCH'
4462: --AND s.transfer_type = 'REQUEST'
4463: AND s.budget_source_id = e.schedule_id