APPS.BIM_CAMPAIGN_FACTS dependencies on AMS_ACT_BUDGETS

Line 1865: FROM ams_act_budgets S

1861: ,a.business_unit_id business_unit_id
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'

Line 1926: FROM ams_act_budgets S

1922: ,a.business_unit_id business_unit_id
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'

Line 2148: FROM ams_act_budgets S

2144: ,a.business_unit_id business_unit_id
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

Line 2236: FROM ams_act_budgets S

2232: ,a.business_unit_id business_unit_id
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