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_SOURCE_CODES

Line 830: ,ams_source_codes C

826: ,0 positive_responses
827: ,0 targeted_customers
828: FROM
829: ams_campaigns_all_b A
830: ,ams_source_codes C
831: ,as_sales_leads X
832: ,as_statuses_b Y
833: WHERE
834: X.status_code = Y.status_code

Line 872: ,ams_source_codes C

868: ,0 positive_responses
869: ,0 targeted_customers
870: FROM
871: ams_campaigns_all_b A
872: ,ams_source_codes C
873: ,as_leads_all X
874: WHERE
875: A.campaign_id = C.source_code_for_id
876: AND C.arc_source_code_for = 'CAMP'

Line 909: ,ams_source_codes C

905: ,0 positive_responses
906: ,0 targeted_customers
907: FROM
908: ams_campaigns_all_b A
909: ,ams_source_codes C
910: ,as_sales_leads D
911: ,as_sales_lead_opportunity D1
912: ,as_leads_all E
913: ,aso_quote_related_objects F

Line 1094: ,ams_source_codes C

1090: metric.campaign_id
1091: ,metric.creation_date
1092: ) inner
1093: ,ams_campaigns_all_b A
1094: ,ams_source_codes C
1095: ,jtf_loc_hierarchies_b D
1096: WHERE
1097: a.campaign_id = inner.campaign_id
1098: AND A.campaign_id = C.source_code_for_id

Line 1337: ,ams_source_codes C

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
1341: A.schedule_id = C.source_code_for_id

Line 1379: ,ams_source_codes C

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
1383: AND C.arc_source_code_for = 'CSCH'

Line 1416: ,ams_source_codes C

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
1420: ,aso_quote_related_objects F

Line 1677: ,ams_source_codes B1

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
1680: ,jtf_loc_hierarchies_b D2
1681: WHERE

Line 1678: ,ams_source_codes B2

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
1680: ,jtf_loc_hierarchies_b D2
1681: WHERE
1682: e.schedule_id = inner.schedule_id

Line 1867: ,ams_source_codes B2

1863: ,d.area2_code campaign_region_code
1864: ,a.budget_amount_fc campaign_budget_amount
1865: FROM ams_act_budgets S
1866: ,ams_campaigns_all_b A
1867: ,ams_source_codes B2
1868: ,jtf_loc_hierarchies_b D
1869: WHERE s.arc_act_budget_used_by = 'CAMP'
1870: AND s.budget_source_type = 'FUND'
1871: --AND s.transfer_type = 'REQUEST'

Line 1928: ,ams_source_codes B2

1924: ,d.area2_code campaign_region_code
1925: ,a.budget_amount_fc campaign_budget_amount
1926: FROM ams_act_budgets S
1927: ,ams_campaigns_all_b A
1928: ,ams_source_codes B2
1929: ,jtf_loc_hierarchies_b D
1930: WHERE s.arc_act_budget_used_by = 'FUND'
1931: AND s.budget_source_type = 'CAMP'
1932: --AND s.transfer_type = 'REQUEST'

Line 2150: ,ams_source_codes B1

2146: ,e.budget_amount_fc schedule_budget_amount
2147: ,d2.area2_code campaign_region_code
2148: FROM ams_act_budgets S
2149: ,ams_campaigns_all_b A
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

Line 2151: ,ams_source_codes B2

2147: ,d2.area2_code campaign_region_code
2148: FROM ams_act_budgets S
2149: ,ams_campaigns_all_b A
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'

Line 2238: ,ams_source_codes B1

2234: ,e.budget_amount_fc schedule_budget_amount
2235: ,d2.area2_code campaign_region_code
2236: FROM ams_act_budgets S
2237: ,ams_campaigns_all_b A
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

Line 2239: ,ams_source_codes B2

2235: ,d2.area2_code campaign_region_code
2236: FROM ams_act_budgets S
2237: ,ams_campaigns_all_b A
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'

Line 3041: ,ams_source_codes C

