APPS.BIM_CAMPAIGN_FACTS dependencies on AMS_CAMPAIGNS_ALL_B

Line 829: ams_campaigns_all_b A

825: ,0 forecasted_responses
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

Line 871: ams_campaigns_all_b A

867: ,0 forecasted_responses
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

Line 908: ams_campaigns_all_b A

904: ,0 forecasted_responses
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

Line 1078: FROM ams_campaigns_all_b A

1074: ,0 actual_cost
1075: ,0 forecasted_responses
1076: ,count(Y.result_id) positive_responses
1077: ,0 targeted_customers
1078: FROM ams_campaigns_all_b A
1079: ,jtf_ih_interactions X
1080: ,jtf_ih_results_b Y
1081: WHERE
1082: A.source_code = X.source_code

Line 1093: ,ams_campaigns_all_b A

1089: GROUP BY
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

Line 1676: ,ams_campaigns_all_b A

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

Line 1866: ,ams_campaigns_all_b A

1862: ,a.city_id campaign_country_code
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'

Line 1927: ,ams_campaigns_all_b A

1923: ,a.city_id campaign_country_code
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'

Line 2149: ,ams_campaigns_all_b A

2145: ,a.city_id campaign_country_code
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

Line 2237: ,ams_campaigns_all_b A

2233: ,a.city_id campaign_country_code
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

Line 3040: ams_campaigns_all_b A

3036: ,0 forecasted_responses
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

Line 3082: ams_campaigns_all_b A

3078: ,0 forecasted_responses
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

Line 3119: ams_campaigns_all_b A

3115: ,0 forecasted_responses
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

Line 3289: FROM ams_campaigns_all_b A

3285: ,0 actual_cost
3286: ,0 forecasted_responses
3287: ,count(Y.result_id) positive_responses
3288: ,0 targeted_customers
3289: FROM ams_campaigns_all_b A
3290: ,jtf_ih_interactions X
3291: ,jtf_ih_results_b Y
3292: WHERE
3293: A.source_code = X.source_code

Line 3304: ,ams_campaigns_all_b A

3300: GROUP BY
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

Line 3888: ,ams_campaigns_all_b A

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

Line 4081: ,ams_campaigns_all_b A

4077: ,a.city_id campaign_country_code
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'

Line 4142: ,ams_campaigns_all_b A

4138: ,a.city_id campaign_country_code
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'

Line 4364: ,ams_campaigns_all_b A

4360: ,a.city_id campaign_country_code
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

Line 4454: ,ams_campaigns_all_b A

4450: ,a.city_id campaign_country_code
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