3037: ,0 positive_responses
3038: ,0 targeted_customers
3039: FROM
3040: ams_campaigns_all_b A
3041: ,ams_source_codes C
3042: ,as_sales_leads X
3043: ,as_statuses_b Y
3044: WHERE
3045: X.status_code = Y.status_code

Line 3083: ,ams_source_codes C

3079: ,0 positive_responses
3080: ,0 targeted_customers
3081: FROM
3082: ams_campaigns_all_b A
3083: ,ams_source_codes C
3084: ,as_leads_all X
3085: WHERE
3086: A.campaign_id = C.source_code_for_id
3087: AND C.arc_source_code_for = 'CAMP'

Line 3120: ,ams_source_codes C

3116: ,0 positive_responses
3117: ,0 targeted_customers
3118: FROM
3119: ams_campaigns_all_b A
3120: ,ams_source_codes C
3121: ,as_sales_leads D
3122: ,as_sales_lead_opportunity D1
3123: ,as_leads_all E
3124: ,aso_quote_related_objects F

Line 3305: ,ams_source_codes C

3301: metric.campaign_id
3302: ,metric.creation_date
3303: ) inner
3304: ,ams_campaigns_all_b A
3305: ,ams_source_codes C
3306: ,jtf_loc_hierarchies_b D
3307: WHERE
3308: a.campaign_id = inner.campaign_id
3309: AND A.campaign_id = C.source_code_for_id

Line 3549: ,ams_source_codes C

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
3553: A.schedule_id = C.source_code_for_id

Line 3591: ,ams_source_codes C

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
3595: AND C.arc_source_code_for = 'CSCH'

Line 3628: ,ams_source_codes C

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
3632: ,aso_quote_related_objects F

Line 3889: ,ams_source_codes B1

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
3892: ,jtf_loc_hierarchies_b D2
3893: WHERE

Line 3890: ,ams_source_codes B2

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
3892: ,jtf_loc_hierarchies_b D2
3893: WHERE
3894: e.schedule_id = inner.schedule_id

Line 4082: ,ams_source_codes B2

4078: ,d.area2_code campaign_region_code
4079: ,a.budget_amount_fc campaign_budget_amount
4080: FROM ozf_act_budgets S
4081: ,ams_campaigns_all_b A
4082: ,ams_source_codes B2
4083: ,jtf_loc_hierarchies_b D
4084: WHERE s.arc_act_budget_used_by = 'CAMP'
4085: AND s.budget_source_type = 'FUND'
4086: --AND s.transfer_type = 'REQUEST'

Line 4143: ,ams_source_codes B2

4139: ,d.area2_code campaign_region_code
4140: ,a.budget_amount_fc campaign_budget_amount
4141: FROM ozf_act_budgets S
4142: ,ams_campaigns_all_b A
4143: ,ams_source_codes B2
4144: ,jtf_loc_hierarchies_b D
4145: WHERE s.arc_act_budget_used_by = 'FUND'
4146: AND s.budget_source_type = 'CAMP'
4147: --AND s.transfer_type = 'REQUEST'

Line 4365: ,ams_source_codes B1

4361: ,e.budget_amount_fc schedule_budget_amount
4362: ,d2.area2_code campaign_region_code
4363: FROM ozf_act_budgets S
4364: ,ams_campaigns_all_b A
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

Line 4366: ,ams_source_codes B2

4362: ,d2.area2_code campaign_region_code
4363: FROM ozf_act_budgets S
4364: ,ams_campaigns_all_b A
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'

Line 4455: ,ams_source_codes B1

4451: ,e.budget_amount_fc schedule_budget_amount
4452: ,d2.area2_code campaign_region_code
4453: FROM ozf_act_budgets S
4454: ,ams_campaigns_all_b A
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

Line 4456: ,ams_source_codes B2

4452: ,d2.area2_code campaign_region_code
4453: FROM ozf_act_budgets S
4454: ,ams_campaigns_all_b A
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'